How 2 set margins 2 show when exceeded @ 'normal view' ???

A

akm

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)
 
D

dls61721

If I understand your question correctly.
Tool>Options>View Tab and then Page Breaks is checked.
 
A

akm

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.
 

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

Top