Excel Cell Reference

When writing, editing or auditing Excel formulas you will come across a scenario where you want to view and access the referenced cells within a formula argument.

This is helpful if you want to check how the formula works or to make any changes to the formula.

There is a cool tip where you can jump to the referenced cell or range within the formula and make your changes.

DOWNLOAD EXCEL WORKBOOK

STEP 1: Double click inside your Excel formula

Excel Cell Reference

STEP 2: Select the formula argument that you want to edit with your mouse

Excel Cell Reference

STEP 3: Press F5 which will bring up the Go To dialogue box and press OK

Excel Cell Reference

STEP 4: This will take you to the referenced cell/range

Excel Cell Reference

STEP 5: You can select the new range with your mouse and also make any changes to the formula bar

Excel Cell Reference

STEP 6: Press Enter and your formula is updated

Excel Cell Reference

Excel Cell Reference

HELPFUL RESOURCE:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

SUMIF Function: Introduction The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify.So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel func...
Create a Random List with Excel’s RAND Formu... What does it do?Gives you a random number between 0 and 1Formula breakdown:=RAND()What it means:=RAND(Will automatically choose a random number between 0 and 1)Excel is able to do a lot of things that most users are unaware of!  One thing that amazes m...
IFERROR Function: Introduction If you have a calculation that results in an error like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, then you can clean it up by using the IFERROR function which allows you to replace the error it with a 0 or a blank cell.I show you both IFERROR examples below.DOWNLOAD ...
Advanced SUMPRODUCT Function: Sum Multiple Criteri... What does it do?It returns the sum of multiple criteria from the corresponding ranges or arraysFormula breakdown:=SUMPRODUCT((array 1 criteria) * (array2 criteria) * array values)What it means:=SUMPRODUCT((find my criteria in this array) * (find my criteri...