ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   General Setting Question (https://www.excelbanter.com/excel-discussion-misc-queries/262863-general-setting-question.html)

djrak

General Setting Question
 
I think I have modifed setting and I am not sure which one it is. I am
running 2007, and I have changed something so that when I click into the
formula bar to edit an equation, I can no longer drag the cells to adjust the
equation. There used to be bold outlines around the cells involved in the
equation, which I could drag. Now there are just unbolded oultines and I
cannot select grab cell and drag it to adjust the formula. Any suggestions
on what I changed and how to undo it.

Ormond

General Setting Question
 
Click on the Office Button and choose Excel Options. Select the Advanced Tab. Under Editing Options, make sure that Enable Fill Handle and Drag and Drop is checked.

---
frmsrcurl: http://msgroups.net/microsoft.public...tting-Question

Mike H

General Setting Question
 
Hi,

Office button - Excel options - Advanced tab - Check " Enable fill handle
and cell drag and drop'
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"djrak" wrote:

I think I have modifed setting and I am not sure which one it is. I am
running 2007, and I have changed something so that when I click into the
formula bar to edit an equation, I can no longer drag the cells to adjust the
equation. There used to be bold outlines around the cells involved in the
equation, which I could drag. Now there are just unbolded oultines and I
cannot select grab cell and drag it to adjust the formula. Any suggestions
on what I changed and how to undo it.



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

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