Home » How To » How to Strikethrough in Excel {2 Ways}

How to Strikethrough in Excel {2 Ways}

Have you ever wondered how to strikethrough in Excel? Whether you’re tracking changes or marking completed tasks, the ability to apply a strikethrough to cell contents is really useful. The problem is, unlike the bold and underline options, you will not find the strikethrough option in the Excel ribbon. However, you can do it quite easily using a keyboard shortcut or by adding the strikethrough option to the ribbon in Excel.

In this quick and easy Excel tutorial, I will show you these two methods to strikethrough cells in Excel. Let’s get started.

Keyboard shortcut to strikethrough in Excel

The keyboard shortcut to strikethrough in Excel is Ctrl + 5. To cross out a single cell, select the cell and then press the Ctrl + 5 shortcut. It will strikethrough the cell in Excel.

press CTRL + 5 to strikethrough a cell in excel

To strikethrough multiple cells at the same time, hold down the Ctrl key on your keyboard and select the cell using your mouse pointer. After that, press the Ctrl + 5 keyboard shortcut.

select multiple cells and press CTRL + 5 to strikethrough

To strikethrough a part of a cell, double-click on the cell and select the word or part you want to strikethrough. Next, press the Ctrl + 5 keyboard shortcut.

select part of a cell and press CTRL + 5 to strikethrough

Add strikethrough option to Excel ribbon

As an alternative, you can add the strikethrough option to the ribbon. Once added, click on the strikethrough button will cross out the selected cell(s) in Excel. Here’s how to do it.

Step 1: Open the Excel application.

Step 2: Click on the down arrow icon on the Excel title bar and select More Commands.

select more commands

Step 3: Select Customize Ribbon on the sidebar. Under the Main Tabs section (right list), select the Home group and click on the New Group button.

create new group in customize ribbon tab

Step 4: Select the New Group (Custom) option and click on Rename.

Step 5: Set a name of your choice in the Display Name field and click on Ok.

Note: You can also choose an icon if you want.

click rename to change the name of the newly create group

Step 6: Choose the ‘Commands not in the Ribbon‘ option from the ‘Choose commands from‘ dropdown.

select commands not in ribbon option

Step 7: Ensure the newly created group is selected, scroll down the left list, and select the Strikethrough option

Step 8: Press the Add button to add the option to the custom group.

add strikethrough option to ribbon in excel

Step 9: Press the OK button to save changes.

strikethrough option added to excel ribbon

Step 10: The strikethrough option is added to the ribbon in Excel.

excel strikethrough ribbon option

From now on, you can click on the strikethrough option to cross out one or more cells in Excel.

I hope this small tutorial showed you simple ways to strikethrough in Excel.

If you are stuck or need help, send an email, and I will try to help as much as possible.

More Excel tutorials:

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top