ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Display page breaks in normal view in Excel 2007 (https://www.excelbanter.com/new-users-excel/138411-display-page-breaks-normal-view-excel-2007-a.html)

Wombat April 10th 07 08:22 AM

Display page breaks in normal view in Excel 2007
 
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 April 10th 07 02:16 PM

Display page breaks in normal view in Excel 2007
 
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wombat" wrote in message
...
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?




BoniM April 11th 07 01:18 AM

Display page breaks in normal view in Excel 2007
 
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?


John Livingston April 25th 12 08:24 PM

Those of us who want to continue in Normal view have good reasons. In my case, our computer network seems to reset what should remain a tabloid-sized spreadsheet into letter-size paper. Looking at it in Page Layout view is distracting, because I then feel compelled to reset it immediately instead of waiting until I print it on a remote printer that has tabloid-sized paper. So those dotted lines do come in handy

Quote:

Originally Posted by Bernard Liengme (Post 478561)
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wombat" wrote in message
...
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?



All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com