View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Removing the print area dost from the screen

If you close the file and reopen it, those lines will be gone.

But they'll come back as soon as you print or print preview that sheet.

In xl2003 menus, you can hide those dotted lines:
Tools|Options|View tab|Uncheck page breaks

And to reset the print range (which may be what you really want):
File|Print area|clear print area



DubboPete wrote:

Hi all,

I did a silly thing and set an area as the print area.

Now, onscreen, I see the print area outlined by dotted lines.
Mistake....

I desperately want to remove the dotted lines. Is there any way of
doing this?

I want to display the spreadsheet thru a projector to over 200 people,
and I don't want the (silly print area) dotted lines !

TIA

DubboPete


--

Dave Peterson