How to format columns and rows in Excel 2007?
Formatting Row Height
- Select the row index number which needs to be formatted. Excel provides a maximum of 65,536 rows.
- Right click and select Row Height from the pop up menu.
- Enter the required height. Excel limits the height of rows between 0 and 409 points.
- When the row height is 0 it appears to be hidden.
Formatting Column Width
- Select the column index number which needs to be formatted. Excel provides a maximum of 256 columns.
- Right click and select Column Width from the pop up menu.
- Enter the required width. Excel limits the width of rows between 0 and 255 characters
- When the column height is 0 it appears to be hidden.
No comments:
Post a Comment