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

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" wrote:

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

Hi Mark,

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

regards
krishna


"Markv" wrote:

> 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" wrote:
>
> > 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
> >
> >

Glad I could help "Sai"

"Sai Krishna" wrote:

>
>
> Hi Mark,
>
> thanks a ton. Didn't know the existence of this option!!
>
> regards
> krishna
>
>
> "Markv" wrote:
>
> > 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" wrote:
> >
> > > 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
> > >
> > >

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

On Mon, 23 Jun 2008 02:11:00 -0700, Sai Krishna
<(E-Mail Removed)> wrote:

>
>
>Hi Mark,
>
>thanks a ton. Didn't know the existence of this option!!
>
>regards
>krishna
>
>
>"Markv" wrote:
>
>> 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" wrote:
>>
>> > 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
>> >
>> >

Sure, will do so.
regards
krishna

"Gord Dibben" wrote:

> 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
>
> On Mon, 23 Jun 2008 02:11:00 -0700, Sai Krishna
> <(E-Mail Removed)> wrote:
>
> >
> >
> >Hi Mark,
> >
> >thanks a ton. Didn't know the existence of this option!!
> >
> >regards
> >krishna
> >
> >
> >"Markv" wrote:
> >
> >> 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" wrote:
> >>
> >> > 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
> >> >
> >> >
>
>

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


"Markv" wrote:

> 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" wrote:
>
> > 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
> >
> >