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.
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.