Copy / Paste

[yearntolearn]

How can I do a copy / paste and not have the column numbers change?
Example:
Copy C1 (=C1*100)to D1 without have the formual change to (=D1*100)

 

[BenRowe]

Formula should be =$C1*100 (addition of $ before the C)

 

[dcompto]

Your formulas would have to be "absolute". See the following link for a macro to convert formulas from relative to absolute or vice versa:

http://support.microsoft.com/?kbid=213465

 

[yearntolearn]

But the column has 200 entries, I do not want to add a dollar sign to 200 rows.

 

[dcompto]

Not sure about other versions, but in Excel 2003, you can search and replace the formula...

Place your cursor in the first cell of the column you want to convert from relative to absolute, then

Edit > Replace
Find what: =C
Replace with: =$C
Within: Sheet
Search: By Columns
Look in: Formulas

Click Replace All
OK
Close

 

[arthurbr]

Another possible option is to selecet the cell(s) you want to copy, place the mouse arrow on the upper border of the selected zone, and drag the selected zone with the right mouse button depressed.( hope this is clear)
After you moved the zone, a menu will appear, just select " link here", and this should do the trick

André

 

[yearntolearn]

Thank you one and all for your help. But...isn't there a way to just copy absolute once without having to change the formula because I may want to copy relative later on. I would have guessed there was a way to hold down a key and it would copy relative and not absolute and without holding down the key it would copy absoute and not relative. But...it sounds like that isn't the case.
The code provided in decompto's link worked fine but it is cumbersome have to copy that code (create a macro) for every spreadsheet I use...yes I'm lazy.
But again thank all of you for your execellent help.

 

[SkipVought]

1) You can use the F4 function key as a toggle when you are creating forumlas to specify.

2) once you have created a formul correctly in one cell, it is a simple copy 'n' paste to any RANGE.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}