Excel 2016: Managing Multiple Worksheets and Workbooks

Learn how to grapple with a common Excel problem: managing large amounts of data contained in multiple worksheets and workbooks.

Introduction

• Introduction
• Using the exercise files

1. Utility Tasks Associated with Multiple Worksheets

• Navigation and display tips
• Inserting and deleting worksheets
• Copying and moving worksheets within a workbook
• Changing tab colors and renaming sheets
• Hiding/unhiding worksheet tabs; protecting hidden worksheets

2. Working with Different Worksheets Together

• Displaying multiple worksheets of the same workbook
• Copying, moving, and inserting data on different sheets
• Selecting adjacent or non-adjacent worksheets; applying global changes
• Getting data from other sheets using formulas and the INDIRECT function

3. Working with Multiple Workbooks

• Navigating workbooks
• Displaying multiple worksheets of different workbooks
• Copying and moving data and entire worksheets across different workbooks

4. Linking Formulas across Multiple Workbooks

• Creating formulas that link worksheets in different books
• Locating and managing links between multiple workbooks

Conclusion

• Next steps