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. 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!
0 kommentar(er)
