Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
"BorisS" wrote in message ... 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 |
#3
|
|||
|
|||
Go to
Tools--options--Error checking-- and uncheck the "enable background checking" and all the choices under Rules "BorisS" wrote in message ... 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 |
#4
|
|||
|
|||
For the first requirement.......
ToolsOptionsEdit 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" wrote: Go to Tools--options--Error checking-- and uncheck the "enable background checking" and all the choices under Rules "BorisS" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging formulas | Excel Worksheet Functions | |||
Dragging year - Ajit | Excel Discussion (Misc queries) | |||
Dragging Across | Excel Discussion (Misc queries) | |||
Copy and dragging cells | Excel Worksheet Functions | |||
VLOOKUP dragging down | Excel Worksheet Functions |