Here is tip #8 in a series of an Excel Tip a Day for December 2015 – Working with Tabs . Tips range from the obvious to the simple to some more complex tips. Hopefully there is something you find helpful!
This tip is pretty obvious, but you’ll probably recognise that you have failed to do it in the past.
If you’re working with a spreadsheet that has a large number of tabs, you’ll often be jumping from one tab to another. Rather than using the scroll bar to do so, you can just temporarily drag the tabs close to eachother. When you are done working across those two tabs, drag the temporarily relocated tab back to where it came from. Simple, but a good little productivity hack.
I hope this was of some assistance to you!