dotted lines around print area

G

Guest

Some worksheets within a workbook with place dotted lines around the print
area and others won't. I have set the page breaks in options to on. I want
the dotted lines. I've tried everything I can think of.
 
J

Jim Rech

If you have the Page Setup "Scaling" option set to "Fit to" rather than
"Adjust to" Excel does not use (or show) automatic or manual page breaks.
That may be the cause of what you see (or don't see in this case).

--
Jim
| Some worksheets within a workbook with place dotted lines around the print
| area and others won't. I have set the page breaks in options to on. I
want
| the dotted lines. I've tried everything I can think of.
 
G

Guest

Thanks Jim. That's really sneaky of MS. I couldn't find the solution
anywhere in the help online info. It worked great!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top