Have you ever felt the need to navigate quickly between excel sheets?
I usually have a lot of sheets in my excel workbook. Most of the time, I have to navigate between them to pick up values or make changes.
For example in my model I have to keep switching a lot between assumptions sheet, profit and loss, balance sheet and ratio sheet. For this it will be very irritating if I have to use the mouse everytime to go to the sheet.
So how can I navigate without the mouse ?
Simple! I use shortcuts to navigate smoothly and easily through the workbook.
Fn + ⌥ + (↑ / ↓) for navigating forward and backward
How is this beneficial?
I can move between sheets quickly without the use of the mouse.