How do you turn off the Autofill Options box when dragging cells.
 

After I do a 'drag to copy' the Autofill Options box appears and is always in
the way for my next 'drag to copy'. I have to click a blank cell off to the
side and hit the space bar to get it to turn off (temporarily).

How do you turn off the Autofill Options box when dragging cells.
 

Unselect Show Paste Options under Tools, Options, Edit.

--
Jim
"Mike in Wyo" <Mike in wrote in message
...
| After I do a 'drag to copy' the Autofill Options box appears and is always
in
| the way for my next 'drag to copy'. I have to click a blank cell off to
the
| side and hit the space bar to get it to turn off (temporarily).