Text formatting comes in a variety of options. You’ve probably changed a font or font color before, which is an effective way to adjust the appearance of content.
These font options are available in Microsoft Excel as well, and there are even more styles that you can apply to some of the text in your cells.
Our tutorial below will show you how to strike through in Excel 2010 using an option that you can find on one of the dialog box windows within the application.
How to Draw a Line Through Text in Microsoft Excel
- Open your spreadsheet.
- Select the cell.
- Click the Home tab.
- Click the Format Cells: Font dialog box launcher.
- Check the Strikethrough box.
- Click OK.
Our guide continues below with additional information on how to strike through in Excel, including pictures of these steps.
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 strike through in Excel 2010.
Related Topic: The Google apps, like Docs, Sheets, and Slides, also have strikethrough options. Our how to remove strikethrough in Google Docs article shows you how to find and use it.
How to Strikethrough Text in Excel 2010 (Guide with Pictures)
Using the strikethrough feature described below will draw a horizontal line 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.
Step 3: Click the Home tab at the top of the window.
Step 4: Click the small Format Cells: Font button at the bottom-right corner of the Font section of the ribbon.
Step 5: Check the box to the left of Strikethrough, then click the OK button at the bottom of the window.
Note that you can also use the hotkey of Ctrl + 5 to strikethrough selected text.
Now that you know how to strike through in Excel, you will be able to use this helpful font style option whenever you have some text that would benefit from this.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.