CREATE THE FUTURE

Tools to create the future you envision!     

What's New?

 

 | About Us | Contact Us | Site Map |     

Home
Access Tips
Excel Tips
Microsoft Office Tips
PowerPoint Tips
Word Tips

 

Weekly Picks

Cool Websites
Publications
Key Trends
Useful Resources
Tech Tips
 
Picks Archives
 
 

Bookmark and Share

Tech Tip of the Week:  December 21 - 27, 2014

View Cells Referenced by a Formula in Excel

When debugging a worksheet it can be very useful to look at each cell referenced in a formula.  Here’s how:

bullet

Select the cell containing the formula

bullet

Press Ctrl + [  (Ctrl + open square bracket)

bullet

Excel highlights all cells referenced by the formula and moves the current selection to the first of the referenced cells

bullet

Press Enter and the selection moves to the next referenced cell

bullet

Each time you press Enter the selection moves to the next referenced cell

In the following example I selected cell B11 which contained the formula =B10+B7+B4. When I pressed Ctrl + [ cells B10, B7, and B4; were highlighted and the current selection was B10.

This tip appears to work in the new Office 2007 or 2010 as well as earlier versions.
 

View all Access Tech Tips

View an alphabetical listing of Access Tech Tips

View all Excel Tech Tips

View an alphabetical listing of Excel Tech Tips

View all Office Tech Tips

View an alphabetical listing of Office Tech Tips

View all PowerPoint Tech Tips

View an alphabetical listing of PowerPoint Tech Tips

View all Word Tech Tips

View an alphabetical listing of Word Tech Tips

   

"Education is the most powerful weapon which you can use to change the world." Nelson Mandela   View Past Quotes

frank@createthefuture.com susan@createthefuture.com

© 2014 Creative Information Systems 

 In Association with Amazon.com

Revised: December 22, 2014