Deleting

Tips, Tricks, and Answers

The following articles are available for the 'Deleting' topic. Click the article's title (shown in bold) to see the associated article.

Clearing and Deleting Cells
More often than not, editing a worksheet involves clearing and deleting cells. Unless you have a firm understanding of what these terms mean, you can easily become confused when you approach your editing tasks. This tip explains what the two terms (clearing and deleting) actually entail when it comes to your data.

Conditionally Deleting Rows
Want to delete a bunch of rows in a worksheet based on the value in a certain cell of each row? There are a couple of ways you can approach the problem, as discussed in this tip.

Deleting All Your Formulas
As the new year rolled around, you might have been faced with the task of making copies of your last-year workbooks to use for the new year. If this is the case, you might want to delete all the contents of those workbooks that don't contain formulas. This tip introduces a few techniques you can use to accomplish the task.

Deleting Blank Columns
Import data from another program, and you could end up with a lot of blank columns in your data. Here's the quickest way to get rid of these empty columns.

Deleting Duplicate Text Values
Got a list of data from which you want to delete duplicates? There are a couple of techniques you can use to get rid of the unwanted data, as described in this tip.

Deleting Every X Rows 2
A macro comes in handy when certain rows need to be removed from a worksheet.

Deleting Everything Except Formulas
Need to get rid of everything in a worksheet except the formulas? It's easier to make this huge change than you think it is.

Inserting and Deleting Rows in a Protected Worksheet
You've protected and saved your worksheet with explicit instructions that you be allowed to insert and delete rows. But when you try it, you find that you can't get rid of rows you want to remove. This is due to the way that Excel interprets your protection instructions, as explained in this tip.

Quickly Deleting Cells
Using a few quick keystrokes to activate the delete menu.

Quickly Deleting Rows and Columns
Keyboard shortcuts allow you to quickly perform routine tasks. One such task is the deletion of rows or columns. This tip explains how you can get rid of unwanted rows and columns very quickly, without once resorting to a mouse or menu.

Removing Duplicate Cells
If you need to often delete duplicate items from a list, then you'll love the macro presented in this tip. It makes quick work out of removing all those duplicates.

Removing Duplicate Rows
If you have a large table of data, you might want to remove all the records (rows) in which there is some duplicate value in the first column. This cannot be done with any built-in Excel function, but it can be done with a macro, as described in this tip.