If this tip doesn’t change your life, it can change your cube mates life or someone’s life who uses Excel a lot.
This short (4 minute) video demonstrates the power of knowing how to quickly navigate around a spreadsheet without using the vertical or horizontal scroll bars.
Even if you don’t use Excel, watch the video…it is like a magic show you might see in Las Vegas.
Add this article to:
Related articles:
- Customize Office Toolbars
- Open Office 2.0 — FREE Alternative to Microsoft Office
- Solution for computer that can’t change desktop wallpaper / background
- Yet another feature yanked from the NEW Microsoft Office 2007
- OpenOffice – Revisited
Tags: Excel, Microsoft, navigate, spreadsheet
Loading ...
HelpMeRick.com started as a monthly tip site for beginners in 1996, and now supports our popular call-in computer show, and hosts thousands of useful computer tips and links.
this is gonna be extremely helpful!
thank you, thank you, thank you
may I ask where you learned this?
I keep saying I am gonna make time to go thru the tutorials, but haven’t…. maybe I really need to?
I learned it probably from reading a book or from someone else at least 10 or so years ago. It seemed so helpful that it stuck with me.
Ok, instead of clicking in the name box to get to a cell, just hit F5 and enter the cell you want to get to, be it cell adress or name.
Anyone who’s been using excel for more than 2 weeks should know this.
You should also mention you can use the named ranges in formulas, such as “=sum(Cost + Profit)” rather than “=sum(A1 + A2)”. Makes a large spreadsheet much easier to debug and understand, particularly when you are sharing it with others.
Thanks.
If you want to edit the range name or the range itself, or remove it entirely, you must use Insert | Name | Define, from the main menu. You can also alternatively create new named ranges in this same dialog box. One word of caution though, any names you define in this dialog box will not display in the Range name drop down list you described.