ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print Range (https://www.excelbanter.com/excel-discussion-misc-queries/164179-print-range.html)

Trish

Print Range
 
Hi, I am using Excel 2003. I have set my print range, but that only shows
if I were to do an actual preview or print. If I click on the button above
the 1 and to the left of A (does that button have a name?), it selects the
whole worksheet, not my print range. Is there a quick way I can select my
print range so that I can click and move? Many thanks. Trish :-)

FSt1

Print Range
 
hi
if you have your print area set, the work Print_Area will appear in the name
box. the name box in to the left of the formula bar and just above the column
A letter.
Click the dropdown arrow then click Print_Area.

Regards
FSt1

"Trish" wrote:

Hi, I am using Excel 2003. I have set my print range, but that only shows
if I were to do an actual preview or print. If I click on the button above
the 1 and to the left of A (does that button have a name?), it selects the
whole worksheet, not my print range. Is there a quick way I can select my
print range so that I can click and move? Many thanks. Trish :-)


Trish

Print Range
 
Thanks for quick response, which was very helpful. What do they call the
button above the 1 and to the left of A, which selects the whole worksheet?
Thanks. Trish

"FSt1" wrote:

hi
if you have your print area set, the work Print_Area will appear in the name
box. the name box in to the left of the formula bar and just above the column
A letter.
Click the dropdown arrow then click Print_Area.

Regards
FSt1

"Trish" wrote:

Hi, I am using Excel 2003. I have set my print range, but that only shows
if I were to do an actual preview or print. If I click on the button above
the 1 and to the left of A (does that button have a name?), it selects the
whole worksheet, not my print range. Is there a quick way I can select my
print range so that I can click and move? Many thanks. Trish :-)



All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com