In Excel, how can I stop the drag function to copy and not add?
David
If just one cell is selected you get a copy.
If two or more cells are selected Excel helps by autofilling/incrementing.
As the other response points out, use the right-click and drag and choose from
the options.
Gord Dibben MS Excel MVP
On Sat, 1 Jul 2006 12:35:02 -0700, DavidClaborn
wrote:
I want to copy selected rows by grabbing the fill handle and dragging down.
Currently, some columns are adding instead of just copying the number. How
can I control what the fill handle does?
Thanks in advance for any help you can offer,
Dave Claborn
|