![]() |
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? |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com