When you have multiple spreadsheets open, it can take many clicks shifting between different files. In addition, you never want to end up entering information into the wrong file. Use Ctrl + Tab to shift between different files easily. The great part of this tip is that it also works in other programs as well like Firefox and Chrome while using Windows 7. You can easily shift between any open tabs!
You are here: / / Move Between Different Open Microsoft Office Files