Drag and drop in Excel 2

[Matt27]

I have a spreadsheet where the user has a client code and a client name. He has filled in the first cell, for example client code 123 client name ABC. He then wants to have this client information in the next few rows. When he drags it down the client name remains ABC but the client code increments, i.e. 124, 125, 126, etc. Is there any way of using the drag and drop function without it incrementing the numbers??

 

[Molby]

Instead of using the left mouse button, use the right to drag to where he wants, then select the Copy Cells from the item menu which should automatically open up.

 

[Matt27]

Thanks for that, but is there any way of avoiding copy and paste. Ideally what I want to happen is for the user to be able to drag and drop but for the values not to increment. I know that you can do this by holding the CTRL key and doing it but is there no way of, say, "turning it off" so the numbers don't increment?

 

[Hasit]

How is the number being entered?

If you store the number as text, then it does increment (bizarre eh?), but if you just enter a single number and drag it down then it maintains the integrity - i.e. does not increment.

But it only works if you drag down a single number.

 

[theo1881]

press alt key at same time - hunky dory !

Laters, phat, headshape

 

[theo1881]

btw - this will cause it to happen on all drag cells (no need to press key after), if you need to change back then press ctrl at same time

Laters, phat, headshape