Thread: How do I turn off auto increment when trying to drag and drop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I turn off auto increment when trying to drag and drop
Right-click and drag.

Release button and select "Copy Cells".


Gord Dibben MS Excel MVP

On Fri, 26 Jan 2007 12:11:03 -0800, David
wrote:

I want to be able to copy data in a cell by dragging it to the cells below.
it autoincrements number unless I hold down the control key I want to turn
off this can I How?

Reply With QuoteReply With Quote