Self Adjusting Print Area

[Paperback Writer]

Is there a way to set the print area so that it automatically adjusts down as
new lines are added?

[Dave Peterson]

Excel is pretty smart. It should adjust when you add new rows.

In fact, you may find that excel doesn't react to rows that are deleted. You
can use some of the techniques at Debra Dalgleish's site to reset that last used
cell:

http://www.contextures.com/xlfaqApp.html#Unused

Paperback Writer wrote:
>
> Is there a way to set the print area so that it automatically adjusts down as
> new lines are added?

--

Dave Peterson

[Dave Peterson]

ps. And this assumes that you haven't explicitly set the print range.

Paperback Writer wrote:
>
> Is there a way to set the print area so that it automatically adjusts down as
> new lines are added?

--

Dave Peterson

[Ron Coderre]

If Excel isn't choosing the correct print range automatically (possibly due
to outlying cells you don't want included, you might try something like this:

<Insert><Name><Define>
Names in workbook: Print_Area

If your print data begins in A1:D1 and you want it to continue through the
last nonblank cell in Col_A...

Where there may be blanks within Col_A:
Refers to:
=OFFSET(Sheet3!$A$1:$D$1,,,MAX(MATCH(10^99,Sheet3!A:A),MATCH(REPT("z",255),Sheet3!$A:$A)))

If there will be no blanks in Col_A then:
Refers to: =OFFSET(Sheet3!$A$1:$D$1,,,COUNTA(Sheet3!$A:$A))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Paperback Writer" wrote:

> Is there a way to set the print area so that it automatically adjusts down as
> new lines are added?