Can I save different print areas?

[Bob Newman]

Excel 2010
I have a fairly large spreadsheet that I often have to print different areas of. Rather than go to each area in turn each time and select the variousareas to print will Excel let me save several different print areas? ThenI could chose which area I wanted to print from a list of predefined areas?

Thanks in advance... Bob

 

[isabelle]

hi Bob,

you can name ranges of cells, and then select each range by her name and print
the selection

isabelle

Le 2014-12-28 17:08, Bob Newman a écrit :

 

[isabelle]

also:
on the worksheet, select the cells that you want to define as the print area
you can create multiple print areas by holding down CTRL and clicking the areas
that you want to print
each print area in a worksheet is printed as a separate page
then you can choose the pages you want print

http://office.microsoft.com/en-ca/e...lle-de-calcul-HP010342418.aspx#BMsetprintarea

isabelle

Le 2014-12-28 23:01, isabelle a écrit :

 

[Bob Newman]

also:
on the worksheet, select the cells that you want to define as the print area
you can create multiple print areas by holding down CTRL and clicking theareas
that you want to print
each print area in a worksheet is printed as a separate page
then you can choose the pages you want print

http://office.microsoft.com/en-ca/e...lle-de-calcul-HP010342418.aspx#BMsetprintarea

isabelle

Le 2014-12-28 23:01, isabelle a écrit :

Thanks Isabelle it is greatly appreciated.

Bob