Naming sections of a worksheet for reporting

M

Michael

I have a somewhat long worksheet. I now highlight and area
of the worksheet and call it a print area. What I would
like to do is have one section of the worksheet called
Revenue, another maybe Costs, and another All which I
could refer to before printing. Is there a way to do this?
Thanks. Michael
 
J

JMay

Check out Custom-Views, under Menu-View
One-at-a-time, set up the Print Area the very way you want it,
then go to View, Custom-View, and NameIt1
Then go to the next Print Area and set it up the way you want it,
then go to Veiw, Custom-View, and Nameit2
Do all you want,,
When you want to Print a given area go to View, Custom-View
Click on the Area you want, then SHOW!
Print..
 
G

Gord Dibben

In addition, once you have the Custom Views setup, check out the Report
Manager Add-in which allows you to build print reports based on the Custom
Views.

Gord Dibben XL2002
 
T

Timbo

I've been trying to use the combination of Custom Views and Repor
Manager with a fairly large file for Excel (7MB) and it crashes ever
time at a different spot. I'm using Office XP with the latest update
and a workstation with 513MB of RAM. All I can say is keep it lean an
simple
 
Top