Print Ranges

P

Phil Williams

Some of my spreadsheets are 200 lines deep and 30 columns wide. There might be three pages on each that I need to print and I have been setting the print area three times in each worksheet to print the required pages. When I used Lotus years ago I was able to set and name ranges which simplified the process of printing multiple, specific pages. If this can be done on Excel I would appreciate your help.
 
K

Katherine Coombs

Hi Phil,

When you select the print area via File-->Print Area -->Set Print Area (as
you have been doing), a named range is automatically created, named
Print_Area. Go to Insert-->Name-->Define and you can see (and modify) this
there. You can set multiple areas, such as the following:

='Sheet1'!$A$1:$G$6,'Sheet1'!$A$8:$G$11

HTH,
Katherine

Phil Williams said:
Some of my spreadsheets are 200 lines deep and 30 columns wide. There
Click to expand...
might be three pages on each that I need to print and I have been setting
the print area three times in each worksheet to print the required pages.
When I used Lotus years ago I was able to set and name ranges which
simplified the process of printing multiple, specific pages. If this can be
done on Excel I would appreciate your help.
 
P

Phil Williams

Thanks Katherine

I hope something really nice happens for you to repay you for the enourmous amount of time you'll save me

Regards

Phil.
 
D

Dave Peterson

One more way.

Select your first range
Hold the control key and select your second range
ctrl-select your third range

(now all 3 areas should be selected)

File|Print Area|Set Print Area
 
Top