ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel Options aren't sticking (https://www.excelbanter.com/new-users-excel/218929-excel-options-arent-sticking.html)

LWilkinson

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?

Dave Peterson

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

dleo

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


Southpaw

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