ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cannot drag page breaks (https://www.excelbanter.com/excel-worksheet-functions/123852-cannot-drag-page-breaks.html)

Hankian

Cannot drag page breaks
 
In page break preview view, the document will not allow me to drag the page
break. The cursor remains a solid "white plus" shape and does not change to
the double-headed arrow to allow me to drag the break line. How do I get out
of this "fixed" mode?

Dave Peterson

Cannot drag page breaks
 
Tools|Options|Edit tab
check the "allow Cell drag and drop" box

Hankian wrote:

In page break preview view, the document will not allow me to drag the page
break. The cursor remains a solid "white plus" shape and does not change to
the double-headed arrow to allow me to drag the break line. How do I get out
of this "fixed" mode?


--

Dave Peterson


All times are GMT +1. The time now is 02:05 PM.

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