In this video, we're going to learn how to delete a cell or a range completely. It often happens that you delete the cell contents of a range of cells by selecting everything and then pressing the delete key. But it's important to realize that in Excel, the delete key simply deletes the cell contents. It will leave any other information like self formatting, which includes the color the borders, as well as leaving things that comments. So how is it possible to remove everything? Even if you are pretty good with your keyboard shortcuts, This process will take some time hitting delete, using alt h h in to remove any full colors using Ctrl Shift minus to delete the borders, and then right click followed by m to delete the comments.
That process can take quite a while. So how can we do this? All with a single command on the Home tab all the way across in the right. In the editing group, you'll notice an option for clear. And you'll also notice it has a drop down. The very first command of clear all will clear absolutely everything as it says in the tooltip.
All content formatting, and comments are good. So simply clicking this button once, delete absolutely everything. I in fact, use this so much that I've edited to my quick access toolbar, as you can see over here. And in fact, I use my keyboard to access it really quickly. As you'll notice, when I press Alt, the key or command is number eight. So when I select information, all I need to do is press ALT n eight to clear.
So in summary, deleting only removes cell contents. You don't have to go as far as deleting the entire row or column. To remove this information, you simply need to use the clear or command which can be found on the Home tab and to clear but I would suggest adding it to your Quick Access Toolbar because you are going to be using it a lot in the future. We'll see in the next video