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
When you want to remove information from a worksheet, you can either clear cells or delete cells. This tip examines the difference between the two, focusing on the different ways you can both delete and clear information.

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 Columns
Got a worksheet in which there may be entire columns that are duplicates of each other? If you want to delete those duplicate columns you'll appreciate the ideas presented in this tip.

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
Deleting rows or columns is easy when you use the shortcut described in this tip. Just select the rows or columns and then use the keyboard to do your deleting.

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
Too much data in your worksheet? Does too much of that data duplicate other data? Here's how to get rid of the duplicates so you are left with the unique information you need.