How to Display page breaks in normal view in Microsoft Excel

[Kungfu Pandey]

Hi friends , I could click on Tools/Options and then tick the "view page breaks" box, so that I could see dotted lines representing my page sizes in workbook (normal) view, but I can't find a similar command in Microsoft Excel, apart from Page Break Preview" view, which doesn't really suit what I want. Can somebody help please? Any of the reply will be thanks and appreciated.

[QUENBY]

According to my information you should try to make use of View|PageBreak View since in Excel you can still edit the worksheet with the help of this view. If it looks too small use the zoom slider on the status bar. This is one of the simple way to Display page breaks in normal view in Microsoft Excel.

[Leanne]

To Display page breaks in normal view in Microsoft Excel. You just try this out may it help, so for that you just have to go to the Office Button and then go to Excel Options button and from there go to Advanced and then Display options for this worksheet (about half way down) with the help of option Show Page Breaks. And with this Page breaks should be automatically added to your sheet the first time you go to print preview.