From the course: Excel 2016: Tips and Tricks
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Navigate between workbooks efficiently
From the course: Excel 2016: Tips and Tricks
Navigate between workbooks efficiently
- [Voiceover] It's not uncommon to have more than one workbook open at the same time. Currently I'm looking at this workbook for chapter four. I'm on a worksheet called Profits. But I might wanna have another workbook open, so I could simply go to the File tab on the ribbon, choose an existing file that I've had open recently. I could go to Open. I might wanna create a brand new one. I'll simply click New for now. And a blank workbook, fine. And I might be copying data onto this, but how do I get back to the other workbook? I'll go to the View tab on the ribbon, Switch Windows, and click on the other file that's currently open back here. Now, I might have three files open, four files, five open at the same time. I sometimes am working with five or six files. It can get a little confusing at times. It can get a little annoying too that when you want to switch, you have to keep going back to the View tab to see which files are open, which is handy at times, of course, but also to click…
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.