Microsoft Excel tip that will change your life - Video Tip
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.
- ‹ previous
- 297 of 1340
- next ›
Additional information on named ranges
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.
Excellent point
Thanks.
One more point on named ranges
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.
Easy
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.
Excel tip - thank you
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 honestly don't remember
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.
Post new comment