Hey everyone, Just wondering if anyone knows how to make cells equal their values instead of it being a function. say for example A1x2=a1+13=a2+14=a3+15=a4+1 so i can move them around without the values changing Thanks all!

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 =/

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.

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.

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

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.

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.

"$" 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.