dotted lines around print area
 

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.

dotted lines around print area
 

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
"Gringo" wrote in message
...
| 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.

dotted lines around print area
 

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

"Jim Rech" wrote:

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
"Gringo" wrote in message
...
| 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.