Toggling Between Open Excel Files Using the CTRL + F6 Shortcut
Many PC users know that Alt + Tab cycles through all the files and programs that are open on your computer. However, if you are working in Excel and you just want to toggle between all of your open spreadsheets, you can press Ctrl + Tab, or Ctrl + F6.
Both of these shortcuts also work when you have multiple PowerPoint files open. When working in Word, CTRL + F6 is the only option to toggle between open Word documents.
If you enjoyed reading this and want to improve your skills further, then try our Excel Best Practices Self-Study Course. You can also browse our other range of Self-Study Courses here.
Training The Street also offers a more advanced In-Person/Virtual Public Course called, Applied Excel. Where you can gain the skills needed for parsing, analyzing, and presenting information from large data sets.