From the course: Excel 2013 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Displaying multiple worksheets and workbooks - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Displaying multiple worksheets and workbooks
If you're working with a workbook that has more than one sheet, you sometimes want to see a portion of each of these sheets at the same time. If you're working with different files at the same, you might want to see a portion of each of those files at the same time. In this movie, we need to be viewing the file 09-01-RegionalSales and two other files. When you do you have more than one file open, on the View tab in the Ribbon, the Switch Windows button shows you currently open files. The other two files we need to see are 09-01-Home Product Line and 09-01-EmployeeTable. In this workbook RegionalSales, suppose we want to see a portion of the Midwest and the South and the West sheets as well as the East sheet that's currently showing. On the View tab, if we want to see additional windows, we need to Click New Window three times. Back to the View tab, New Window, Back to the View tab, New Window. We now have four windows available, View tab, Arrange All and we do want to make sure in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.