Tom’s Tutorials For Excel: Shortcut to Activate the Next or Last Open Workbook

Tom’s Tutorials For Excel: Shortcut to Activate the Next or Last Open Workbook

If you have a bunch of workbooks open in the same instance of Excel, and you want to cycle through them in turn to activate the next ones (to the right on your task bar), or the previous ones (to the left on your taskbar), here are keyboard shortcuts to do that.

From your keyboard, press Ctrl+Tab or Ctrl+F6 to activate the next (cycling from left to right) open workbooks in that same instance of Excel.



From your keyboard, press Ctrl+Shift+Tab or Ctrl+Shift+F6 to activate the previous (cycling from right to left) open workbooks in that same instance of Excel.