ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Set print area (https://www.excelbanter.com/excel-worksheet-functions/255565-set-print-area.html)

falcios

Set print area
 
Excel 2002

Is there a way in which Excel can set the print area by selecting all the
cells that have contents? Is there any key/toolbar functions that sets the
print area automatically?

Thanks in advance.

OssieMac

Set print area
 
If you clear any set print area and then execute print, Excel automatically
prints all data or in other words automatically sets the print area to the
used area.

--
Regards,

OssieMac


"falcios" wrote:

Excel 2002

Is there a way in which Excel can set the print area by selecting all the
cells that have contents? Is there any key/toolbar functions that sets the
print area automatically?

Thanks in advance.



All times are GMT +1. The time now is 11:07 AM.

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