Show or hide rows or columns

Hiding some content of a full sheet or workbook can make it easier to find the most important data.

Do any of the following:

Hide rows and columns

  1. Select the row or column that you want to hide.

  2. On the Format menu, point to either Row or Column, and then click Hide.

Show hidden rows and columns

  1. Do one of the following:

To

Do this

Display hidden rows

Select cells in the row above and in the row under the hidden rows.

Display hidden columns

Select cells in the column to the left and in the column to the right of the hidden columns.

Display all hidden columns or rows

Select all cells on the sheet by clicking the Select All triangle at the upper-left corner of the sheet grid.

Ikonet Vælg alle celler

Billedtekst 1 Triangle

  1. On the Format menu, point to either Row or Column, and then click Unhide.

    Bemærk: If the first row or column of a sheet is hidden, on the Edit menu, click Go To. In the Reference box, type A1, and then click OK. On the Format menu, point to either Row or Column, and then click Unhide.

See also

Change column width or row height

Move or copy cells, rows, or columns

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×