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.
Related articles:
Loading ...
,
Wow Rick!
This one is a HUGE time saver….. thanks a bunch for sharing.
Matt
PS -
Is that some new video graphics I saw in the trailer? with the Help Me Rick logo?
Glad you liked it. Are you talking about my logo watermark? Or the opening and closing logos? They are all the same…at least for the last year or so.
This technique is also valid for the free OpenOffice.org spreadsheet.
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.