Clearing vs. Deleting

April 06, 2013


Clearing   clearing selection   deleting   deleting selection   difference between clearing and selecting   Excel on Mac   Excel Resources   Excel Shortcuts for Mac  

We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.


 Clearing and Deleting are two very different functions in Microsoft Excel.  On one hand we have a single key to “clear the contents of the selection,” and on the other hand we have a simple shortcut to “delete the selection.”  Before getting into the shortcuts we must define clearing and deleting.  

When you clear the contents of an active cell you are simply clearing whatever is inside the cell and nothing more.  Deleting the selection is a different story.  Deleting the selection effectively clears everything in the cell by removing the cell from the spreadsheet entirely.  When you execute the “Delete Selection” shortcut a dialog box will pop up to ask you which way you would like to shift the cells, a result of the complete removal of the active cell.    

Clearing the Cell

We will start with clearing the cell.  This isn’t so much a shortcut as it is a function of Microsoft Excel that resides on the “delete” key.  To clear the content of the active cell all you must do is select the cell you wish to clear, and press the “delete” key.  It’s so simple no pictures are needed!  The only caveat to this function is that it will only delete 1 cell at a time.   

Now onto the fun stuff, deleting.  

Deleting the Cell

Step 1: As with most Microsoft Excel Shortcuts, the “delete selection” shortcut starts by selecting the cells you wish to modify.


The example above is to show the shifting capabilities of the “delete selection” shortcut.  

Step 2: Now that I have selected the cell I wish to delete I can execute the shortcut: 


And this pops up:

I would like to replace the “Delete Me” cell with the “Don’t Delete Me!” cell so I chose “Shift cells up” and click OK. 

I have successfully deleted the cell that was in 1A and replaced it with the cell that was in 2A by shifting the cells up. 

When using Microsoft Excel for Mac I tend to use the “delete selection” shortcut more than the “clear selection” shortcut.  This is not to say the “clear selection” is useless. It is the fact that the “delete selection” shortcut effectively clears the selected cell as well as shifts all cells, which is something that is usually done (especially after clearing a row or column) anyway.  

Leave a comment

Comments will be approved before showing up.