I often have gigantic spreadsheets that have many cells that I need to update. But I also like to use the keyboard as much as possible (i.e. using keyboard shortcuts) and avoid using the mouse to be more efficient.
A common situation I have where I have to switch between keyboard/mouse is when I search for a term, and it finds it, but then I have to click on that cell with my mouse first before I go back to the keyboard.
Is there a way to select that cell directly using the keyboard?
Best Answer
Solution is simple. Basically whenever you search for something and it gets highlighted, you must press the esc key, then the cursor is placed at the search term, and you can go from there.