This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2007

Hiding Columns, Rows, and Cells

At times, there may be information in your worksheet which you no longer need to see. At other times, you might be printing your worksheet and want to print only columns A–F and columns H–J, skipping column G. Rather than rearrange your worksheet for either of these examples, you can simply hide the information. You can also hide information in specific cells.

return to topHiding Columns

You can hide columns of your worksheet containing information that you do not need to view or do not want to print.

  1. Select a cell within the column(s) to be hidden

  2. On the Home command tab, in the Cells group, click FORMATFormat Cells button

  3. From the Format menu, in the Visibility section, select Hide & Unhide » Hide Columns
    The column is hidden.

Hiding Columns: Quick Menu Option

  1. Right click the column ID » select Hide

return to topRedisplaying Columns

  1. Select at least one cell from both of the columns around the hidden column(s) to be redisplayed
    EXAMPLE: If column B is hidden, select a cell from both columns A and C.
    HINT: If you cannot select the appropriate cells, you can use the Go To command.

  2. On the Home command tab, in the Cells group, click FORMATFormat Cells button

  3. From the Format menu, in the Visibility section, select Hide & Unhide » Unhide Columns
    The column reappears.

Redisplaying Columns: Quick Menu Option

This option works well for redisplaying column A, since there are not columns on both sides of column A.

  1. Hold your cursor between column IDs on the right side of the hidden column
    The cursor will change to an open, double sided arrow as shown here.
    Cursor as an open, double sided arrow

  2. Right click » select Unhide

return to topHiding Rows

You can hide rows containing information that you do not need to view or do not want to print.

  1. Select a cell within the row(s) to be hidden

  2. On the Home command tab, in the Cells group, click FORMATFormat Cells button

  3. From the Format menu, in the Visibility section, select Hide & Unhide » Hide Rows
    The row is hidden.

Hiding Rows: Quick Menu Option

  1. Right click the row ID » select Hide
    The row is hidden.

return to topRedisplaying Rows

  1. Select at least one cell from both of the rows around the hidden row(s) to be redisplayed
    EXAMPLE: If row 5 is hidden, select a cell from rows 4 and 6.
    HINT: If you cannot select the appropriate cells, you can use the Go To command.

  2. On the Home command tab, in the Cells group, click FORMATFormat Cells button

  3. From the Format menu, in the Visibility section, select Hide & Unhide » Unhide Rows
    The row appears.

Redisplaying Rows: Quick Menu Option

This option works well for redisplaying row 1, since there are not rows on both sides of row 1.

  1. Hold your cursor between row IDs where the hidden row is located
    The cursor will change to an open, double sided arrow as shown here.
    Cursor as an open, double sided arrow

  2. Right click » select Unhide

return to topHiding Cell Contents

You have the ability to hide the contents of individual cells if you do not need to view their contents or you simply do not want to print certain cells.

  1. Select the cell(s) to be hidden

  2. From the Home command tab, in the Cells group, click FORMATFormat Cells button » select Format Cells...
    The Format Cells dialog box appears.

  3. Select the Number tab

  4. Under Category, select Custom

  5. In the Type text box, type three semicolons ( ;;; )
    Format Cell dialog box, number tab

  6. Click OK
    The cells are now hidden.

To redisplay cell information:

  1. Select the cell(s) to be redisplayed

  2. From the Home command tab, in the Cells group, click FORMATFormat Cells button » select Format Cells...
    The Format Cells dialog box appears.

  3. Select the Number tab

  4. Under Category, make the appropriate selection
    The dialog box refreshes to display options corresponding to the selected category.

  5. Select the desired options

  6. Click OK
    The cell(s) reappear.

Excellence. Our Measure. Our Motto. Our Goal.