Dragging a cell

S

Sai Krishna

Hi,


I am unable to drag a cell down. I have checked automatic under tools,
options, calculations.

My problem is I am unable to get a + sign when I take the mouse near the
edge of a cell to be dragged.

Pl help.
krishna
 
M

Markv

Hi there Sai
Hope this will help;

On the menu select TOOLS, then OPTIONS, on the next pop up window find the
EDIT TAB, then make sure that the ALLOW CELL DRAG AND DROP checkbox is
enabled.
Select OK or APPLY when done.

Good luck...
 
S

Sai Krishna

Hi Mark,

thanks a ton. Didn't know the existence of this option!!

regards
krishna
 
G

Gord Dibben

When you have a few minutes spare time, browse through the Tools>Options Tabs

You will see all kinds of things that affect your functionality.


Gord Dibben MS Excel MVP
 
S

Sai Krishna

Sure, will do so.
regards
krishna

Gord Dibben said:
When you have a few minutes spare time, browse through the Tools>Options Tabs

You will see all kinds of things that affect your functionality.


Gord Dibben MS Excel MVP
Click to expand...
 
B

bjb55

I'm so glad I read this, as I was having the same problem. Is there a way to
do this for the entire Excel application, rather than file by file? It seems
all of my excel files have lost this ability.

Thanks,
bjb55
 
Top