How to Use Strikethrough in Excel 2010

The Microsoft Word and Outlook strikethrough process is useful for a number of reasons in documents where you do a lot of writing, but it doesn’t come up often for a lot of spreadsheet users.

Occasionally you will have data in an Excel spreadsheet that you aren’t sure that you want to keep, but you want to make sure that you are not evaluating it when reading the rest of the data. One good way to do this is to simply hide the row or column that contains that data, but that will make it so that the data is not visible at all, which makes it easy to forget.

So another option is to strikethrough the data. This will draw a line through the data in the selected cells, which can signify that it should be deleted or ignored, but keeps it visible in case you need to refer to it later. So continue reading below to find out how to use strikethrough in Excel 2010.

How to Strikethrough Text in Excel 2010

Using the strikethrough feature described below will draw a horizontal like through all of your selected text. For the purpose of this example, we will be selecting a group of cells, and the method below will strikethrough all of the text in those selected cells.

To remove strikethrough text in Excel, simply follow the steps below, and click the same box to remove the checkmark.

Step 1: Open your spreadsheet in Excel 2010.

Step 2: Use your mouse to select the cells containing the text that you want to strikethrough.

select the cells to strikethrough

Step 3: Click the Home tab at the top of the window.

click the Home tab

Step 4: Click the small Format Cells: Font button at the bottom-right corner of the Font section of the ribbon.

click the format cells: font button

Step 5: Check the box to the left of Strikethrough, then click the OK button at the bottom of the window.

how to strikethrough text in excel 2010

Note that you can also use the hotkey of Ctrl + 5 to strikethrough selected text.

Do you have an Excel file with a lot of formatting that you do not want? Learn how to clear all of the formatting from a selection and start with a clean slate.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides