Monday 6 July 2015

Tip No. 1 (toggle between open spread sheets)

It very frustrating when you have multiple applications open (such as Excel, PowerPoint, Word, Chrome, and IE) and you want to switch between excel spread sheets only. No matter how efficient you are, this can get on to your nerves in a few minutes. In this tip, let me show you how to be more efficient

Use Control + Tab to toggle between open spread sheets only (Keep the Control button pressed while you press Tab button to switch)
That’s it! It is simple and will save you a lot of time

Note: While most of the people are addicted to Alt + Tab, the drawback is that it does NOT differentiate between different applications. So if you have 2 excel workbooks open along with a Chrome/FireFox/IE browser window, it will toggle one by one through each of these. Control + Tab will toggle between open excel workbooks only.

Bonus Tip : This technique works with any Microsoft application, including Power Point and Word


If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Thanks & Regards

CA Mohit Bansal
+91-9045773456

No comments:

Post a Comment