Faq/Calc/013

How do I see all the rows and columns? Some of them are hidden.
The Hide command allows all the rows or columns in a selected area to be hidden:
 * 1) Select the area of the sheet where you want rows and/or columns to be hidden.
 * 2) * To hide rows, go to.
 * 3) * To hide columns go to.
 * 1) * To hide columns go to.

The Show command allows you to display all the rows or columns in a selected area:
 * 1) Select the area of the sheet where the rows and/or columns are hidden. You can select the whole sheet using, or by hitting , or else by clicking in the empty gray square at the intersection of the headers for the rows (1,2,3...) and the columns (A, B, C...)
 * 2) * To display all the rows, choose :
 * 3) * Similarly to display all the columns, choose.
 * 1) * Similarly to display all the columns, choose.

What do you do if the first row or column is hidden?
 * 1) Select the second row or column (click in its header and keep the mouse button down).
 * 2) Drag the mouse towards the empty square in the corner.
 * 3) Release the button and go to  or . The row or column reappears.