Skip to main content
logo logo
ICT Skills 4

Do you know how to hide/display a row or column? (9/32)

Yes

Find out

Hide

Sometimes you may want to hide rows or columns in a worksheet. Typically, you will want to hide several columns or rows. 

To hide rows or columns: 

  1. Select the row(s) or column(s). 
  2. From the Format menu choose Row or Column.
  3. Click Hide.
Hiding and displaying rows and columns

Display

If, on the other hand, you want to display a hidden row or column:

  1. Select the rows above and below the rows you want to display. In the case of columns, select the columns on the left and on the right of the columns you want to display.
  2. from the Format menu choose Row or Column. 
  3. Click Unhide.

If the first row or column of your worksheet is hidden: 

  1. Go to the Edit menu. 
  2. Click Go To.
  3. Type A1 in the Reference box. 
  4. Click OK. 
  5. From the Format menu choose Row or Column. 
  6. Click Unhide.

Why is this information important for translators and translation teachers?
In order to temporarily reduce the size of a worksheet and make it more manageable during translation, translators can hide rows or columns during translation to focus on the current cells with their respective headings. Of course, after translating, they must be able to re-display the hidden rows and columns.

Next