I want to print only cells with data without selecting the range everytime. How do I do that?
T tkagate May 30, 2006 #1 I want to print only cells with data without selecting the range everytime. How do I do that?
C CarlosAntenna May 30, 2006 #2 File > Print Area > Clear Print Area Excel will automatically determine the used area and set the print area accordingly.
File > Print Area > Clear Print Area Excel will automatically determine the used area and set the print area accordingly.
S Sandy Mann May 30, 2006 #3 CarlosAntenna said: File > Print Area > Clear Print Area Excel will automatically determine the used area and set the print area accordingly. Click to expand... Unless the empty cell have borders around them. It can be done with a BeforePrint event resetting the Print Area depending on how the data is laid out. -- Regards Sandy In Perth, the ancient capital of Scotland [email protected] [email protected] with @tiscali.co.uk
CarlosAntenna said: File > Print Area > Clear Print Area Excel will automatically determine the used area and set the print area accordingly. Click to expand... Unless the empty cell have borders around them. It can be done with a BeforePrint event resetting the Print Area depending on how the data is laid out. -- Regards Sandy In Perth, the ancient capital of Scotland [email protected] [email protected] with @tiscali.co.uk
