print area

[denhar]

is there a way for Excel to automatically choose a print area just b
acknowledging all cells that have text/numbers

 

[Bob Umlas]

If there's no print area defined, then all cells containing information will
print. If you currently have one defined, simply delete it!
(Insert/Name/Define, select Print_Area & delete)

 

[denhar]

but if you do not select a print area, then other blank cells will print
as well



--------------------------------------------------

 

[Dave Peterson]

Are those other blank cells empty or do they contain formulas that evaluate to
"" (so they look blank, but contain formulas)?

If the cells are empty, then excel should figure out what the print range should
be (if you leave it to its own devices).

If you've ever set the print range, make sure you clear the print range:
file|Print area|clear print area