How do I set view page breaks as a default.

G

Guest

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

page breaks and printing 0
view page breaks 4
Excel Delete Multiple Page Breaks w/in Selected Rows 6
how to remove page breaks from an existing document 1
How can I insert data into my spreadsheet without the page breaks. 1
Hiding Page Breaks 6
Inserting page breaks 3
"manual page breaks error" 5

Top