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
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