From the course: Excel 2016: Tips and Tricks

Unlock the full course today

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

Open, close, save, and create new workbooks with keystrokes

Open, close, save, and create new workbooks with keystrokes

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Open, close, save, and create new workbooks with keystrokes

“

- [Voiceover] When you open files or close files or save files or use save as to save a file under a different name or as a different type, or when you create a new file, you're likely to go to the File tab in the ribbon and see these choices. There's New, Open, Save, Save As, down at the bottom here, Close. But there's a keystroke shortcut for each of these and in some cases, two different keystroke shortcuts. If you go to the Profits sheet in the chapter 4 file, scroll down a bit and you'll see some of these choices here. Some of them might be those that you can almost guess at, others not so much. If I'd like to open a new file, I can press either Ctrl+O or Ctrl+F12. Here's Ctrl+O, O for open perhaps, and there are files listed there. Maybe I'll open this other file that I've been working with recently, chapter 3 file there. I don't really want to use that right now, but I'll press Ctrl+tab. But maybe I really want to close it. As I press Ctrl+tab going back here, we see a…

Contents