Switch Between Workbooks Faster in Excel 2007 and 2010

by Gregory on October 12, 2010

Switch Windows Shortcut in Excel 2010

In the Excel 2003 menu system, two clicks of the mouse will switch between workbooks. In the menu conflagration for Excel 2007 and 2010 it’s three clicks: View, Switch Windows, then pick the workbook. (As shown below)

Switch Windows on View Menu in 2010

This doesn’t seem like a big deal, but it bugs the heck out of me. So I added the Switch Windows command to the Quick Access Toolbar in Excel 2010 and now have my customary two clicks back. It works in Excel 2007, too.

Add the Switch Windows Command to the Quick Access Toolbar

In Excel 2010 right-click the menu, then select Customize Quick Access Toolbar from the pop-up menu.

Customize Quick Access Toolbar

In the Excel Options dialog box (shown below) the Quick Access Toolbar should be selected in the left pane.

Under Choose commands from, select All Commands from the drop-down list, scroll down and select Switch Windows, then click the Add>> button to move that command to the right-hand window.

You can move it up or down according to where you would like it placed on the QAT toolbar. Click OK to finish.

Add Switch Windows to QAT

Now you’ve saved yourself one click and any associated aggravation every time you want to switch workbooks in Excel 2010.

Switch Windows on Quick Access Toolbar

This also works for Excel 2007. Did I mention that?

Use a Keyboard Shortcut to Switch Windows

The keyboard shortcut Ctrl+Tab will move to the next window. With only two workbooks open it will toggle between them quickly and is faster than using Switch Windows from the QAT.

However, with more than two workbooks open this method doesn’t work very well because cycling through each open workbook is slower, and sometimes confusing.

Related Posts Plugin for WordPress, Blogger...

Comments on this entry are closed.

Previous post:

Next post: