StarOffice™ 5.2 Calc Handbook

Hiding Rows and Columns

There may be occasions when you want to hide certain rows or columns in a spreadsheet, both on the screen and when you print the spreadsheet. For example, you may want to print out a phone extension list of your employees (to be used by everyone in the office), but that same spreadsheet lists the salary of each employee (which is sensitive information; not to be seen by everyone).

All you have to do is hide the row or column that contains the sensitive information. The information will “disappear” from the screen and in your printout. Be advised, however, that hiding rows or columns is a very easy process to reverse. If you wish to hide elements of a spreadsheet and then password-protect this action, you will need to use ...