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.

"Wombat" wrote:

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?