Omega Owners Forum
Chat Area => General Discussion Area => Topic started by: Mr Skrunts on 08 November 2016, 09:06:54
-
Silly question time.
If value of A1 is £1
Then need that value to be changeable in multiple cells then how do I achieve it.
I have always added the value =a1 to maybe b2, then =b2 in call b3 etc
TIA :y
-
Just about to leave for work but was wondering what version of Excel you have.
e.g. 2003-2016 or Office 365
Hope fully someone will come along soon.
-
If you want to replicate the value of one cell in other multiple cells, you paste "=$A$1" into all the other cells. Then any value you type in cell A1 will be replicated in all the other cells.
The $ signs basically lock the index so that they don't auto-increment when you paste them into the adjacent cells.
Works in Excell 97 :-)
-
If you want to replicate the value of one cell in other multiple cells, you paste "=$A$1" into all the other cells. Then any value you type in cell A1 will be replicated in all the other cells.
The $ signs basically lock the index so that they don't auto-increment when you paste them into the adjacent cells.
Works in Excell 97 :-)
And all others as far as I am aware
Also work in Libre Office which is what I use 'cos it's free ! :y
-
Just about to leave for work but was wondering what version of Excel you have.
e.g. 2003-2016 or Office 365
Hope fully someone will come along soon.
2007
-
If you want to replicate the value of one cell in other multiple cells, you paste "=$A$1" into all the other cells. Then any value you type in cell A1 will be replicated in all the other cells.
The $ signs basically lock the index so that they don't auto-increment when you paste them into the adjacent cells.
Works in Excell 97 :-)
Many thanks :y
-
Excel eh, crickey, Im still using Lotus 123.
-
Glad to read that piece of advice on cells. I have been using, (and I suppose it does the same thing,)...=sum(A1) and paste that in the cells I want it transferred to. (using A1 as the example cell) :)
-
Glad to read that piece of advice on cells. I have been using, (and I suppose it does the same thing,)...=sum(A1) and paste that in the cells I want it transferred to. (using A1 as the example cell) :)
Brilliant advice, been meaning to find out for ages :y
-
Next question ::)
Adding dates
Is there a simple way to add dates
Needing a list
6/11/16
6/12/16
6/ 1/17
etc etc
Am help some one who has gone from a weekly wage to a salary,
Was simple before
A1 6/11/16
A2=A1+7 etc
-
I think you need to look at the =MONTH() function