Melissa has attended:
Excel Intermediate course
Excel
Imagine we have a column of numbers (say in £s) in column A – say cells A3 down to A10
At the top we have a cell with exchange rate for £s to $s in say cell C1 – which today has say 1.5967 in it.
Now I want to create a set of equivalent numbers in column B of my A values but in $s
(a) So the manual version is to do a formula in B3 that reads “=A3*C1” but if I left that as is and copy it down to B10 the C1 would change.
(b) SO what I need to do manually is put in “=A3*$C$1” which then when copied down the B column will be correct.
Instead of actually doing (a) above I could go to cell B3 and type “=” and then click on cell A3, type “=” and click on C1, which would give us the same as (a) which is “=A3*C1”
BUT as I need an “anchored cell” $C$1 instead of C1, I currently have to type it out like in (b) above. But there must be something I can do as a shortcut so that when I click on C1 it puts “$C$1” in the cell as an anchored cell address rather than just “C1”?
RE: Excel
Hi Melissa, thanks for your query. When you type (or insert by clicking) a cell reference into a formula, reselect that reference then press F4. It will make that reference absolute.
Hope this helps,
Anthony