dotted lines around print area

G

Gringo

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

Gringo

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