View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default 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).