NEW! FREE 1 Hour Excel Data Cleaning Course! Watch now 

Tutorials

If you use ALT + TAB to toggle, read these 6 lines…

1 Mins read
start_keyboard_alt_tab-1

We all use Alt-Tab to toggle different windows of applications. Even though we use this key shortcut to do our daily job yet we don’t know this tricks. Alt-Tab ↹ is the common name for a keyboard shortcut that has been in Microsoft Windows since Windows 3.0. This shortcut switches between top-level windows without using the mouse; hence, it was named Task Switcher (Flip in Windows Vista).




start_keyboard_alt_tab-1 It will really save time, especially when we work with 10+ excel files at a time.

Problem:

If you are working with multiple Excel files along with documents (PDF, PPT, browser etc.), this shortcut key will circulate between all of the windows sequentially before helping you land on the relevant Excel window.

Solution:

Next time when you simply want to toggle between open Excel files, try Ctrl + Tab on an open window of Excel instead of Alt + Tab.


keyboard-control-ctrl-tab

 

BTW  the same trick works with Browsers & PowerPoint (not Word). Try with different applications to see the effect.



Click here: To learn more such SUPER Excel course for free.

Check out blog article on: 7 Excel formula errors that make you look dumb
In this blog, I will try to help you to debug your excel formula. As soon as you will use excel formula, you will likely need to know how to correct the formula if there is any error. First of all, we need to know how many types of error, we can get we are applying excel formula in spreadsheets.

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…