Some of the rows or columns in my spreadsheet are hidden. How do I see all rows or columns?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Jump to: navigation, search


Some of the rows or columns in my spreadsheet are hidden. How do I see all rows or columns?


  1. Select the area of the spreadsheet where rows or columns are hidden. To select the entire spreadsheet, select Edit → Select All from the main menu or press  CTRL  +  A 
  2. To show all rows, select Format → Row → Show from the main menu
    To show all columns, select Format → Column → Show from the main menu.


Personal tools