How do I set view page breaks as a default. in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
  
 
 
 
mncm 7/29/2005 8:02 AM PST
  Question
  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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Gord Dibben 7/29/2005 12:10 PM PST
  Answer
  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" <mncm@discussions.microsoft.com>
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?

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Andrea 3/24/2009 11:26 AM PST
   
  Is it possible to create a different repeating title for each page break?

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Gord Dibben 3/24/2009 3:15 PM PST
   
  No


Gord Dibben MS Excel MVP

On Tue, 24 Mar 2009 11:27:03 -0700, Andrea
<Andrea@discussions.microsoft.com> wrote:

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

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies