Join Dennis Taylor for an in-depth discussion in this video Selecting adjacent or non-adjacent worksheets; applying global changes, part of Excel 2016: Managing Multiple Worksheets and Workbooks.
- [Instructor] In this workbook called FourStateSales,…we've got four sheets pertaining to data…in different states.…They happen to have the same layout,…but what we're about to show here,…doesn't necessarily depend upon that idea.…There could be times when you want to make changes…to multiple sheets.…You might even want to make changes to all the sheets…in a workbook.…We might have a model here that has 10 states…and maybe no empty sheets at all.…If we wanted to select all the sheets…and then make a change,…we could right click on any sheet tab…and choose Select All Sheets,…and there's how, the look of the sheet tabs…is different now.…
All of the sheets are selected…and at the top of the screen,…you'll see the word, Group.…It's in brackets,…and anytime you do see the word, Group,…it means that at least two sheets have been grouped.…Now, if I type something in cell A10,…maybe I'll type in 2017…and simply press Enter,…that has happened on everyone of these sheets.…If I click Sheet2, which is empty,…notice how it ungrouped the sheets.…
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