Course Content

Course Content

Description

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 name.

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 us.

To move from one worksheet to another we can also press 'Ctrl+Tab' key from our keyboard.

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 need.

FAQs

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere