Excel Can't see print range I set

I just opened an old Lotus file in Excel, re-did the macros and formatting where needed, and went to set a print range with "Print Area - Set Print Area." It prints O.K., but it doesn't show the dashed lines around the print area. I tried to set a page break by clicking on the row header and using "Insert - Page Break" and again, no page break. The print area shows in "Print Preview", but not the page break.

I inserted a new sheet, and was able to do all the above.

Possible corruption due to it originally being a Lotus spreadsheet?

Check your options. Page breaks can be toggled on and off on the View tab under Window Options. I suspect you have View Page Breaks de-selected.

-Ben

I checked my options and the page break was on. I was able to drag a soft page break down and make it a hard page break, but I still don't see the outline around the print range in a normal view. Oh, well. It's an imperfect world.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

Can't see print range I set

Re: Can't see print range I set

Re: Thanks, Ben