

As one of the most popular spreadsheet programs in the world, Microsoft Excel offers a variety of formatting options to make your data more organized and visually appealing. One commonly used feature is the ability to strike through text. Strikethrough in Excel is a formatting tool used to cross out cells or text within a cell to denote changes or to show that the data is no longer relevant. In this blog post, we will cover all the steps necessary to apply strikethrough formatting to your Excel spreadsheet.
If you’re not familiar with the term, strikethrough is a text formatting option that allows you to add a line through cells or text within a cell. This is useful when you want to indicate that some data is no longer valid, or when you want to show that a change has been made to a particular cell.
Here’s how you can apply strikethrough formatting in Excel on a Windows computer:
Click and drag your mouse over the cells containing the text you want to cross out. If you want to apply strikethrough to just a portion of the text within a cell, double-click the cell to enter edit mode, highlight the text, right-click on it, and select “Format Cells.”
You can either right-click on the selected cells and choose “Format Cells” or go to the “Home” tab in the ribbon and click the small arrow button in the bottom right corner of the “Font” section.
In the “Format Cells” dialog box, click on the “Font” tab, and check the “Strikethrough” box.
Once you have selected the “Strikethrough” option, click the “OK” button to apply the formatting to your selected cells.
The process for applying strikethrough formatting in Excel on a Mac is similar, but with a few slight differences:
Click and drag your mouse over the cells containing the text you want to cross out. If you want to apply strikethrough to just a portion of the text within a cell, double-click the cell to enter edit mode, highlight the text, right-click on it, and select “Format Cells.”
Click on the “Home” tab in the ribbon, and choose the “Font” section in Excel menu at the top of the screen.
Click on the strikethrough icon to add a line through the text. You can also use the keyboard shortcut “Command + Shift + X.”
Now you know how to apply strikethrough formatting in Excel on both Windows and Mac. Whether you’re using it to indicate obsolete information or to highlight changes, strikethrough can be a valuable tool when working with data in Excel.
While strikethrough is a commonly used text formatting option, there are several other formatting options available in Excel that can help you make your data easier to read and understand. Some popular options include:
Using formatting options like these can help you to make your data more visually appealing, and easier to read and understand, in Excel.
Strikethrough formatting is useful in many ways when working with Excel spreadsheets. Here are some situations where you might want to use strikethrough:
Strikethrough is an easy and effective way to communicate changes and keep your spreadsheets organized and up to date.
Here are some frequently asked questions and answers regarding how to strike through text in Excel:
Yes, you can apply strikethrough to a specific part of the text within a cell. Double-click the cell to enter edit mode, highlight the text, right-click on it, and select “Format Cells.” Then, check the “Strikethrough” box under the “Font” tab.
The keyboard shortcut for strikethrough in Excel on Windows is “Control + 5.”
The keyboard shortcut for strikethrough in Excel on Mac is “Command + Shift + X.”
Yes, you can undo strikethrough in Excel by highlighting the cells that contain the strikethrough text, selecting the “Font” tab in the formatting options, and unchecking the “Strikethrough” box.
Yes, you can apply strikethrough to cells that contain formulas. The strikethrough formatting does not affect the formula inside the cell.
Explore the world of Microsoft PowerPoint with LearnPowerpoint.io, where we provide tailored tutorials and valuable tips to transform your presentation skills and clarify PowerPoint for enthusiasts and professionals alike.
Your ultimate guide to mastering Microsoft Word! Dive into our extensive collection of tutorials and tips designed to make Word simple and effective for users of all skill levels.
Boost your brand's online presence with Resultris Content Marketing Subscriptions. Enjoy high-quality, on-demand content marketing services to grow your business.