Print Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
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
 
Back
Top