Excel offers ways to customize the appearance of the worksheet display. In this post, we share how to:

• Modify the width of some or all the columns
• Change rows in any of the three worksheets.

Setting column width

If you’re working on a spreadsheet that requires a different standard column width, you can easily set a default width for every column in the worksheet:

1. Choose Format -> Column➪Standard Width. Excel opens the Standard Width dialog box.
2. Enter the new width in characters (between 0 and 255) in the Standard Column Width text box.
3. Click OK to close the Standard Width dialog box.

Changing the value in the Standard Width dialog box changes the default column width for all the columns in only the active worksheet. Using this command has no effect on the width of columns that you manually resized or resized with the AutoFit feature.

Setting a new standard row height

Note that Excel doesn’t provide an equivalent command for setting a new default height for all the rows in a worksheet. The program automatically adjusts the height of the row to accommodate the data that you enter in its columns. If you’re creating a spreadsheet where you would benefit by having a new standard row height (a taller one), you can set all the rows in the worksheet to a new height by using this work-around:

1. Click a letter in the Column header. Clicking a column letter in the Column header selects all the rows in that column in the worksheet.
2. Choose Format-> Row -> Height. Excel opens the Row Height dialog box
3. Enter the new row height in characters (between 0 and 255) in the Row Height text box.
4. Click the OK button to close the Row Height dialog box.

Excel changes the height of all the rows in the worksheet. To remove the cell selection from all the rows in the column whose heading you clicked, click any single cell with the mouse pointer.