AutoFit
Excel's AutoFit feature automatically adjusts a column's width or a row's height so it's only as wide or as high as it needs to be to display the information within it. This is a great way to adjust columns and rows to use worksheet space more efficiently.
To use AutoFit
1. | Select the column(s) or row(s) for which you want to change the width or height (Figure 76).
Figure 76. Select the columns for which you want to change the width. |
2. | Choose Format > Column > AutoFit Selection (Figure 68) or Format > Column > AutoFit (Figure 69).
or
Double-click on the border to the right of the column heading (Figure 65) or below the row heading (Figure ... |
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.