| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel page break titles
Is it possible to create a different repeating title for each page break?
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| resetting page breaks | Excel Discussion (Misc queries) | |||
| MS Office Excel97: Removing Page Breaks | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
| How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
| Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) | |||
Hybrid Mode
