Jump to Any Cell / Worksheet using Name Box [Quick Tip]
Welcome back. Did you have a good weekend?
We ate fish, watched a movie, had hilarious moments watching the kids and didn’t even leave the house for anything other than to buy some fish.
Coming back to Excel, I want to share a simple productivity tip with all of you. I accidentally learned this and now I use it often to speed up when I am working on large excel files.
Jump to Any Cell / Worksheet using Name Box
If you want to quickly jump to a named range or another worksheet, here is a quick trick. Just enter that name or address in the name box (top-left corner, next to formula bar). And bingo, you are on the target cell or sheet.
See this short demo to understand this trick:
Bonus tip: You can quickly access defined names using the little down arrow symbol.
Now, this would be even more useful, had I knew the keyboard shortcut for accessing namebox. Alas, I end up moving my mouse pointer to the name box instead.
If you know the keyboard shortcut to access the namebox, share it using comments. Also, share with us, how you simplify navigation in excel using various shortcuts and tricks.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« What is the most unusual thing you have used Excel for? [Quick Poll]||Excel Wedding Planner is here, Get your copy today! »|