Step 1: Select the Cell or Cells
The first step to do a strikethrough in Excel is to select the cell or cells that you want to apply the formatting to. You can do this by clicking on the cell or dragging your mouse over multiple cells.
Step 2: Open the Font Dialog Box
Next, you’ll need to open the font dialog box. You can do this by right-clicking on the selected cells and choosing “Format Cells” from the dropdown menu.
Step 3: Choose the Font Tab
Once the format cells dialog box is open, choose the “Font” tab. This tab will allow you to change the font, font style, size, and other formatting options.
Step 4: Check the Strikethrough Box
In the font tab, you should see an option for “Strikethrough”. Check the box next to this option to apply the formatting to the selected cells.
Step 5: Click OK to Apply the Formatting
Finally, click the “OK” button to apply the formatting to the selected cells. You should now see a strikethrough line through the text in the cells.
Frequently Asked Questions (FAQs)
How do I remove a strikethrough in Excel?
To remove a strikethrough in Excel, simply repeat the steps above, but uncheck the box next to “Strikethrough” in the font tab.
Can I apply strikethrough formatting to a specific part of a cell?
Yes! You can apply strikethrough formatting to only a specific part of a cell. To do this, highlight the text that you want to apply the formatting to and follow the same steps as above.
Can I use a keyboard shortcut to apply strikethrough formatting?
Yes! The keyboard shortcut for applying strikethrough formatting in Excel is “Ctrl + 5”.
Conclusion
Knowing how to do a strikethrough in Excel can be a useful skill for anyone who works with spreadsheets. By following these simple steps, you can easily cross out values or entries as needed. Remember, if you ever need to remove the strikethrough formatting, simply repeat the steps and uncheck the box next to “Strikethrough”.