Thread: print name
View Single Post
  #2   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

Kelly

press F5 (GoTo) and then select the range name (consolidated).

Now press Print and choose "Selection"

Use Preview to make sure that you will print what you want.

Regards

Trevor


"Kelly" wrote in message
...
hello -

Isn't one able to create a name (range) in a spreadsheet then print that
specific area without having to reset the print area each time? for
example,
if I set a1:f70 as a named called "consolidated", can't I then select
"consolidated" and just print that area? If so, how do I go about setting
that range?

Thank you!
Kelly