In other apps, when I hit Alt+Tab it switches to the previous app. Before I actually release the Alt key I can see a list of windows as well and the previous windows is selected. But in Excel 2010 (Professional Plus, if that makes any difference) hitting Alt+Tab and not releasing Alt shows Excel still selected, and in any case I have to hit Tab an extra time to switch to the previous application. (Alt+Tab+Tab) Furthermore, the iconized view showing my spreadsheet only takes up about 1/3 of the height available.
Needless to say this throws off my workflow because switching between Excel and another application is inconsistent, requiring an extra keystroke to switch away but not to switch back. Is this a bug in Excel, or is there some option that I need to change to get the default behavior? What's going on here?
Answer
In Excel 2010 and below,
- Go to "Excel Options" → "Advanced" → "Display",
- Uncheck "Show all windows in the Taskbar",
- Click "OK" to close the Options window.
Now Alt+Tab should work fine again.
[With] the [above] solution …, you will no longer be able
to Alt+Tab between Excel documents [workbooks] –
Alt+Tab will only "see" the last active Excel doc.
Work-around: with Excel active,
Ctrl+Tab will switch between documents.
To revert this to the old behavior,
simply go back and check the option again.
This option does not exist in Excel 2013.
teylyn says
In the 2013 version, each Excel file shows in its own window.
This is one major change to previous versions.
Each window has its own ribbon
and it is no longer possible to show several Excel files in the same window.
No comments:
Post a Comment