Formatting Cell Dimensions

Your worksheet can contain many different types of data that occupy different amounts of space. Excel creates all worksheets using a default setting for the width of the columns and the height of the rows. As you start entering your information, you might find that some columns are too narrow, resulting in truncated content. In other columns, you might find that some columns are too wide, resulting in wasted space. Similarly, you might want to increase the height of the rows to increase the readability of the content. Although a row will automatically increase in height if you increase the font size of its content, you might want to increase the height of the row and then change the vertical alignment of the text to add space above or below the content.

Set the Column Width

  1. Select the columns whose widths you want to change.

  2. Right-click one of the selected column headers, and choose Column Width from the shortcut menu to display the Column Width dialog box.

  3. Specify the width of the columns, calculated by the number of characters of the default font that can be displayed on one line.

  4. Click OK.

    Set the Column Width

Tip

Tip

To select the entire worksheet, click the blank header between the "1" row header and the "A" column header. If the cells in the area you want to format are contiguous—that is, all the cells are adjacent to one another—just click in any one of the cells before you choose AutoFormat, and Excel will figure out the area to be formatted.

Tip

Tip

To change the vertical alignment of text in one or more rows, select the cells to be adjusted, and then click the Top Align, Middle Align, or Bottom Align button in the Alignment section of the Home tab.

Try This!

Try This!

On the Page Layout tab, click the Background button. Find a picture that you like or that’s relevant to your data, and click Open. Format your data so that it’s easily readable on top of your picture. Now that’s adding some real interest to your formatting!

Set the Row Height

  1. Select the rows whose heights you want to change.

  2. Right-click one of the selected row headers, and choose Row Height from the shortcut menu to display the Row Height dialog box.

  3. Specify the height of the rows in points.

  4. Click OK.

    Set the Row Height

Adjust the Height or Width to Fit the Content

  1. Select the cells that you want to format.

  2. On the Home tab, click the Format button, and choose AutoFit Row Height from the drop-down menu.

  3. Click the Format button again, and choose AutoFit Column width from the drop-down menu.

    Adjust the Height or Width to Fit the Content
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset