Join Dennis Taylor for an in-depth discussion in this video Displaying multiple worksheets of different workbooks, part of Excel 2016: Managing Multiple Worksheets and Workbooks.
- When you've got multiple workbooks open you may want want…to see a portion of the different workbooks…at the same time on your screen.…In other words, a split screen.…In this movie we want to show how you can work with four…different files, and of course the idea that you could…be working with five or three is going to apply as well.…I've got four files open.…Division files is one of them.…Another file, and I will be pressing control, shift, tab,…state sales data, control, shift, tab again, chart data…and control, shift, tab again, quarterly budget.…
Remember, the standard way to go to a different…workbook if you have multiple workbooks open is to go to the…view tab and off to the right the switch windows button…its reminder shows us the names of all files that are open…with a check mark next to the current one.…And in the previous movie which you might have seen,…I copied this button so that on my screen…it's in the quick access toolbar.…And you could do that too, and there, that button's…available all the time regardless of which tab is active.…
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