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