Note that this tip also works to make a spreadsheet larger to fit the screen as well. It doesn't matter that you only selected cells from one row (or column if doing it the other way) - Excel will scale according to the longest dimension (in this example the dimension was width rather than height). This will make the cells you selected fit exactly into the width of your screen. Choose View, Zoom, then select Fit Selection.Select one row of cells from the spreadsheet range you want to see (e.g. To fit your spreadsheet exactly to the screen - let's say you want to reduce the width of it so you can see all the columns fitting snugly into the width of your screen, with no screen space wasted, simply follow these steps: Often, it will make your spreadsheet too small or not small enough. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn't always give you the result you want. Shrink to fit is useful in cases where you have a fixed column width and text that varies somewhat in length. Your table will fit on the page between the left and right margins. In this video we show you how Shrink to fit works. Select AutoFit Window from the drop down menu. Click the Layout tab and select the AutoFit icon from the Cell Size group. If you work with large Excel spreadsheets, you'll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. How do I resize a table in Word to fit the page Make sure your cursor is inside the table so you can see the Table Tools tab on the ribbon.
0 Comments
Leave a Reply. |