Display page breaks in normal view in Excel 2007

[Guest]

Hi
In Excel 2003, 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 Excel 2007,
apart from Page Break Preview" view, which doesn't really suit what I want.
Can somebody help please?

 

[Bernard Liengme]

Why not use View|PageBreak View since in XL2007 you can still edit the
worksheet in this view?
If it looks too small use the zoom slider on the status bar.
best wishes

 

[Guest]

Office Button > Excel Options button > Advanced > Display options for this
worksheet (about half way down) > Show Page Breaks

Page breaks should be automatically added to your sheet the first time you
go to print preview.