There will be a check next to the file that you are currently viewing for easy reference. Pick the workbook you would like to move to from the list of available open files. Go to the View tab and click on the Switch Windows button. One option to switch between the open Excel files is to use the View tab on the ribbon. I have highlighted the most popular ways below. The great thing about many of these methods is that they can also be used to move between any of the open files on your computer. There are several different ways to move around and switch between files. Or, you are able to view the workbooks side by side, tiled, cascaded, etc. You can have all of the workbooks open but just look at one at a time. If you have worksheets from several departments within each budget file, it can get really confusing. Then, make it more difficult by moving within the worksheets within the different files.Īn example of this is when you are working on your budget from the last year or two to create your upcoming budget. Trying to move between multiple Excel worksheets can get even more problematic, especially if you need to look back and forth quickly. Opening a second Excel file can complicate things a little bit.

When working with one Excel file (called a workbook) at a time, it is pretty easy to stay organized and move around easily.