How do I set view page breaks as a default.

This setting is not saved with a workbook or a Template.

You could record a macro and assign to a button on your Toolbar so you would
have a one-click solution.

OR just go to View>Page Break Preview then View>Normal.


Gord Dibben Excel MVP

On Fri, 29 Jul 2005 08:03:07 -0700, "mncm" <[email protected]>
wrote:

>I would like to have the Page breaks appear on the sheet as a default, when I
>open Excel. I currently have to go to tools/options/page breaks each time I
>open a new sheet or saved file. I'm using Excel 2003. Can this be done?

I would like to have the Page breaks appear on the sheet as a default, when I
open Excel. I currently have to go to tools/options/page breaks each time I
open a new sheet or saved file. I'm using Excel 2003. Can this be done?

This setting is not saved with a workbook or a Template.

You could record a macro and assign to a button on your Toolbar so you would
have a one-click solution.

OR just go to View>Page Break Preview then View>Normal.


Gord Dibben Excel MVP

On Fri, 29 Jul 2005 08:03:07 -0700, "mncm" <[email protected]>
wrote:

>I would like to have the Page breaks appear on the sheet as a default, when I
>open Excel. I currently have to go to tools/options/page breaks each time I
>open a new sheet or saved file. I'm using Excel 2003. Can this be done?