Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drag without incrementing
I have cells that contain the account id for the named provider on that row. The account ids are numeric but I have them formatted as Text.
When I want to enter data for the same provider on a new row I elect the provider and id columns and drag them to the new row. The problem I am having is that the account id is incremented up by 1. How can I prevent this? Thanks for any and all help. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drag without incrementing
Hi,
Am Tue, 29 Apr 2014 03:11:25 -0700 (PDT) schrieb : I have cells that contain the account id for the named provider on that row. The account ids are numeric but I have them formatted as Text. When I want to enter data for the same provider on a new row I elect the provider and id columns and drag them to the new row. The problem I am having is that the account id is incremented up by 1. How can I prevent this? drag with pressed CTRL Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drag without incrementing
Right-clickdragrelease and "copy cells"
Gord On Tue, 29 Apr 2014 03:11:25 -0700 (PDT), wrote: I have cells that contain the account id for the named provider on that row. The account ids are numeric but I have them formatted as Text. When I want to enter data for the same provider on a new row I elect the provider and id columns and drag them to the new row. The problem I am having is that the account id is incremented up by 1. How can I prevent this? Thanks for any and all help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rang reference incrementing by more than one on formula drag | Excel Worksheet Functions | |||
incrementing | Excel Worksheet Functions | |||
incrementing | Excel Discussion (Misc queries) | |||
Next not incrementing | Excel Programming | |||
incrementing on inserrt row | Excel Programming |