Chapter 1: Working with Multiple Workbooks

There are occasions when you need to work with several open workbooks and Excel 2019 provides several features that make it easier to work with multiple windows.

In this chapter, we will cover how to:

• Switch between multiple open workbooks.
• View multiple workbooks side-by-side.
• Arrange all open workbooks on your screen.
• Split the screen of your worksheet.
• Move data between workbooks.
• Move worksheets between workbooks.