NewDeal Hot Tip 1013
Hiding Columns and Rows in NewCalc
To Hide Columns
Select the column or columns you want to hide by clicking on the column ruler
heading, or by pressing and dragging across the desired columns. Or simply
select cells in the columns you wish to hide.
Choose Cell Width in the Cell menu and change the value to
0 (zero) points.
To Get Hidden Columns Back
Select the columns on either side of the hidden columns (for instance,
select A and D if you hid columns B and C).
Choose Cell Width from the Cell menu and enter the default cell width
of 64 pts, or choose Best Fit.
Click OK. Your columns will reappear.
To Hide Rows
This is very similar to hiding columns.
- Select the row or rows you want to hide, or select cells in the rows you
want to hide.
- Choose Row Height in the Cell menu.
- Deselect Automatic and change the value to 0 (zero) points.
- Click OK and the rows will disappear.
To Get Hidden Rows Back
- Select the rows above and below the hidden rows.
- Choose Row Height from the Cell menu.
- Select Automatic. Alternately, you can enter the default row height
of 15 points.
- Click OK.
Printing When You Have Hidden Rows or Columns
Hidden columns and rows will not print. By default, NewCalc will print
things like cell borders and spreadsheet rulers. If you choose to print
the spreadsheet rulers with your file, the ruler will look just like it
does on screen. For instance, the ruler looks and prints like this when
column C is hidden: A B D E
If you don't want the rulers to print, remember to choose Page Setup
in the File menu and deselect that option.
The time it takes to hide or unhide rows or columns is a fraction of the
time it took to read this tip.
Return to Index
Last Modified 28 Feb 1999