MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can't insert or view Page Breaks

Posted by EIU on March 14, 2001 10:38 AM

Can't install or view page breaks (Excel 2000). When I go to Tools - Options - View tab and look under Window Options, it shows a check in the page breaks box, but it is also greyed or ghosted out and I cannot select or unselect it. This is just happening on one worksheet in the workbook. The worksheet page is not protected.

Posted by ml on March 14, 2001 11:48 AM

are different sheets in different views?
normal vs page break preview
you also can't do page breaks if you set the page setup
to fit to m x n pages instead of 100%