What do we do when we have to go to an Excel Cell in some other worksheet (or a cell far away in the same worksheet).
Normally, we select the worksheet tab, then spot the cell (which may involve scrolling) and then click on it. In this blog post, learn 2 quick methods to do this.
#1 – Using Excel Watch Window to Monitor an Excel Cell
Excel Watch Window enables you to keep a track of the values in selected cells.
It is a handy feature if you have a couple of cells that you want to monitor as you work with your data.
An additional benefit of Excel Watch Window is that can quickly take you to the cell/cells that you are monitoring.
Using Excel Watch Window
- Go to Formulas –> Formula Auditing –> Watch Window
- In the Watch Window dialogue box, Click Add Watch
- In the Add Watch pop-up, select the cell that you want to monitor. Note that if you select a range instead of a single cell, all cells would be added as separate cells.
- As the watch is added, you can see the cell value and formula (if any), and changes can be monitored in real-time
- To go to a cell quickly, simply double-click on the cell in the watch window
Note that double-clicking on the watch window to go the cell would not work if you are in some other workbook.
#2 – Storing the Excel Cell Reference in Temporary Memory
Did you know?? Excel can store up to 4 temporary cell address, which you can use to quickly select that cell. This could be useful if you have data spread across various tabs and you have to refer to a few important cells again and again.
- Select a cell (or range) that you want to store as a temporary location (this could be in the same or other worksheets)
- Go to Name Box (left of Formula bar)
- Click in the Name Box and press Enter
These steps store the cell reference in temporary memory.
Going to The Cell Reference
- To go to the cell reference stored in temporary memory, press F5 (or Go To Home –> Editing –> Find & Select –> Go To)
- In the Go To Dialogue box, double-click on the cell reference to go to that cell
Note that Excel can store a maximum of 4 cell references at a time. If you add more references by using the above method, you would only see the latest four references.
Also, since this is in the temporary memory of Excel, it gets erased when you close the workbook.
If your data has named ranges, their names would also show up in the Go To dialogue box. While there can only be 4 temporary cell references at a time, there is no restriction on the number of named ranges.
You May Also Like the Following Excel Tutorials:
2 thoughts on “How to Quickly Select a Far-off Excel Cell or Range”
Watch Window option helped. Thanks. Great job of sharing your knowledge
Glad you found this useful 🙂
Comments are closed.