NewDeal Hot Tip 1009

[Hot Tips for...] NewCalc

NewCalc Printing Tips

Page Breaks

NewCalc doesn't recognize page break commands, so you can't "insert" a page break in NewCalc. Here's what you can do:
  1. Choose the Scale To Fit option in Page Setup.
  2. Then select the range that you want to print on the first page and print it.
  3. Then select the range you want to print on page two and print that.
  4. Then select the range you want to print on page three and print that. And so on.
That way, you have exactly the data you want on each page. It takes a few moments, but probably no more time than it would take to insert page breaks if that feature was available.

A tip: Make a list in some unused portion of the spreadsheet of the ranges that you would like to print for each page. That way, when it is time to print out a page, you'll have a reference for entering the range data in the Print dialog box.

Printing Area and Graphics

Here's a handy tip for setting the print area of a spreadsheet. NewCalc's default print area is from the upper left occupied cell to the lower right occupied cell.

If you have some graphic or text in a title area at the top and maybe a logo at the bottom, they will not print (because they're not inside the area bounded by occupied cells) unless you highlight the entire area you want to print or you manually type in the range in the print dialog box.

One way to get the graphics areas inside the default print area is make NewCalc think the upper left cell and the lower right cell of your desired print area are occupied. You can do that by typing a quote mark (") into the cell. The cell now has data in it but the quote will not print.

Try this: Make a sheet using a graphics box at the top of the page and a text box at the bottom of the page. Make the occupied cells in the sheet from A7 to G32. This is the print area when you print the sheet, click the print button now the extra graphics and text wouldn't print. Then type a quote mark into cell A1 and into cell G39. This expands the print area and brings the graphics and text boxes inside the occupied cells area. Now printing the whole document is as easy as clicking the print icon!

Print Range Shortcut

Let's say you have a spreadsheet with several different ranges that you like to print out separately. Instead of trying to remember the ranges by their definitions (A1:G32 or SP104:VX238, for example), you can use the Define Name feature to give each range a name and then use those names in the Print dialog box.

Define Name is in the Formula menu. In the Define Name dialog box, give each range a name, perhaps something easy to remember like PAGE_ONE or PRINTMEFIRST or TOTALS.

Then when you print, in the Print dialog box, instead of entering the range by its beginning and ending cell column and row definitions, enter the name you defined in the Print Range field.

Return to Index

Last Modified 28 Feb 1999