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:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Sumproduct & Weighted Averages   What does it do? It returns the sum of the products of corresponding ranges or arrays Formula breakdown: =SUMPRODUCT(array1, , ...) What it means: =SUMPRODUCT(this array, with that array…) A quick way to calculate the weighted average of two lis...
Evaluate Formulas Step By Step in Excel This is one of the coolest tricks I have seen in Excel, as there are countless times wherein I had a hard time understand formulas. Especially long and complex ones! Excel provides the way to evaluate your formula, and break it down step by step so that you can understand it! ...
Vlookup in Multiple Excel Sheets What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another sheet´s column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLO...
Advanced SUMPRODUCT Function: Sum Multiple Criteri... What does it do? It returns the sum of multiple criteria from the corresponding ranges or arrays Formula breakdown: =SUMPRODUCT((array 1 criteria) * (array2 criteria) * array values) What it means: =SUMPRODUCT((find my criteria in this array) * (find my criteri...