dragging without interference

In my Excel 2002, I am finding that when I am trying to drag a set of cells
right, at the lower right of the area is this "helpful" dropdown box, which
gives me options like "fill, fill with format" or some other crap. I don't
want it, because it places itself right where the lower right drag corner is.
How do I get rid of that little box. It also appears when there are
incosistent formulas across a row or down a column, and I don't want it there
either.
--
Boris

"BorisS" <BorisS@discussions.microsoft.com> wrote in message
news:1058F71E-EABB-4ED8-B286-780A78C5EA82@microsoft.com...
> In my Excel 2002, I am finding that when I am trying to drag a set of
> cells
> right, at the lower right of the area is this "helpful" dropdown box,
> which
> gives me options like "fill, fill with format" or some other crap. I don't
> want it, because it places itself right where the lower right drag corner
> is.
> How do I get rid of that little box. It also appears when there are
> incosistent formulas across a row or down a column, and I don't want it
> there
> either.
> --
> Boris

Go to
Tools-->options-->Error checking-->
and uncheck the "enable background checking"
and all the choices under Rules

"BorisS" <BorisS@discussions.microsoft.com> wrote in message
news:1058F71E-EABB-4ED8-B286-780A78C5EA82@microsoft.com...
> In my Excel 2002, I am finding that when I am trying to drag a set of
> cells
> right, at the lower right of the area is this "helpful" dropdown box,
> which
> gives me options like "fill, fill with format" or some other crap. I don't
> want it, because it places itself right where the lower right drag corner
> is.
> How do I get rid of that little box. It also appears when there are
> incosistent formulas across a row or down a column, and I don't want it
> there
> either.
> --
> Boris

For the first requirement.......

Tools>Options>Edit uncheck "show paste options buttons".

And "show insert option buttons"


Gord Dibben Excel MVP

On Fri, 20 May 2005 11:42:14 -0400, "N Harkawat" <nh@nh.com> wrote:

>Go to
>Tools-->options-->Error checking-->
>and uncheck the "enable background checking"
>and all the choices under Rules
>
>"BorisS" <BorisS@discussions.microsoft.com> wrote in message
>news:1058F71E-EABB-4ED8-B286-780A78C5EA82@microsoft.com...
>> In my Excel 2002, I am finding that when I am trying to drag a set of
>> cells
>> right, at the lower right of the area is this "helpful" dropdown box,
>> which
>> gives me options like "fill, fill with format" or some other crap. I don't
>> want it, because it places itself right where the lower right drag corner
>> is.
>> How do I get rid of that little box. It also appears when there are
>> incosistent formulas across a row or down a column, and I don't want it
>> there
>> either.
>> --
>> Boris
>