Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
akm akm is offline
external usenet poster
 
Posts: 19
Default How 2 set margins 2 show when exceeded @ 'normal view' ???

How to set page margins in Excel so 'Normal View' will show (with dash line)
when page print area is out of the margins ?

When adjust cell sizes etc, bottom margin is showing that margin indication,
but right margin is not.

This does not normally happen, but often happens after we have been working
with a page for some time (adjusting margins etc), and it seems like we may
have lost or changed a setting by mistake or something.

Only thing we notice is when looking at 'Print Preview' margins indicators,
the left margin indicator line has a white box at the top instead of the
normal black box which is at all other line ends.

Page setup 'scaling' is set at 100%.

Suggestions ?

Thanks again for your help.
OS: XP, SP-2 (Office2003)

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default How 2 set margins 2 show when exceeded @ 'normal view' ???

If I understand your question correctly.
ToolOptionsView Tab and then Page Breaks is checked.

"akm" wrote:

How to set page margins in Excel so 'Normal View' will show (with dash line)
when page print area is out of the margins ?

When adjust cell sizes etc, bottom margin is showing that margin indication,
but right margin is not.

This does not normally happen, but often happens after we have been working
with a page for some time (adjusting margins etc), and it seems like we may
have lost or changed a setting by mistake or something.

Only thing we notice is when looking at 'Print Preview' margins indicators,
the left margin indicator line has a white box at the top instead of the
normal black box which is at all other line ends.

Page setup 'scaling' is set at 100%.

Suggestions ?

Thanks again for your help.
OS: XP, SP-2 (Office2003)

  #3   Report Post  
Posted to microsoft.public.excel.misc
akm akm is offline
external usenet poster
 
Posts: 19
Default How 2 set margins 2 show when exceeded @ 'normal view' ???

That 'Page Breaks' setting is checked for our worksheet/s.

This question is about the function for when a cell is enlarged a 'blue'
(page break lines are black for our worksheets) dashed line may appear (at
the bottom or right side of the worksheet) to indicate that cell text is then
out of the one-page print area.

Not sure how else to say it.
--
Thanks again for your help.
OS: XP, SP-2 (Office2003)



"dls61721" wrote:

If I understand your question correctly.
ToolOptionsView Tab and then Page Breaks is checked.

"akm" wrote:

How to set page margins in Excel so 'Normal View' will show (with dash line)
when page print area is out of the margins ?

When adjust cell sizes etc, bottom margin is showing that margin indication,
but right margin is not.

This does not normally happen, but often happens after we have been working
with a page for some time (adjusting margins etc), and it seems like we may
have lost or changed a setting by mistake or something.

Only thing we notice is when looking at 'Print Preview' margins indicators,
the left margin indicator line has a white box at the top instead of the
normal black box which is at all other line ends.

Page setup 'scaling' is set at 100%.

Suggestions ?

Thanks again for your help.
OS: XP, SP-2 (Office2003)

  #4   Report Post  
Posted to microsoft.public.excel.misc
akm akm is offline
external usenet poster
 
Posts: 19
Default Another forum or website where may be able to get answer ???

Subject: How 2 set margins 2 show when exceeded @ 'normal view' ???
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
Normal view vs Print & Preview Looby Loo Excel Discussion (Misc queries) 0 October 23rd 08 05:13 PM
Strange normal view LaurenM Excel Discussion (Misc queries) 3 April 8th 08 02:04 PM
Blank workbook in normal view vic1 Excel Discussion (Misc queries) 3 December 10th 07 12:19 PM
column is hidden in normal view but not print view Bianca Excel Worksheet Functions 2 June 23rd 06 08:38 AM
outlook view to normal view jenden New Users to Excel 2 December 5th 05 09:23 PM


All times are GMT +1. The time now is 11:02 AM.

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

About Us

"It's about Microsoft Excel"