How to navigate using Excel GoTo (ctrl-G or F5)? How can I use Excel GoTo (ctrl-

Question

How to navigate using Excel GoTo (ctrl-G or F5)? How can I use Excel GoTo (ctrl-G or F5) to "visit" each cell with a selected condition? For example, in a very large worksheet -- more than what I can display on the screen readably -- I want to find all cells that display an Excel error. I can press F5, click on Special, and select Formula, Errors. That selects all the cells in the selected range, the entire worksheet by default. That's fine if I can see all the selected cells. But if I can't, I want to truly "go to" each selected cell. Is there a way to do that? One problem is: "selected cells" is a fragile state. Most keys that I press deselect them. (Remember: I cannot see them all to begin with.) FYI, my workaround is to use the following in the VBA Immediate Window: print ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas, xlErrors).Address Of course, that just provides a list. And it does not work if I've disabled macros for security reasons...

Thanks for help !!

Explanation / Answer

Hi..

try this

Once you have selected all formula cells use the "Tab" key to cycle through the selection.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.