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

M

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop Autofill 6
Dragging AlphaNumeric Cell to Copy 1
How to eliminate the autofill options box that pops up in excel? 1
How do I turn off annotating with ink in Excel 2016 2
Macro 0
How do you make the little autofill box in Excel go away? 2
Can Autofill be Defaulted to copy cells instead of fill series 3
Dragging a formula across the row in 2007 2

Top