Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 10th 07, 08:22 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 45
Default 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?

  #2   Report Post  
Old April 10th 07, 02:16 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default 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?



  #3   Report Post  
Old April 11th 07, 01:18 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 353
Default 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?

  #4   Report Post  
Old April 25th 12, 08:24 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 1
Red face

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I move the page breaks in Excel 2007 Ozbod06 New Users to Excel 1 August 14th 06 02:08 PM
How do I display color in excel in normal view? Hattricksi Excel Discussion (Misc queries) 2 August 11th 06 12:24 PM
How to remove page break lines in normal view? [email protected] Excel Discussion (Misc queries) 5 August 8th 06 12:35 AM
Page break in normal view set at startup Stephen S Excel Discussion (Misc queries) 3 April 14th 06 11:46 PM
Excel 2003 does not display color shading in normal view but only. NewOffice2003 Excel Discussion (Misc queries) 1 March 7th 05 01:06 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017