Setting print areas
 

I have a workbook with 12 worksheets (12 months) and need to have about 10
specific print areas within a worksheet that are the same for the whole
workbook. Is there a way of defining it without creating areas one worksheet
at the time? Can one standard area be defined in one worksheet and be applied
automatically in the whole workbook?
--
Thanks

Setting print areas
 

To learn:
record a macro while setting one worksheet. Now encompass into a loop macro
for each ws in worksheets
ws. blah
next ws

--
Don Guillett
SalesAid Software

"jaclh2o" wrote in message
...
I have a workbook with 12 worksheets (12 months) and need to have about 10
specific print areas within a worksheet that are the same for the whole
workbook. Is there a way of defining it without creating areas one
worksheet
at the time? Can one standard area be defined in one worksheet and be
applied
automatically in the whole workbook?
--
Thanks

Setting print areas
 

Print Ranges and rows to repeat at top cannot be set on grouped sheets without
using VBA.

See this google thread for code.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP

On Fri, 27 Apr 2007 12:18:01 -0700, jaclh2o
wrote:

I have a workbook with 12 worksheets (12 months) and need to have about 10
specific print areas within a worksheet that are the same for the whole
workbook. Is there a way of defining it without creating areas one worksheet
at the time? Can one standard area be defined in one worksheet and be applied
automatically in the whole workbook?

Setting print areas
 

Yes:

Press the Shift key, and then click on each sheet tab to group all the sheet
in to one.

Then follow these procedure to define a custom view for printing:

1. On the View menu, click Custom Views.
2. In the Views box, click the name of the view (view: A set of display and
print settings that you can name and apply to a workbook. You can create more
than one view of the same workbook without saving separate copies of the
workbook.) you want to print.
3. Click Show.
4. Click Print .

Note Microsoft Excel saves previously defined print areas (print area: One
or more ranges of cells that you designate to print when you don't want to
print the entire worksheet. If a worksheet includes a print area, only the
print area is printed.) for each sheet in the workbook with your view. If a
sheet has no defined print areas, Microsoft Excel prints the entire worksheet.

Challa Prabhu


"jaclh2o" wrote:

I have a workbook with 12 worksheets (12 months) and need to have about 10
specific print areas within a worksheet that are the same for the whole
workbook. Is there a way of defining it without creating areas one worksheet
at the time? Can one standard area be defined in one worksheet and be applied
automatically in the whole workbook?
--
Thanks

Setting print areas
 

challa

Have you tested your method?

Custom Views is not available for grouped sheets.


Gord Dibben MS Excel MVP

On Sun, 29 Apr 2007 23:50:02 -0700, challa prabhu
wrote:

Yes:

Press the Shift key, and then click on each sheet tab to group all the sheet
in to one.

Then follow these procedure to define a custom view for printing:

1. On the View menu, click Custom Views.
2. In the Views box, click the name of the view (view: A set of display and
print settings that you can name and apply to a workbook. You can create more
than one view of the same workbook without saving separate copies of the
workbook.) you want to print.
3. Click Show.
4. Click Print .

Note Microsoft Excel saves previously defined print areas (print area: One
or more ranges of cells that you designate to print when you don't want to
print the entire worksheet. If a worksheet includes a print area, only the
print area is printed.) for each sheet in the workbook with your view. If a
sheet has no defined print areas, Microsoft Excel prints the entire worksheet.

Challa Prabhu


"jaclh2o" wrote:

I have a workbook with 12 worksheets (12 months) and need to have about 10
specific print areas within a worksheet that are the same for the whole
workbook. Is there a way of defining it without creating areas one worksheet
at the time? Can one standard area be defined in one worksheet and be applied
automatically in the whole workbook?
--
Thanks

Setting print areas
 

Thanks Gord Dibben. I appolige. Normally I check before sending the reply to
any post. I will check again.

Challa Prabhu

"Gord Dibben" wrote:

challa

Have you tested your method?

Custom Views is not available for grouped sheets.


Gord Dibben MS Excel MVP

On Sun, 29 Apr 2007 23:50:02 -0700, challa prabhu
wrote:

Yes:

Press the Shift key, and then click on each sheet tab to group all the sheet
in to one.

Then follow these procedure to define a custom view for printing:

1. On the View menu, click Custom Views.
2. In the Views box, click the name of the view (view: A set of display and
print settings that you can name and apply to a workbook. You can create more
than one view of the same workbook without saving separate copies of the
workbook.) you want to print.
3. Click Show.
4. Click Print .

Note Microsoft Excel saves previously defined print areas (print area: One
or more ranges of cells that you designate to print when you don't want to
print the entire worksheet. If a worksheet includes a print area, only the
print area is printed.) for each sheet in the workbook with your view. If a
sheet has no defined print areas, Microsoft Excel prints the entire worksheet.

Challa Prabhu


"jaclh2o" wrote:

I have a workbook with 12 worksheets (12 months) and need to have about 10
specific print areas within a worksheet that are the same for the whole
workbook. Is there a way of defining it without creating areas one worksheet
at the time? Can one standard area be defined in one worksheet and be applied
automatically in the whole workbook?
--
Thanks