Hi, this is Wayne again with a topic “Excel General Keyboard Shortcuts”.
In this excel video, we’re going to look at some of the general keyboard shortcuts that every user of excel needs to know. Let’S get started. The first shortcut is ctrl o. If you tap ctrl o that will take you to a screen where you can open a new workbook, so it’s a shortcut to get you to what’s called the backstage view. This is the backstage view. You’Ve got a list of recently opened excel workbooks. We have some locations that we’ve accessed or that we could access in order to open a workbook i’ll click back and let’s look at another keyboard shortcut that every excel user should know, and that is control n, so hold ctrl, tap n. That gives you a brand new workbook, completely separate from any other workbook that you’ve been working in next is a very basic keyboard shortcut, but you’ll use it all the time. If you don’t already know about it, this will save you a lot of time and that is control s as you’re working in excel anytime. You put in some key information that you want to make sure you don’t lose just hold control, tap s and your data will be saved quickly. Next, we have control p, holding control and tapping p, takes you again to the backstage view, but specifically to the print settings. Here you can adjust some of those settings and get a preview of what it will look like and then just click print and it should print going back. Let’S say i’ve recently quick saved ctrl s, and now i’m ready to be done with this workbook for the day i could use ctrl w to quickly close this workbook, so i’ll hold ctrl tap w and the workbook is closed.
Let’S hold ctrl and tap o to open up our workbook again. The next general keyboard shortcut that you need to know is very simple, but it’s very useful. It’S just tapping f7 on the keyboard. This will bring up the spell check, options and you’ll be able to use spell check to find any mistakes in your spreadsheet.
Next, we have f1. If you tap the f1 key, the help panel opens up at the right and you can search for any help. You might need a similar tool that a lot of people don’t know about is alt q when you hold alt and tap q, it activates this tell me field in the upper right corner. That’S what this is called.
The tell me field – and here you’ll find a list of your recently used actions, so that can be helpful if you’re, trying to remember how you accessed a feature in excel or a tool. There are also some suggested actions that can help get you on the right track, or the other option is simply to click and type what you’re looking for and then you can look through the options that are brought up. So, in my opinion, those are the general keyboard shortcuts that every excel user needs to know just at a basic level in order to use excel effectively. There’S many more keyboard shortcuts that you can learn about, and i would encourage you to watch my other keyboard shortcut.
Videos, they include everything from copy cut paste to how to jump around your data in excel from the upper left corner to the upper right, lower right, lower left just how to navigate your spreadsheet and much more thanks for watching. I hope you found this tutorial to be helpful. If you did please like follow and subscribe, and when you do click the bell so you’ll be notified. When i post another video, if you’d like to support my channel, consider clicking the thanks button below the video or you can support me through my patreon account or by buying channel merch and you’ll, see information about those options in the description below the video.
Speaking of patreon, i’d like to give a quick shout out to my five dollar patreon supporters. Thank you. So much for all you do to support the channel. We have a couple of recent five dollar supporters and i really appreciate that extra help. So i can keep making these videos. Thank you so much .