Worksheets

Saturday, October 9, 2010

How to format columns and rows in Excel 2007?

Formatting Row Height
  1. Select the row index number which needs to be formatted. Excel provides a maximum of 65,536 rows.
  2. Right click and select Row Height from the pop up menu.
  3. Enter the required height. Excel limits the height of rows between 0 and 409 points.
  4. When the row height is 0 it appears to be hidden.

Formatting Column Width
  1. Select the column index number which needs to be formatted. Excel provides a maximum of 256 columns.
  2. Right click and select Column Width from the pop up menu.
  3. Enter the required width. Excel limits the width of rows between 0 and 255 characters
  4. When the column height is 0 it appears to be hidden.

No comments:

Post a Comment