A finished spreadsheet can often be made to look more attractive by hiding the cells containing intermediate calculations so that only the important data input and result areas are shown.

In Calligra Sheets you can hide selected rows or columns by using the Hide Rows and Hide Columns options from the Format → Row, Format → Column or right mouse button menus. Hidden rows and columns are not displayed on the screen or included in a print out.

Hiding cells in this way also makes them slightly less prone to accidental change.

To un-hide a row or column select Row → Show Rows... or Column → Show Columns... from the Format menu. In the dialog box which appears, you can select any number of rows to show.