ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't move page break (https://www.excelbanter.com/excel-discussion-misc-queries/261021-cant-move-page-break.html)

IDUBB

Can't move page break
 
What is the fix if my mouse can not grab and drak the page break? I am sure
it is an easy fix, but I don't think I have ever encountered this problem.

Thanks

Dave Peterson

Can't move page break
 
In xl2003 menus:

Tools|options|Edit tab|make sure that "Allow cell drag and drop" is checked.

I'm sure it's hidden under Excel Options in xl2007 (somewhere!).

IDUBB wrote:

What is the fix if my mouse can not grab and drak the page break? I am sure
it is an easy fix, but I don't think I have ever encountered this problem.

Thanks


--

Dave Peterson

Russell Dawson[_2_]

Can't move page break
 
In 2007

It's not possible to change the page breaks during normal view as far as I'm
aware.

What you should do is - In View Tab - Workbook Views - Page break preview.

This should now allow you to make your changes

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"IDUBB" wrote:

What is the fix if my mouse can not grab and drak the page break? I am sure
it is an easy fix, but I don't think I have ever encountered this problem.

Thanks



All times are GMT +1. The time now is 01:20 PM.

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