Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel Online More. Less Formatting text or numbers can make them appear more visible especially when you have a large worksheet. How to Strikethrough in Excel 2003, Excel 2007, Excel 2010, Excel 2011 for Mac, Excel 2013 and Excel 2016 and shortcut key to strike out text in excel.
This Excel tutorial explains how to draw a line through a value (ie: strikethrough) in a cell in Excel 2016 (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: How do I draw a line through a value in a cell in Microsoft Excel 2016? (This is also known as a strikethrough.)
Answer: Select the text that you wish to strikethrough. This can either be the entire cell or only a character in the cell. In this example, we've selected cell A3.
While your mouse is over the selected text, right-click and then select 'Format Cells' from the popup menu.
When the Format Cells window appears, select the Font tab. Check the Strikethrough checkbox. Click on the OK button.
Spreadsheet For Mac
Now when you return to your spreadsheet, you should see a strike through your selected text.