If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Options aren't sticking
I have to go in every session to reset my "Excel Options" so that page breaks
are shown (it's under Advanced). Why does this not stay set when I exit? |
#2
|
|||
|
|||
Excel Options aren't sticking
I'm sure it was a design choice by the developer. Personally, I like that
choice. But if I want to see the page breaks, I don't go through the menus to turn it on. I just hit the print preview button. LWilkinson wrote: I have to go in every session to reset my "Excel Options" so that page breaks are shown (it's under Advanced). Why does this not stay set when I exit? -- Dave Peterson |
#3
|
|||
|
|||
Excel Options aren't sticking
Agreed. I hit print preview, then hit "Close." The page breaks should appear as dotted lines. It's a lot faster than changing your options manually. Just click 2 buttons on your toolbar and you're done. "Dave Peterson" wrote: I'm sure it was a design choice by the developer. Personally, I like that choice. But if I want to see the page breaks, I don't go through the menus to turn it on. I just hit the print preview button. LWilkinson wrote: I have to go in every session to reset my "Excel Options" so that page breaks are shown (it's under Advanced). Why does this not stay set when I exit? -- Dave Peterson |
#4
|
|||
|
|||
Excel Options aren't sticking
You can also add the "Page Break Preview" button to your toolbar.
"dleo" wrote: Agreed. I hit print preview, then hit "Close." The page breaks should appear as dotted lines. It's a lot faster than changing your options manually. Just click 2 buttons on your toolbar and you're done. "Dave Peterson" wrote: I'm sure it was a design choice by the developer. Personally, I like that choice. But if I want to see the page breaks, I don't go through the menus to turn it on. I just hit the print preview button. LWilkinson wrote: I have to go in every session to reset my "Excel Options" so that page breaks are shown (it's under Advanced). Why does this not stay set when I exit? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|