Display page breaks in normal view in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wombat - 10 Apr 2007 08:22 GMT

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?

Reply to this Message

Bernard Liengme - 10 Apr 2007 14:16 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hi
> In Excel 2003, I could click on Tools/Options and then tick the "view page
[quoted text clipped - 4 lines]
> want.
> Can somebody help please?

Reply to this Message

BoniM - 11 Apr 2007 01:18 GMT

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.

> 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?

Reply to this Message

Rate this thread: