Prev: Setting up a bi-weekly calendar event
Next: Send email from vba code in excel
From: djrak on 30 Apr 2010 14:44
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.
From: Ormond on 30 Apr 2010 14:58
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.excel.misc/General-Setting-Question
From: Mike H on 30 Apr 2010 15:20
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.
 | 
Pages: 1
Prev: Setting up a bi-weekly calendar event
Next: Send email from vba code in excel