NewDeal Hot Tip 1013

[Hot Tips for...] NewCalc

Hiding Columns and Rows in NewCalc

To Hide Columns

  1. 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.
  2. Choose Cell Width in the Cell menu and change the value to 0 (zero) points.
  3. Click OK.

To Get Hidden Columns Back

  1. Select the columns on either side of the hidden columns (for instance, select A and D if you hid columns B and C).
  2. Choose Cell Width from the Cell menu and enter the default cell width of 64 pts, or choose Best Fit.
  3. Click OK. Your columns will reappear.

To Hide Rows

This is very similar to hiding columns.
  1. Select the row or rows you want to hide, or select cells in the rows you want to hide.
  2. Choose Row Height in the Cell menu.
  3. Deselect Automatic and change the value to 0 (zero) points.
  4. Click OK and the rows will disappear.

To Get Hidden Rows Back

  1. Select the rows above and below the hidden rows.
  2. Choose Row Height from the Cell menu.
  3. Select Automatic. Alternately, you can enter the default row height of 15 points.
  4. 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