Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Self Adjusting Print Area
Is there a way to set the print area so that it automatically adjusts down as
new lines are added? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Self Adjusting Print Area
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Self Adjusting Print Area
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Self Adjusting Print Area
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra Row in Defined Print Area | Excel Discussion (Misc queries) | |||
Can't Clear Print Area | Excel Discussion (Misc queries) | |||
Volatile print area | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |