Saturday, July 30, 2016

Draw a line through a value in a cell

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.
Microsoft Excel
While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu.
Microsoft Excel
When the Format Cells window appears, select the Font tab. Check the Strikethrough checkbox. Click on the OK button.
Microsoft Excel
Now when you return to your spreadsheet, you should see a strike through your selected text.
Microsoft Excel

No comments:

Post a Comment