Prints pages that include unused formulas/functions

[Bob Umlas Excel MVP]

Define your print area (Insert/Name/Define Print_Area) as
=OFFSET($A$1,0,0,COUNTA($A:$A),4)

Then your print area will grow as your data grows.

-----Original Message-----
I have created a rather simple spreadsheet that data is

entered into the first 3 columns, the fourth contains a
formula/function. I have pasted this formula from row one
to the end of the worksheet (entire column). Even though
data has only been added to, for example, the first 5 rows
in columns 1 thru 3 and calculations in the same rows the
print would like to include almost 1800 pages
(environmentalists would kill me!).

How can I make the number of pages consistent with my basic data input for the day.

P.S. the reason I want to put the functions throughout

the entire length of the worksheet is so that users will
not have to edit, fill down each time they use the
worksheet.

 

[Guest]

Bob,

Your solution worked with one exception. Subsequent to entering the formula "=OFFSET($A$1,0,0,COUNTA($A:$A),4)" for the print area and printing, excel replaces the function with a standard range.

i.e. Excel changes the print area from a function to "A19". Is there a way to maintain the function as the print area.

Greg

 

[Gord Dibben]

gt

Bob's formula is entered into the Insert>Name>Define "Refers to" box.

Is that where you placed it? If so, did you give it a name like MyPrintArea?

Gord Dibben Excel MVP