How to turn off Page Layout View as default view

[Colin Halliday]

In Excel 2007 I have somehow turned on Page Layout View as my default view
so that every time I open Excel or create a new workbook it is displayed in
Page Layout View.

I want it to open in Normal View by default.

How do I change this?

Thanks.

 

[OssieMac]

Hi Colin

Click the Microsoft button (Large button top left of screen)
Exel Options (Towards bottom right next to exit)
Select Popular in left column (Normally defaults to this)
Under "When creating new workbooks" heading.
Click drop down against "Default view for new sheets" and select Normal view

Regards,

OssieMac

 

[Colin Halliday]

Thanks, but:

This setting is set to Normal View. The problem is not just when I create a
new worksheet (which this setting relates to) but when I first open Excel or
create a new workBOOK.

Any other ideas?

I think it may be something to do with a template.

Colin

 

[OssieMac]

Hi Colin,

To the best of my knowledge it should fix the problem. The following is
extracted from help:-

Default View for new sheets Select the view that you want Excel to display
by default when you start Excel. You can select Normal View, Page Break
Preview, or Page Layout View.

I have known Excel to become "lost" with settings and there is then a need
to force it to make the change. Try setting to 'Page Layout View' and then
close Excel and re-open. Reset to Normal view and close Excel again and
re-open and see if it makes a diffierence.

Afraid that I can't offer any further suggestions.

Regards,

OssieMac