View Single Post
  #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)