print area

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

denhar - 07 Jun 2005 00:36 GMT

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

Reply to this Message

Bob Umlas - 07 Jun 2005 13:15 GMT

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)

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

Reply to this Message

denhar - 07 Jun 2005 14:34 GMT

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

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

Bob Umlas Wrote:

> If there's no print area defined, then all cells containing information
> will
[quoted text clipped - 13 lines]
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=376952

Signature

denhar

Reply to this Message

Dave Peterson - 07 Jun 2005 18:14 GMT

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

> but if you do not select a print area, then other blank cells will print
> as well
[quoted text clipped - 25 lines]
> denhar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24089
> View this thread: http://www.excelforum.com/showthread.php?threadid=376952

Signature

Dave Peterson

Reply to this Message