Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying information from one cell to another without modifying it.
Please tell me how to stop Excel from Adding 1 to my data when I copy it from
the first cell in a column to the rest of the cells in the same column. For example, when I key WC123 and try to drag & copy this value to the cells below, the result is WC124, WC125, etc.. Thanks. Ken K. - 2191 -- akkrug |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying information from one cell to another without modifying it.
Ken try pressing the Ctrl key while you drag & copy ;) -- ferg ------------------------------------------------------------------------ ferg's Profile: http://www.excelforum.com/member.php...o&userid=36519 View this thread: http://www.excelforum.com/showthread...hreadid=565565 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying information from one cell to another without modifying it.
Works Great! Can't believe I was so brain-dead today that I forgot how to do
it. Thank Ferg!! -- akkrug "akkrug" wrote: Please tell me how to stop Excel from Adding 1 to my data when I copy it from the first cell in a column to the rest of the cells in the same column. For example, when I key WC123 and try to drag & copy this value to the cells below, the result is WC124, WC125, etc.. Thanks. Ken K. - 2191 -- akkrug |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying information from one cell to another without modifying it.
One more method.
Right-click and drag. Release and select "Copy Cells" Gord Dibben MS Excel MVP On Thu, 27 Jul 2006 06:23:02 -0700, akkrug wrote: Please tell me how to stop Excel from Adding 1 to my data when I copy it from the first cell in a column to the rest of the cells in the same column. For example, when I key WC123 and try to drag & copy this value to the cells below, the result is WC124, WC125, etc.. Thanks. Ken K. - 2191 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying information from one cell to another without modifying
Also works great! Thanks Gord!!!
Ken K. - 2191 -- akkrug "Gord Dibben" wrote: One more method. Right-click and drag. Release and select "Copy Cells" Gord Dibben MS Excel MVP On Thu, 27 Jul 2006 06:23:02 -0700, akkrug wrote: Please tell me how to stop Excel from Adding 1 to my data when I copy it from the first cell in a column to the rest of the cells in the same column. For example, when I key WC123 and try to drag & copy this value to the cells below, the result is WC124, WC125, etc.. Thanks. Ken K. - 2191 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying information from one cell to another without modifying it.
I am having the same problem. What I am trying to do is when i drag and copy
cells i want one part to increase by one and keeping the other one constant. For example (C3/B3), where the numerator will be increasing by one (C4,C5,...) and keeping the denominator constant (B3, B3, B3,...). Instead it all the cells want to increases by one or by some value. Copying while hitting the Ctrl key doesn't want to work. Can anyone help me and tell me what i am doing wrong. "akkrug" wrote: Please tell me how to stop Excel from Adding 1 to my data when I copy it from the first cell in a column to the rest of the cells in the same column. For example, when I key WC123 and try to drag & copy this value to the cells below, the result is WC124, WC125, etc.. Thanks. Ken K. - 2191 -- akkrug |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying information from one cell to another without modifying it.
Try it like this...
=C3/B$3 The $ (dollar sign) makes the row reference absolute, meaning it will not change as you copy. Look in Excel help for absolute and relative referencing. -- Biff Microsoft Excel MVP "nsechs" wrote in message ... I am having the same problem. What I am trying to do is when i drag and copy cells i want one part to increase by one and keeping the other one constant. For example (C3/B3), where the numerator will be increasing by one (C4,C5,...) and keeping the denominator constant (B3, B3, B3,...). Instead it all the cells want to increases by one or by some value. Copying while hitting the Ctrl key doesn't want to work. Can anyone help me and tell me what i am doing wrong. "akkrug" wrote: Please tell me how to stop Excel from Adding 1 to my data when I copy it from the first cell in a column to the rest of the cells in the same column. For example, when I key WC123 and try to drag & copy this value to the cells below, the result is WC124, WC125, etc.. Thanks. Ken K. - 2191 -- akkrug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Cell sizing in a Vlookup formula to fit information. | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Problems copying street addresses and dates | Excel Discussion (Misc queries) | |||
store some of the information from one cell into another | Excel Discussion (Misc queries) |