How to manage multiple Workbook and Worksheet
Now we will see that how we can manage multiple workbook and worksheet all
together at once in MS Excel.
Sometimes we face this common problem of copying data from one workbook to
another workbook. Now to overcome that we have one option as 'Switch
Windows' in our VIEW tab.
In that option we can see that list of all our workbooks is present. And
the workbook which is currently opened has a tick marked in front of its
Now by clicking on that option we can switch to any workbook. We can also
add this option to our quick access toolbar which will be very useful for
To move from one worksheet to another we can also press 'Ctrl+Tab' key from
If you want to view all the data of each workbook together on our screen at
once, that 'Arrange All' option is present in our VIEW tab. We can use that
option for our required task.
We can also set area for each of the workbook by dragging them as per our
Share a personalized message with your friends.