Move Between Open Windows with Alt + Tab Switching

Not just an Excel shortcut, Alt-Tab Switching is a quick way to move between all open documents in Windows (Win key + Tab in Windows Vista). Using the keyboard to accomplish a task on a computer is usually much more efficient than using a mouse or other pointing device, and Alt-Tab Switching is one of the most used of these keyboard shortcuts.

Alt-Tab in Reverse

If you’re pressing Alt-Tab and accidentally go past the window you want to select, you don’t have to press the Tab key repeatedly to cycle through all open windows. Use the Alt+Shift+Tab keyboard shortcut to select windows in reverse order.

Using Alt-Tab Switching

  1. Open at least two files in Windows. These can be two Excel files or an Excel File and a Microsoft Word file for example.
  2. Press and hold down the Alt key on the keyboard.
  3. Press and release the Tab key on the keyboard without letting go of the Alt key.
  4. The Alt-Tab Fast Switching window should appear in the middle of your computer screen.
  5. This window should contain an icon for each document currently open on your computer.
  6. The first icon on the left will be for the current document - the one visible on the screen.
  7. The second icon from the left should be highlighted by a box.
  8. Below the icons should be the name of the document highlighted by the box.
  9. Release the Alt key and windows switch you to the highlighted document.
  10. To move to other documents shown in the Alt-Tab Fast Switching window, continue to hold down the Alt while tapping the Tab key. Each tap should move the highlight box left to right from one document to the next.
  11. Release the Alt key when the desired document is highlighted.
  12. Once the Alt + Tab Fast Switching window is open, you can reverse the direction of the highlight box - moving it from right to left - by holding down the Shift key as well as the Alt key and then tapping the Tab key.