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

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

After you have named your range, simply select that range (from the Name
Box) then select FilePrint and choose Selection from the Print What
area of the Print dialog box. Click Preview to verify this is what you
want then click Print or just click OK to print without previewing.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=389977

A million thanks Trevor! Cheers :) Kelly

"Trevor Shuttleworth" wrote:

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

Hi Kelly, you are very welcome. Thanks for the feedback ... very positive !


"Kelly" wrote in message
...
A million thanks Trevor! Cheers :) Kelly

"Trevor Shuttleworth" wrote:

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