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

[Mike in Wyo]

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

 

[Jim Rech]

Unselect Show Paste Options under Tools, Options, Edit.

--
Jim
| 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).