# Microsoft Excel 2003 question

Discussion in 'General Software' started by Yin, Mar 9, 2009.

1. ### Yin

Joined:
Feb 19, 2006
Messages:
542 (0.15/day)
32
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!

2. ### PolarmanNew Member

Joined:
Jun 24, 2008
Messages:
1,627 (0.60/day)
292
Location:
Rimouski
Not sure what you mean.

3. ### Yin

Joined:
Feb 19, 2006
Messages:
542 (0.15/day)
32
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 =/

Last edited: Mar 9, 2009
4. ### phanbuey

Joined:
Nov 13, 2007
Messages:
5,237 (1.78/day)
999
Location:
Miami
hrm... it would have to be a function in any case.

5. ### Akumos

Joined:
Nov 30, 2008
Messages:
552 (0.22/day)
28
Location:
Birmingham, England...
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.

6. ### newtekie1Semi-Retired Folder

Joined:
Nov 22, 2005
Messages:
21,823 (5.97/day)
7,721
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 says thanks.
7. ### Yin

Joined:
Feb 19, 2006
Messages:
542 (0.15/day)
32
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

File size:
74.5 KB
Views:
113
8. ### theeldest

Joined:
Feb 7, 2006
Messages:
657 (0.18/day)
141
Location:
Austin, TX

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.

9. ### Yin

Joined:
Feb 19, 2006
Messages:
542 (0.15/day)
32
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.

10. ### Steevo

Joined:
Nov 4, 2005
Messages:
9,132 (2.48/day)