| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can't drag page breaks
I can usually use my mouse to drag a page break to a new location in Excel in
page break preview mode. But lately I have not been able to do this. When I put my mouse over the break, nothing happens (usually the cursor changes to a line w/ arrows at either end when I place it over a page break.) Thus, I cannot manually move the page break. This problem is not confined to a particular spreadsheet, and I have changed no settings in Excel. Any idea what causes this and how to fix it? (I have tried closing and re-opening Excel). |
|
#2
|
|||
|
|||
|
Maybe drag and drop is disabled.
To enable drag and drop, choose ToolsOptions On the Edit tab, add a check mark to 'Allow cell drag and drop' Click OK S. H. Drew wrote: I can usually use my mouse to drag a page break to a new location in Excel in page break preview mode. But lately I have not been able to do this. When I put my mouse over the break, nothing happens (usually the cursor changes to a line w/ arrows at either end when I place it over a page break.) Thus, I cannot manually move the page break. This problem is not confined to a particular spreadsheet, and I have changed no settings in Excel. Any idea what causes this and how to fix it? (I have tried closing and re-opening Excel). -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
That worked - thanks!
"Debra Dalgleish" wrote: Maybe drag and drop is disabled. To enable drag and drop, choose ToolsOptions On the Edit tab, add a check mark to 'Allow cell drag and drop' Click OK S. H. Drew wrote: I can usually use my mouse to drag a page break to a new location in Excel in page break preview mode. But lately I have not been able to do this. When I put my mouse over the break, nothing happens (usually the cursor changes to a line w/ arrows at either end when I place it over a page break.) Thus, I cannot manually move the page break. This problem is not confined to a particular spreadsheet, and I have changed no settings in Excel. Any idea what causes this and how to fix it? (I have tried closing and re-opening Excel). -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
|
|||
|
|||
|
You're welcome! Thanks for letting me know that it solved the problem.
S. H. Drew wrote: That worked - thanks! "Debra Dalgleish" wrote: Maybe drag and drop is disabled. To enable drag and drop, choose ToolsOptions On the Edit tab, add a check mark to 'Allow cell drag and drop' Click OK S. H. Drew wrote: I can usually use my mouse to drag a page break to a new location in Excel in page break preview mode. But lately I have not been able to do this. When I put my mouse over the break, nothing happens (usually the cursor changes to a line w/ arrows at either end when I place it over a page break.) Thus, I cannot manually move the page break. This problem is not confined to a particular spreadsheet, and I have changed no settings in Excel. Any idea what causes this and how to fix it? (I have tried closing and re-opening Excel). -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Office Excel97: Removing Page Breaks | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
| excel page breaks - urgent help required | Excel Worksheet Functions | |||
| How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
| Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) | |||
Linear Mode
