JUMP TO Section Chevron icon It indicates an expandable section or menu, or sometimes previous / next navigation options.- How to add a strikethrough in Excel through the Font section
- How to add a strikethrough in Excel through a keyboard shortcut
- How to add a partial strikethrough in Excel
Redeem now - You can add a strikethrough in Excel by using the Font Settings button in the Font section of the Home ribbon.
- You can use the keyboard shortcut Ctrl + 5 to strikethrough Excel for Windows; on a Mac, press CMD + Shift + X.
- To add strikethrough to part of a cell, double-click the cell and select just the text you want to strike through.
The strikethrough is a classic formatting style that resembles crossed out text, so it stands to reason that you should be able to strike through text and numbers in Excel.
And you can, though that might not be immediately obvious because there's no strikethrough tool among the formatting options in the ribbon. Don't let that slow you down; here's how to strike through any text or numbers in Excel.
How to add a strikethrough in Excel through the Font section
This technique will strike through the entire contents of selected cells.
1. Click the cell (or range of cells) that you want to strikethrough.
2. Click the Home tab in the ribbon at the top of the screen.
3. In the Font section, click the Font Settings button, which is the small arrow at the bottom right of the section.
4. In the Format Cells dialog box, click the checkbox for Strikethrough and then click OK.
How to add a strikethrough in Excel through a keyboard shortcut
You can get the exact same effect — a strikethrough — using a keyboard shortcut rather than using the Font Settings in the ribbon.
Select the cell (or range of cells) you want to strikethrough and then press Ctrl + 5 for Windows or CMD + Shift + X on the Mac.
How to add a partial strikethrough in Excel
While you generally will probably want to strike through the entirety of a cell, there might be times when you want to selectively strike through just some of the text in a cell. That's easy to do — just select the text and then follow the same steps to strike it through.
1. Double-click a cell to enter edit mode for that cell.
2. Select the text you want to strike through.
3. On the Home tab of the ribbon, click the Font Setting button in and choose Strikethrough or use the keyboard shortcut (Ctrl + 5 or CMD + Shift + X).
Quick tip: You can remove a strikethrough in Excel by repeating the strikethrough command on the selected cell or text. If you apply a strikethrough by accident, you can also immediately choose Undo.
Dave Johnson Freelance Writer Dave Johnson is a technology journalist who writes about consumer tech and how the industry is transforming the speculative world of science fiction into modern-day real life. Dave grew up in New Jersey before entering the Air Force to operate satellites, teach space operations, and do space launch planning. He then spent eight years as a content lead on the Windows team at Microsoft. As a photographer, Dave has photographed wolves in their natural environment; he's also a scuba instructor and co-host of several podcasts. Dave is the author of more than two dozen books and has contributed to many sites and publications including CNET, Forbes, PC World, How To Geek, and Insider. Read more Read lessncG1vNJzZmivp6x7o8HSoqWeq6Oeu7S1w56pZ5ufonyowcidnKxnpJqwqXvHqK5mrJ9iwLW%2ByKScraCipMKotIyipWadqJiyrQ%3D%3D