Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2010

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

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.