As you work in Excel, you may find yourself with more than one window open at once. This is automatically true if you’re using multiple workbooks. If you’re only working with a single display, it’s handy to rapidly switch between two windows to always keep them in view. Fortunately, Excel offers an easy way to do exactly that. Let’s learn how to switch windows in Microsoft Excel.
How to Switch Windows in Excel
Imagine that you have two or more Excel files open. On a single screen, you’ll likely only be viewing one at a time, with the other windows running in the background. Instead of minimizing and constantly dragging them around, you can use the Excel Switch Windows feature to instantly bring any window to the front.
Switch Windows in Excel is an option that forms up part of the View tab. You’ll find the View tab on the ribbon, the list of menus and options across the top of your screen. Click on View, and you’ll see the Switch Windows dropdown over on the right side of the tab.
Click on Switch Windows, and Excel will display a new dropdown. On it, you’ll see every Excel window that you have open listed, by file name. The open window has a checkmark beside it.
To switch to another window, simply click on its name. Excel will bring it into view, switching away from other open windows. Remember, they’ll still be running in the background. To choose another window or reverse your changes, simply click a different file.
As you can see, the Switch Windows feature in Microsoft Excel is a great way to control how windows and content display on your screen. In just a few clicks, you can switch to any open Excel window that you want. It avoids the need to minimize, resize, and change views constantly.