How do I set view page breaks as a default.
 

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 ViewPage Break Preview then ViewNormal.


Gord Dibben Excel MVP

On Fri, 29 Jul 2005 08:03:07 -0700, "mncm"
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?

Excel page break titles
 

Is it possible to create a different repeating title for each page break?

Excel page break titles
 

No


Gord Dibben MS Excel MVP

On Tue, 24 Mar 2009 11:27:03 -0700, Andrea
wrote:

Is it possible to create a different repeating title for each page break?