Topic: Deleting

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Deleting Duplicate Text Values Got a long list from which you need to remove the duplicates? There are a couple of ways you can perform this common task. This tip explains two ways to do it manually, and then provides to different macros that will do it for you. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Deleting Every X Rows 2 A macro comes in handy when certain rows need to be removed from a worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Deleting Everything Except Formulas Want to get rid of everything in a worksheet except for formulas? It’s easy if you use the Go To Special dialog box. This tip explains the steps you need to follow. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 2000 | 2002 | 2003 | 2007

Quickly Deleting Cells Using a few quick keystrokes to activate the delete menu. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Removing Duplicate Cells If you have a list of data in a worksheet, you know how difficult it can be to get rid of duplicates. This tip presents a macro that makes paring down your data list easier than you thought possible. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

Fast Answers!

Helpful Links

Great Info!

RSS Feeds