Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
76
Views
Topic starter
I cannot find how to move the end result of a spreadsheet to become the starting figure in a new one. Along time ago is was called absolute copying and you used a dollar sign, now it still copies the cell but not with the relevent addressing. Help please, thank you
Posted : 04/08/2020 10:28 am
Hi William,
It's still called absolute referencing and you use the dollar sign to stipulate this.
If you want the formula to move without changing the references, select the cell > F2 to edit > highlight to select the formula and then CTRL+C to copy the formula > go to the cell you want the formula in > paste.
Hope that's what you were after.
Mynda
Posted : 04/08/2020 9:13 pm
