Syndication20 Jul 2008 - 10:46:38 am
Adjusting Row Appearance in Excel 2007
Adjusting Row Appearance in Excel 2007
Just as you may modify the column appearance in Excel, the program also provides tools for adjusting row appearance in Excel 2007. Certain data - like text - may take up significantly more room than simple numeric entries do. In such a case, you may find that adjusting row appearance provides a more optimal viewing experience.
To adjust row height using the mouse, simply position your mouse cursor over the bottom border of the numbered row you want to adjust. Your cursor will change. Click the mouse and drag the row to the height you wish to use. Excel will indicate the point value (and pixel value) of the row. Selecting multiple rows will enable to you to change all selected rows at one time.
To specify a precise row height, select one cell in the row or rows you want to change. Select Home > Format > Height. Type in the new row height in points. Click OK. All selected rows will reflect your change.
Excel also provides an Auto Fit feature for adjusting row appearance in Excel 2007. To use it, click the header of the row you wish to adjust. Select Home > Format > Auto Fit. Excel will automatically optimize row height to accommodate the data in the row. Excel will return you to the active worksheet.
You may also apply appearance changes to non-adjacent rows within Excel. To select non-adjacent rows, press the Alt key and click each row you wish to alter. Drag one row to the desired height with the mouse or access the Row Height dialog box as described earlier. Enter your changes and click OK. All selected non-adjacent rows will be changed.
In addition, you may use the formatting buttons in the Alignment section of the Home tab to change the appearance of data within a row. Wrap Text, Merge Cells and Orientation are the only formatting controls that can affect the height of a row automatically when they are applied.
Just as you may modify the column appearance in Excel, the program also provides tools for adjusting row appearance in Excel 2007. Certain data - like text - may take up significantly more room than simple numeric entries do. In such a case, you may find that adjusting row appearance provides a more optimal viewing experience.
To adjust row height using the mouse, simply position your mouse cursor over the bottom border of the numbered row you want to adjust. Your cursor will change. Click the mouse and drag the row to the height you wish to use. Excel will indicate the point value (and pixel value) of the row. Selecting multiple rows will enable to you to change all selected rows at one time.
To specify a precise row height, select one cell in the row or rows you want to change. Select Home > Format > Height. Type in the new row height in points. Click OK. All selected rows will reflect your change.
Excel also provides an Auto Fit feature for adjusting row appearance in Excel 2007. To use it, click the header of the row you wish to adjust. Select Home > Format > Auto Fit. Excel will automatically optimize row height to accommodate the data in the row. Excel will return you to the active worksheet.
You may also apply appearance changes to non-adjacent rows within Excel. To select non-adjacent rows, press the Alt key and click each row you wish to alter. Drag one row to the desired height with the mouse or access the Row Height dialog box as described earlier. Enter your changes and click OK. All selected non-adjacent rows will be changed.
In addition, you may use the formatting buttons in the Alignment section of the Home tab to change the appearance of data within a row. Wrap Text, Merge Cells and Orientation are the only formatting controls that can affect the height of a row automatically when they are applied.
No Comment for this post yet...