Prints pages that include unused formulas/functions

  • Thread starter Bob Umlas Excel MVP
  • Start date
B

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
Click to expand...
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
Click to expand...
the entire length of the worksheet is so that users will
not have to edit, fill down each time they use the
worksheet.
 
G

gtcyberaz

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 "A1:D9". Is there a way to maintain the function as the print area.

Greg
 
G

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
 
Top