Set print area

[falcios]

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]

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.