Display page breaks in normal view in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I close, the Header, in Excel 2007, 1
Page breaks 1
how can i delete automatic page breaks in excel 1
How to turn off Page Layout View as default view 5
Controlling Page Break Preview 7
Soft page breaks don't show in Normal View 1
Page breaks in draft view 6
Excel Showing Page Number in Status Bar in Excel 1

Back
Top