- HOW TO REMOVE EXCEL SHORTCUT KEYS HOW TO
- HOW TO REMOVE EXCEL SHORTCUT KEYS FULL
- HOW TO REMOVE EXCEL SHORTCUT KEYS PC
Ctrl + Delete - This shortcut will delete the selected cells, column, or row.Here are 10 keyboard shortcuts for deleting in Excel: However, there are a few other ways to delete data in Excel using keyboard shortcuts. The most common way is to select the cells you want to delete and press the Delete key on your keyboard. Whether you're deleting an entire row or column, or just a few cells, there are a few different ways to do it. I do.Deleting data is a common task when working in Excel. And remember, dream big, live your truth, and share the Excel love.
HOW TO REMOVE EXCEL SHORTCUT KEYS PC
So, in this one, we’re going to use the DEL key, we’re going to have…go ahead and select all of it and clear it out and continue to go through until it’s all matching the same way.Īnd notice that each one uses its own, go through each of these, and at the end, there is a challenge to use a combination of all the different ways to make it look exactly the same.ĭon’t forget to visit where you can download these exercises, along with other free resources such as keyboard shortcut cheat sheets for both PC and Mac. So, go ahead and make the left section here match exactly as it appears on the right using the keyboard shortcuts that we talked about. Here are a few exercises I created specifically designed to help you practice and reinforce all the different shortcuts. Something that I cannot stress enough is the importance of selecting the cells first, and then making the change, right? “Select, then effect.” So, don’t just start deleting things, select the cell or cells that you want, and then use the shortcut to have it take effect.
HOW TO REMOVE EXCEL SHORTCUT KEYS HOW TO
And for the rest of these, these are all customized, so go ahead and go to the description of this video, click on the link for how to customize your Mac keyboard shortcuts, and go through all those steps to do it in detail. Don’t make that mistake, just hit the DEL key instead of the Backspace.įor the Mac, there is the other way of doing this, which is to use the fn + Delete on the keyboard. Instead of the Backspace, which will only give you this annoying first cell removed, but then the blinking cursor, not what you want. We’re going to go through each one.Ī couple things to note, the DEL key itself is what you want to use when you have multiple cells selected to clear the contents. Same idea for formats, for comments, for hyperlinks. So, for a clear all, ALT + H + E + A and it will remove not just that content itself, but all the data along with it. So it’s all related to that first letter, but you have to get to it with the ALT + H + E something. So, ALT + H for Home, E for the Clear, and then we have a whole bunch of options.Īnd the memory tricks for all of these is going to be, “Hey, everyone, clear all,” or, “Hey, everyone, clear formats,” “Hey, everyone, clear messages.” All right? The messages part is referring to the comments. The other ones are all based on the ALT key as the starting point. I’m going to bring that back with a little undo action. If you actually hit the DEL key, it will remove all of the contents without touching anything else. So, here are a number of different ways to clear contents. Instead of being sloppy about deleting information, there’s actually a way to be very precise and efficient about what specific information you want to get rid of, especially when your spreadsheets start getting more complex. So, what happens when you want to clear away some of it, but not all of it? Well, today I’m going to teach you the shortcut on how to clear cell contents. There are things like comments and hyperlinks and other data that’s actually there behind the scenes that may not be visible. I don’t know if you know this, but Excel can actually hold a lot of different types of information, sometimes all within a single cell.Īnd I’m not just talking about numbers or text.
HOW TO REMOVE EXCEL SHORTCUT KEYS FULL
It will save you minutes, hours, or days, depending on how complex your spreadsheet is :).ĭownload FREE Hands-On Exercises Full Video Transcript: Have you ever needed to clear PART of a cell, but not all of it? If so, this video is for you!