Tame your computer – super switching

9 Nov

One of my most recent shortcuts of the week was CTRL + TAB to move to the next open tab in Internet Explorer, Firefox and Chrome. But did you know you can also use this shortcut in Excel to switch between all open Excel workbooks?

Here’s how:

  1. Press CTRL + TAB to display the next currently open Excel workbook.
  2. Keep your finger on the CTRL key and continue to press the TAB key, until you reach your desired workbook. (In case you overshoot your desired window, press SHIFT + CTRL + TAB to cycle the other way.)
  3. Release the CTRL key.

If you have lots and lots of Excel workbooks open it might be faster to use the Switch Windows button in the Window group on the View tab, but you know how much I love keyboard shortcuts so I simply cannot help myself! This was why back in March 2013 I launched a ‘shortcut of the week’ feature on our website, in an effort to help you work faster (and healthier). You can find the shortcut of the week on our home page, from where you can also download or print our shortcut archive.

PS I’m committed to sharing the best of what I know with others so please don’t keep these tips a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit or reprint it  (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing karen@roem.co.uk – if your tip is selected, I’ll publish it along with your name; the bragging rights will last a lifetime.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: