Changing Column/Row
Sizes using Column/Row Control ButtonsThis section covers
Changing Column/Row
Sizes using Column/Row Control Buttons
Changing
Column/Row Sizes using Format Menu
In some specific cases, Excel automatically adjusts the row heights and column widths. For example, in case of numeric data, Excel may change the column width depending on the data type and data value. Excel also changes the row height when the font size is increased or the "wrap text" alignment feature is chosen.
When a user wants to change the sizes of rows or columns, the following methods can be used.
The row and column headings also act as control buttons and can be used to change the sizes of rows and columns. The options available are:
|
Changing Column and Row Sizes Manually: |
Use your mouse to drag the right boundary of a column or the bottom boundary of a row until you get the desired size. |
| Adjust the Sizes Automatically (AutoFit): |
Double-click the right boundary of a column or the bottom boundary of a row. The column/row will resize itself to accommodate the largest entry. |
Note: If you select multiple rows/columns and use the boundary of one of them for double-clicking, the sizes of the selected rows/columns will be automatically adjusted. If you click on the Select All button at the top left corner of the worksheet (see Animation), and then double-click on a row/column boundary the AutoFit option will adjust the sizes of all the rows/columns in the worksheet.
To change row or column sizes, using the Format menu, follow these steps:
Select the rows or columns
Choose Format-->Row--> Autofit or Format-->Column--> Autofit Selection to automatically adjust the sizes, OR
Choose Format-->Row--> Height or Format-->Column--> Width to adjust the sizes Manually
|
|
