Join Dennis Taylor for an in-depth discussion in this video Navigating workbooks, part of Excel 2016: Managing Multiple Worksheets and Workbooks.
- [Instructor] It's not uncommon to have more…than one workbook open at the same time.…At the moment, I've got four workbooks open,…but is it obvious?…Would I have forgotten how many I have open?…Do I have six open?…Well, sometimes you do forget…and, certainly, sometimes you do want to switch…back and forth between open workbooks…because you're copying and pasting data,…or you simply want to change your focus…and work on another workbook.…So, if I've forgotten how many workbooks are open,…I'll go to the View tab,…and the button on the right side, Switch Windows,…as I click it, reminds me of which files are open…and, of course, the current one is called DivisionFiles.…
We can see that at the top of the screen too.…I could certainly go to one of the other files if I wish…simply by clicking on it…and I'm over at that one.…And now, if I make some changes here or work with this,…I'll be on the Home tab, probably making…some formatting changes, maybe, something like that.…How do I get back to another workbook?…I'll have to go to the View tab and activate this.…
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