NewDeal Hot Tip 1009
NewCalcA 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.
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!
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.
Last Modified 28 Feb 1999