From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Displaying multiple worksheets and workbooks

Displaying multiple worksheets and workbooks

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Displaying multiple worksheets and workbooks

- If you have more than one workbook open, sometimes it's advantageous to see a portion of each of those workbooks. And at other times, when you're focusing only on a single workbook, it might be to your advantage to be able to see different worksheets of that same workbook. It can get a little bit confusing at times if you do have multiple workbooks open and you're trying to accomplish both of those objectives at the same time. We need to have three files open right now, 0901 Home Products Line, 0901 Regional Sales, and 0901 Employee table. Now maybe the files are interrelated, or maybe we're going to be copying information from one file to another. How do we get back and forth between files? On the View tab, if you click the Switch Windows button, you'll see which files are open and which one we're currently seeing, of course, its heading is at the top of the page. And we can easily get here and switch. If you're working on the Home tab, or the Formulas tab, or the Data tab, if…

Contents