| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off auto increment when trying to drag and drop
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? -- David Lane |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn off auto increment when trying to drag and drop
Probably one of the simpliest is just put in the same number in the next
cell. Then highlight both cells. Then just copy (with the bottom "+") the range that you want. Excel then "calculates" that you want the same increment in all the cells (which is the same number), so you get what your after. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drag and drop will not turn off - keeps selecting all data | Excel Discussion (Misc queries) | |||
| Drag and Drop Picture | Excel Discussion (Misc queries) | |||
| how do I drag & drop cell text only | New Users to Excel | |||
| How do I set cell drag and drop to be on as a default | Excel Discussion (Misc queries) | |||
| Prevent Drag & Drop | Excel Discussion (Misc queries) | |||
Hybrid Mode
