Excel 2007 opens files in the same window. Doesn't open separate windows. Can't toggle or switch between Excel worksheets.
Posted by - NA - on 16 October 2009 05:02 PM

By design, Excel 2007 in Microsoft Office opens multiple files in a single session (or window).  The Switch Windows icon under View in the ribbon is used to switch between open files, but it's location may be less than optimal.

An alternative to improve efficiency in Excel 2007 is to add the "Switch Windows" command to the Quick Access Toolbar.  When you click this icon, it drops down the list of all open spreadsheets and you can immediately navigate to any of them with a single click.

To add "Switch Windows" to the Quick Access Toolbar

  1. Click the down arrow to the right of the quick access icons and select "More commands".
  2. Change "select command from…" to "All Commands" then scroll down to locate the Switch Windows command.
  3. Highlight "Switch Windows" in the left pane and click Add to move it into the right pane.
  4. Click OK to save.

The icon can now be used in the Quick Access Toolbar.

If you need further assistance please call the VOS™ Support Center at (877) 287-9867.

(2 vote(s))
Not helpful

Comments (0)