• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 73).

Figure 73. Select the columns for which you want to change the width.


2.
Choose Format > Column > AutoFit Selection (Figure 65) or Format > Column > AutoFit (Figure 66).

or

Double-click on the border to the right of the column heading (Figure 62) or below the row heading (Figure 63).

The column width or row height changes to fit cell contents (Figure 74).

Figure 74. When you choose the AutoFit Selection command, the width of the columns changes so they're only as wide as they need to be to fit cell contents.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint