Dragging a cell

[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

 

[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...

 

[Sai Krishna]

Hi Mark,

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

regards
krishna

 

[Markv]

Glad I could help "Sai"

Hi Mark,

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

regards
krishna

 

[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

 

[Sai Krishna]

Sure, will do so.
regards
krishna

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

 

[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