ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CANT DRAG PAGE BREAKS ANYMORE, HOW DO YOU RESTORE THIS? (https://www.excelbanter.com/excel-discussion-misc-queries/87954-cant-drag-page-breaks-anymore-how-do-you-restore.html)

FRED

CANT DRAG PAGE BREAKS ANYMORE, HOW DO YOU RESTORE THIS?
 
I usually can change page breaks by going into page break preview and
clicking & dragging the page brake lines. Today I can't. The cursor is a
cross and it doesn't change to allow dragging of the page break lines. Can
you tell me how to get this feature back?


Dominic

CANT DRAG PAGE BREAKS ANYMORE, HOW DO YOU RESTORE THIS?
 
Do you have fit to page checked under Page Setup?

"FRED" wrote:

I usually can change page breaks by going into page break preview and
clicking & dragging the page brake lines. Today I can't. The cursor is a
cross and it doesn't change to allow dragging of the page break lines. Can
you tell me how to get this feature back?


Dave Peterson

CANT DRAG PAGE BREAKS ANYMORE, HOW DO YOU RESTORE THIS?
 
Maybe...

Tools|Options|Edit Tab|check Allow cell drag and drop.

FRED wrote:

I usually can change page breaks by going into page break preview and
clicking & dragging the page brake lines. Today I can't. The cursor is a
cross and it doesn't change to allow dragging of the page break lines. Can
you tell me how to get this feature back?


--

Dave Peterson


All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com