#How to strikethrough excel 2010 how to#

Open the dialogbox Define Name (Ctrl+F3).Clear method.You can use the old Excel4 macro function: GET.CELL It should be noted that if you don't want the macro to actually delete rows, but would prefer to just clear them, you can replace the. If bCheck is still False (meaning that there is no mixed use of strike-through in the cell), then the entire cell is checked to see if it has the requisite formatting. This is checked by IsNull and assigned to the bCheck variable. If only some of the characters in the cell use strike-through, then a null value is returned by the Strikethrough property. This is the part that detects if the cell contains mixed formatting. Note in the middle of the macro that the IsNull function is used. (The macro won't work if your selection contains only 1 or 2 rows-that few of rows is easy enough to check and adjust manually.) If the cell contains struck-through text, then a flag (bCheck) is set and the entire row is deleted.

The macro steps through each row of the selection (from the last row to the first) and then checks each cell within those rows. To use the macro, simply select the cells you want to affect, and then run it. If bCheck Then Selection.Rows(J).EntireRow.Delete If Not bCheck Then bCheck = c.Font.Strikethrough

Plus, a macro is a good approach if you need to perform this task quite often. This deficiency can be overcome by using a macro. In other words, if only some of the text within the cell uses the strikethrough attribute, then that cell won't be found in step 8. There is a drawback to this approach-it won't find any cells containing mixed formatting. (Don't click anywhere else in the worksheet or you'll inadvertently unselect the cells.) All the cells containing strikethrough text should now be selected.

Click Close to dismiss the Find Format dialog box.

This selects all the results in the dialog box. The Find and Replace dialog box expands to show which cells contain strikethrough formatting, and the first result (in the dialog box) is selected.

Click OK to dismiss the Find Format dialog box.

(You shouldn't need to change anything else in the dialog box.)

Click the Strikethrough check box a time or two until you see it is selected.

(It will probably be displayed by default.) Excel displays the Find Format dialog box.

Make sure the Find What box is empty and place the insertion point within that box.

Click the Options button to expand what is available in the dialog box.

Excel displays the Find tab of the Find and Replace dialog box. If it is not that easy to see all the rows containing struck-through text, you can rely on the Find feature to locate them for you: (You are building a selection set of rows to delete.)

Hold down the Ctrl key as you click at the left side of any additional rows you want to delete.

Click at the left side of the first row you want to select-the first one containing struck-through text.

If you only need to do this task once in a while, the following steps will help you out if it is easy to see which cells contain the strike-through formatting:

#How to strikethrough excel 2010 how to#

Rows that contain struck-through text need to be deleted, but Tara isn't sure of how to quickly go about this. Tara often receives workbooks containing a single worksheet where some information in the worksheet contains text that is 'struck through' (the text is formatted using strikethrough).