Excel Shortcuts for navigating within Sheet

Have you ever noticed when you are navigating in your excel sheet and the excel sheet has a lot of data, it becomes very cumbersome to navigate in excel sheet?

For example, if you have data which runs across multiple years, comprising of 5 years historical data and 5 years projections, that means, if you are navigating from first year/ month to last year or month, you will have to press the right key 10 times. That takes a lot of time!

Imagine you have to go from the first year to the last year for all the line items. Total Right keystrokes: 500 x 3 x 10 = whooping 15K keystrokes just for navigation!! Do you think visiting/ revisiting each of the items 3 times during the life of the model is really worth it?

That is a lot of pain and the sure shot way to carpal tunnel syndrome!


We have a shortcut for you

Ctrl + right key

Cell Navigation in Excel

What benefits do you get?

Save your time and effort with this shortcut while navigating the model.

Now that you know the excel shortcut for navigating within sheet, now know the Excel Shortcut For Sheet Navigation and Selecting Rows In An Excel Sheet

Excel Shortcut For Sheet Navigation
Selecting Rows In An Excel Sheet

I am greatly impressed by the quality of your training. In fact it is the reason I am going to take the exam this time as I had previously decided not to take it because the quality of the training I had purchased was not what I had expected. All the best to you and everyone at Edupristine.
I am very pleased to have found these courses offered by a recognized, reputable training firm at a great value! Thank you!

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by Edu for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP is not responsible for any fees or costs paid by the user to Edu nor is GARP responsible for any fees or costs of any person or entity providing any services to Edu Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas®, and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to legal@edupristine.com and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

2015 © Edupristine. ALL Rights Reserved.

tick_classroom_city.php Post ID = 56765