Selecting cells related to a formula in the active cell

February 16, 2013

2 comments

Excel Formula   finding cells related to excel formula   How Excel Skin Works   Mac Excel Shortcuts   mac shortcuts for excel   Using Your Excel Skin  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

How to highlight the cells related to a selected formula

This shortcut provides a very useful tool for those working with a plethora of formulas in their spreadsheets.  It will highlight all the cells that are involved in the formula of the active cell you have selected.  In the following steps the shortcut's effectivness will be more transparent.

Step 1: For this shortcut you must have a working formula in your spreadsheet.  I will demonstrate with the =SUM formula. 

Step 2: Select the cell that contains the formula.

To double-check there is a formula present in the cell, glance up at the function box. For this example my function box reads:


Step 3: Now that I have selected a cell with a formula in it I can execute the “Referenced” shortcut to see all cells that correspond with this formula.

⌃⇧{


Result: All the cells that are involved in my =SUM formula are now highlighted in the spreadsheet.  

This shortcut is especially useful in large seas of data when it may be hard to pinpoint all the cells related to a specific formula. 



2 Responses

Travis Daley
Travis Daley

February 14, 2017

AWESOME! Even works when you select multiple cells with formulas. Making it easier to spot cells in the raw data that were missed!

AQuayum
AQuayum

August 04, 2016

Thanks Alot. This is an excellent shortcut, which will help me so much on my Year End Audit Work. I will be sharing this with other people.

Keep it up.

Leave a comment

Comments will be approved before showing up.