Join Dennis Taylor for an in-depth discussion in this video Displaying multiple worksheets of the same workbook, part of Excel 2016: Managing Multiple Worksheets and Workbooks.
- [Instructor] In this movie,…we need to have two files open.…One is called DepartmentData.…The other one is called RegionalData.…If you have both files open,…and you have no other files open,…you can easily move back and forth between them…by pressing Control + Tab.…Now, the focus of this movie…is how we might at different times…want to see different worksheets…out of the same workbook, at the same time.…Let's first look at the DepartmentData workbook.…It's got lots of different sheets,…and many of the sheets are not related to one another,…but at certain times you need…to be seeing two different sheets at the same time.…
First thought is let's go to the View tab,…choose Arrange All.…That description is, "Stack your open windows…"so you can see all of them at once."…Click that option.…There's a box here that we probably want to check.…It says Windows of active workbook.…Now if you ignore this, and simply click okay,…Excel says I'm looking around for other files…that you might have open right now…and therefore when you click okay,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with different worksheets together
- Copying and moving worksheets within a workbook
- Linking formulas across multiple workbooks
- Changing tab colors and renaming sheets
- Copying, moving, and inserting data on different sheets
- Working with multiple workbooks
- Navigating workbooks
- Getting data from other sheets with 3D formulas