General Topics
Markets
Technical Topics
Brokerage Firms
Company Specific
Community Lounge
Site Support

Discussion in 'Trading Software' started by Gordon Gekko, Aug 5, 2003.

1. ### Gordon Gekko

ok, say in A1 i have this formula: =B1+C1

now, say i copy this formula from A2 to A1000

in A2, i will get =B2+C2

HERE IS WHAT BUGS ME!

what if in the formula i want B1 to change, but i want C1 to stay C1?

for example, say i want A2 to be =B2+C1

what i have been doing is copying the formula to the cells i want it, then i go back by hand and change the values that i didn't want changed. BUT FOR A LOT OF CELLS, THIS SUCKS! what can i do, if anything?!

thx!

2. ### Sanjuro

GG,

=B1+C1
=B2+C1
=B3+C1

Manually fill this in for the first 3 As.
Then highlight the 3 As.
Then drag the bottom right corner all the way down to 1000.

Excel should pick up that only the Bs shoud be changing and Cs
remain the same.

Good Luck!

3. ### kgharris

If you want the C1 to remain constant, just put \$ sign in front of it. In your example above:

B2+\$C\$1

C1 will remain constant when you cut and paste.

4. ### AmbushHillbilly

Also, a '\$' in front of the column (\$C1) will lock the column only as you copy. A '\$' before the row does the same for it (C\$1).

5. ### swoop[TR]

Relative vs Absolute cell referencing. Basic Excel stuff dude.

Just teasing

6. ### Gordon Gekko

oh yes!!

you guys just saved me a lot of time. my plan was to do like 100 cells per day til i got it done. lol but i knew there had to be a better way.

thanks!

7. ### lescor

You can also assign a name to cell C1, then just reference the name in your formulas.

8. ### electron

That would be a good exercise in patience so needed when trading...

ET IS FREE FOR TRADERS BECAUSE OF THE FINANCIAL SUPPORT FROM THESE SPONSORS: