Pinterest Pixel

How to Apply Strikethrough in Excel – 3 Easy Methods

Microsoft Excel is a powerful application with many formatting tools that can be used to enhance the... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

How to Apply Strikethrough in Excel - 3 Easy Methods | MyExcelOnline How to Apply Strikethrough in Excel - 3 Easy Methods | MyExcelOnline

Microsoft Excel is a powerful application with many formatting tools that can be used to enhance the clarity and coherence of data. One such formatting feature is the ability to apply strikethrough in Excel.

Strikethrough is a formatting technique that adds a horizontal line through the middle of the text. It can be used to indicate to users that the information has been revised, is not valid anymore, or has been completed. It helps users easily identify changes or updates in the spreadsheet while still showing the old information.

In this article, we will cover 3 different methods to apply strikethrough in Excel

Let’s look at each of these methods in detail.

 

Download the Excel Workbook below to follow along and understand how to Apply Strikethrough in Excel –

download excel workbookApply-Strikethrough-in-Excel.xlsx

 

Method 1 – Using Keyboard Shortcut

The quickest way to apply strikethrough in Excel is through a simple keyboard shortcut. You can easily apply strikethrough using the shortcutCtrl + 5. Once you press Ctrl + 5, the formatting will automatically be applied to the entire contents of the cell.

See also  Worksheet Tabs not Visible

Strikethrough in Excel

You can also select a single cell, a range of cells, or even an entire column or row and follow the same step to apply strikethrough. In some cases, you may want to strike out only a part of the text within the cell. This can also be achieved by following the steps below –

STEP 1: Double-click the cell to enter the edit mode.

Strikethrough in Excel

STEP 2: Highlight the part of the text that you want to strike out.

Strikethrough in Excel

STEP 3: Press Ctrl + 5.

Strikethrough in Excel

The selected text will be strikethrough.

Strikethrough in Excel

What if you wish to remove this formatting? Choose the text where you wish to remove the strikethrough, and then use the keyboard shortcut Ctrl + 5.

Strikethrough in Excel

 

Method 2 – Using Format Cell Option

This method provides more control over formatting options. Follow the steps below to apply strikethrough using the format cell option –

STEP 1: Select the cell where you want to strikethrough.

See also  The Ultimate Guide to Excel Strikethrough Text

Strikethrough in Excel

STEP 2: Go to the Home tab and within the font section, click on the Font setting button. This is the small arrow at the bottom right corner of the section.

Strikethrough in Excel

STEP 3: In the Format Cells dialog, go to the Font tab.

Strikethrough in Excel

STEP 4: Check the Strikethrough option in the Effects section and click OK to apply the formatting.

Strikethrough in Excel

The strikethrough formatting will be applied to the selected cell.

Strikethrough in Excel

 

Method 3 – Using Quick Access Toolbar

The Quick Access Toolbar in Excel is a customizable toolbar located at the top of the Excel window, near the Ribbon. It provides users with a convenient and quick way to access frequently used commands and features, regardless of the active tab in the Ribbon.

Strikethrough in Excel

If you frequently use strikethrough in Excel, you can add it to the Quick Access Toolbar for easy access. Follow these steps below to use QAT to apply strikethrough formatting –

See also  The Ultimate Guide on Yes No Dropdown for Excel

STEP 1: Click on the small arrow next to the Quick Access Toolbar and select More Commands.

Strikethrough in Excel

STEP 2: In the Excel Options dialog box, select Commands Not in the Ribbon from the Choose commands from dropdown.

Strikethrough in Excel

STEP 3: Select Strikethrough from the list on the left and then click Add.

Strikethrough in Excel

STEP 4: Click OK to close the dialog box.

Strikethrough in Excel

Now, you can simply click on the newly added strikethrough icon in the Quick Access Toolbar to apply the formatting.

Strikethrough in Excel

 

Conclusion

In conclusion, Strikethrough in Excel helps users improve data presentation and communication. Its ability to signify changes or completion is a valuable tool for users managing spreadsheets. You can either employ the convenient keyboard shortcut, utilize the Format Cells option, or incorporate the Quick Access Toolbar for seamless access.

These three methods offer flexibility and efficiency in applying strikethrough formatting in Excel. Choose the method that best fits your workflow and make your data more visually impactful and communicative.

If you like this Excel tip, please share it
How to Apply Strikethrough in Excel - 3 Easy Methods | MyExcelOnline How to Apply Strikethrough in Excel - 3 Easy Methods | MyExcelOnline
See also  Unlocking the Power of AutoRestore in Excel: A Comprehensive Guide
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...