Microsoft Excel 2003 question

[Yin]

Hey everyone,

Just wondering if anyone knows how to make cells equal their values instead of it being a function.

say for example

A​

1

x​

2

=a1+1​

3

=a2+1​

4

=a3+1​

5

=a4+1​

so i can move them around without the values changing

Thanks all!

 

[Polarman]

Not sure what you mean.

 

[Yin]

okay i'll try to re word it
letters = columns
numbers = rows

so lets say
A1 = "10"
A2 = "=A1+1"
A3 = "=A2+1"
A4 = "=A3+1"
A5 = "=A4+1"

so what we see is
A1 = 10
A2 = 11
A3 = 12
A4 = 13
A5 = 14

its kinda confusing =/

 

[phanbuey]

hrm... it would have to be a function in any case.

 

[Akumos]

Or could be a simple formula. have a hidden column of formulaes and link??

Don't think it's possible wihtout a function or formula though... interesting to see what other poeple write.

 

[newtekie1]

The only thing I can think of is having the formula calculate the value, then copy the value, and do a paste special to paste the value into the cell.

 

[Yin]

I think it would be easier if you guys look at the file.

Basically you will noticed the dates are all in a formula and I wanna just get my own time table so i know when i'm working

 

[theeldest]

okay i'll try to re word it
letters = columns
numbers = rows

so lets say
A1 = "10"
A2 = "=A1+1"
A3 = "=A2+1"
A4 = "=A3+1"
A5 = "=A4+1"

so what we see is
A1 = 10
A2 = 11
A3 = 12
A4 = 13
A5 = 14

its kinda confusing =/

The way I understand it, you want the values from those cells in different Cells?

So you want:
B1= 10
B2= 11
B3= 12
B4= 13
B5= 14

Is this right?

If so, you want to enter:
B1= "=A1"
B2= "=A2"
B3= "=A3"
B4= "=A4"
B5= "=A5"

The easiest way to do this is click in the cell you want the value to appear in. Hit the equals sign, then click the source cell you want it to mirror. Then hit enter.

 

[Yin]

well I don't even know how the excel file really works to be honest, but basically I want to get rid of the other people and move all mine into a nice simple line.

 

[Steevo]

"$"


Will maintain a constant across multiple cells.


So if I wanted A1 to be a constant and multiply a range of dependants without changing it you will have to use a "$"sign. When all else fails, use help.