When working with one Excel file (called a workbook) at a time,
it is pretty easy to stay organized and move around easily. Opening a second
Excel file can complicate things a little bit. Trying to move between multiple
Excel worksheets can get even more problematic, especially if you need to look
back and forth quickly. Then, make it more difficult by moving within the
worksheets within the different files.
An example of this is when you are working on your budget from
the last year or two to create your upcoming budget. If you have worksheets
from several departments within each budget file, it can get really confusing.
In this scenario we can add the option of Switch Windows
which will be very easy for navigate between the work books.
How to Close the multiple workbooks in single click.
Sometimes it will be very boring task by closing the file
one by one especially while leaving the office , here we have another option of
close all through which we can close all the file with a single click
Video Link: Watch Video