Microsoft Excel has a lot of formatting options that let you do things like convert text to numbers in Excel. But you may be looking for the setting that allows you to draw a line through text. Fortunately, you can learn how to cross out in Excel with the help of a font style.
How to Draw a Line Through Text in Excel
- Open your spreadsheet.
- Select your cell(s).
- Choose the Home tab.
- Click the Font Options button.
- Check the Strikethrough box and click OK.
Our guide continues below with additional information on how to cross out in Excel, including pictures of these steps.
Sometimes you have some information in your spreadsheet that you don’t think you will need, but that you aren’t quite ready to remove.
This is the perfect situation to learn how to use crossed out text in Excel, otherwise known as “strikethrough.” This is a text formatting option, similar to bolding or italicizing text, but it looks like a font with line through it instead.
However, crossing out text has the added benefit of letting the reader know that the information should not be considered.
Our tutorial below will show you how to select a cell in a spreadsheet, then draw a line through all of the text in that cell. You can also choose to select multiple cells, or even the entire sheet. Either way, the result will be crossed out text in your cell(s).
How to Use the Cross Out Line in Excel 2013 (Guide with Pictures)
The steps in this article will show you how to get crossed out text in Excel 2013. If you would like to do the opposite, and remove the cross out effect from your data, then read this article.
Step 1: Open the spreadsheet containing the text that you want to cross out.
Step 2: Click on a cell containing data that you want to cross out.
Step 3: Click the Home tab at the top of the window, then click the Font Options dialog button at the bottom-right corner of the Font section in the ribbon.
Alternatively, you could right-click the selection, then click Format Cells, and select the Font tab.
Step 4: Check the box to the left of Strikethrough, then click the OK button.
Now that you have completed our guide on how to cross out in Excel, the text in the cells that you previously selected should now be crossed out with a line through it.
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.