Office buttonExcel OptionsAdvancedscroll to Cut, copy and pasteuncheck
Show paste options buttonsOK

--
Biff
Microsoft Excel MVP


"JohnnyB" wrote in message
...
autofill suggestion dropdown in Excel 2007 is driving me nuts, as it has
in
previous versions. WHen I copy (dragging) cells into another area, I am
always left with the dropdown menu of formatting suggestions which I
ignore.
However, the menu blocks the content in a cell, driving me nuts. How do I
get that dropdown to cease and desist?