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

INDEX-MATCH Maximum Sales The INDEX-MATCH formula cannot only look up values to the left and right of your data but its versatility means that it can also lookup the largest values within an array.Say that you had a list of Sales Reps in one array and their corresponding Sales Values in another array....
Advanced SUMPRODUCT Function: Count You can use the SUMPRODUCT function to create advanced analysis of your data set.  For example, you can calculate the number of time a sales rep has made sales in a particular region.  Watch below to see how easy it is to create a count with this advanced SUMPRODUCT function....
Return the Last Value in a Column with the Offset ... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...
DATEDIF function: Introduction The DATEDIF function is a mystery function within Excel.  When you write it out in a workbook it doesn't give you any hints like other functions would and if you look it up in the function list you would not find it! Creepy...The DATEDIF function stands for "date difference" ...