Get Access to World’s largest Template Library & Tools

How to Draw a Line Through Text in Microsoft Excel

Microsoft Excel allows you to draw a line through text, a feature that can be very useful for indicating completed tasks or invalid data. Whether you’re managing business data or updating a school project, learning to apply strikethrough in Excel is a simple yet effective way to enhance your spreadsheets.

How to Draw a Line Through Text in Microsoft Excel

 

In Microsoft Excel, striking through text is an effective way to mark items as completed or to indicate that data should be disregarded. Follow these steps to learn how to apply strikethrough formatting quickly and effectively:

  • Step 1. Select the Cell or Range

    Start by selecting the cell or range of cells where you want to apply the strikethrough. Click on the cell to focus on a single entry or drag across multiple cells if you wish to apply the formatting to a broader area.

  • Step 2. Open the ‘Format Cells’ Dialog

    step 2 open the format cells dialog

    With your cells selected, right-click and choose “Format Cells” from the context menu. Alternatively, you can press “Ctrl + 1” on your keyboard to open the “Format Cells” dialog box directly.

  • Step 3. Apply Strikethrough Formatting

    step 3 apply strikethrough formatting

    In the “Format Cells” dialog, click the “Font” tab to view font formatting options. Under the “Effects” section, you will find the “Strikethrough” checkbox. Click this checkbox to enable strikethrough formatting.

  • Step 4. Confirm the Formatting

    After selecting the “Strikethrough” checkbox, click “OK” at the bottom of the “Format Cells” dialog to apply the formatting. Your selected text will now be crossed out, indicating that it has been marked accordingly.

  • Step 5. Review and Adjust if Necessary

    Take a moment to review the cells to ensure the strikethrough has been applied as intended. If you need to adjust or remove the strikethrough, you can easily return to the “Format Cells” dialog and modify your settings by following the same steps.

You may also find valuable insights in the following articles offering tips for Microsoft Excel:

note iconNote

Unlock Your Productivity with Over 100,000 Microsoft Excel Templates! Exclusively Available at Template.net – Download Now and Transform Your Data Handling Experience!

FAQs

How do I quickly apply strikethrough to text in Excel?

You can quickly apply strikethrough by selecting your text and pressing “Ctrl + 5” on your keyboard.

Can I apply strikethrough formatting to multiple cells at once in Excel?

Yes, you can select multiple cells and apply strikethrough formatting to all of them simultaneously.

Is there a shortcut to remove strikethrough formatting in Excel?

To remove strikethrough, reselect the text and either press “Ctrl + 5” again or deselect strikethrough in the “Format Cells” dialog.

Does strikethrough formatting affect the data in the cell for calculations?

No, strikethrough is purely visual and does not impact the underlying data or its involvement in calculations.

Can I use strikethrough in conditional formatting rules in Excel?

Yes, you can set up conditional formatting to automatically apply strikethrough based on specific criteria or cell values.

More in Excel

How to Import a File Into Microsoft ExcelHow to Email a Microsoft Excel Sheet
How to Create Labels in Word From Microsoft ExcelHow to Auto-Adjust Row Height in Microsoft Excel
How to Combine Tabs in Microsoft ExcelHow to Wrap Text in a Microsoft Excel Cell
How to Autofill the Date in Microsoft ExcelHow to Fix a Circular Reference in Microsoft Excel
How to Add a Label to an Axis in Microsoft ExcelHow to Select a Row in Microsoft Excel
How to Lock Cells in Microsoft Excel for ScrollingHow to Get Microsoft Excel to Round Up
How to Start a New Paragraph in Microsoft ExcelHow to Insert Check Boxes in Microsoft Excel
How to Change Horizontal Axis Values in Microsoft ExcelHow to Enable the Developer Tab in Microsoft Excel
How to Copy a Row in Microsoft ExcelHow to Delete Extra Pages in Microsoft Excel
How to Change a CSV File to Microsoft ExcelHow to Share and Edit Microsoft Excel Files
How to Find a P-Value in Microsoft ExcelHow to Compare Two Microsoft Excel Sheets for Duplicates
How to Delete a Chart in Microsoft ExcelHow to Put Dates in Order on Microsoft Excel
How to Freeze Both Rows and Columns in Microsoft ExcelHow to Recover a Corrupted Microsoft Excel File
How to Save a Microsoft Excel File as a CSVHow to Unprotect a Microsoft Excel Spreadsheet
How to Add Rows in Microsoft Excel Using a ShortcutHow to Do a Count in Microsoft Excel
How to Find the Sum of a Column in Microsoft ExcelHow to Make a Note in Microsoft Excel
How to Find the Slope on a Microsoft Excel GraphHow to Remove #DIV/0 in Microsoft Excel
How to Insert Symbols in Microsoft ExcelHow to Budget With Microsoft Excel
How to Reorder Rows in Microsoft ExcelHow to Calculate the Total in Microsoft Excel
How to Search a Microsoft Excel DocumentHow to Autofit Cells in Microsoft Excel
How to Get the Total in Microsoft ExcelHow to Get Rid of Dashed Lines in Excel
How to Find the P-Value in Microsoft ExcelHow to Sort by Alphabetical Order in Microsoft Excel
How to Make Sequential Numbers in Microsoft ExcelHow to Add Boxes in Microsoft Excel
How to Graph Using Microsoft ExcelHow to Change the Default Font in Microsoft Excel
How to Add Today's Date in Microsoft ExcelHow to Move Rows Up in Microsoft Excel
How to Delete a Tab in Microsoft ExcelHow to Freeze the First Two Rows in Microsoft Excel
How to Separate Words in Excel Using a FormulaHow to Rename a Microsoft Excel File
How to Budget on Microsoft ExcelHow to Budget in Microsoft Excel
How to Fix a Row in Microsoft ExcelHow to Extract Data From PDF to Microsoft Excel
How to Create Column Headers in Microsoft ExcelHow to Filter by Date in Microsoft Excel
How to Make a Grid in Microsoft ExcelHow to Total Columns in Microsoft Excel
How to Create a Rule in Microsoft ExcelHow to Fill Every Other Row in Microsoft Excel
How to Convert Currency in Microsoft ExcelHow to Do a Subtraction Formula in Microsoft Excel
How to Embed a Document in Microsoft ExcelHow to Delete Infinite Columns in Microsoft Excel
How to Insert an Arrow in Microsoft ExcelHow to Sign in in Microsoft Excel
How to Expand Rows in Microsoft ExcelHow to Enter in an Excel Cell
How to Anchor Cells in Microsoft ExcelHow to Plot a Graph in Microsoft Excel
How To Multiply 2 Cells in Microsoft ExcelHow to Make Microsoft Excel Files Smaller
How to Update Microsoft Excel on MacHow to Add a Second Vertical Axis in Microsoft Excel
How to Get a Percentage in Microsoft ExcelHow to Embed a Microsoft Excel File in Word
How to Make a Flowchart in Microsoft ExcelHow to Hide Sheets in Microsoft Excel
How to Show the Formula Bar in Microsoft ExcelHow to Delete Excess Columns in Microsoft Excel
How to Use VLOOKUP in Excel with Two SheetsHow to Unfreeze in Microsoft Excel
How to Press Enter in Excel and Stay in the Same CellHow to Remove Letters from a Cell in Microsoft Excel
How To Apply the Accounting Number Format in ExcelHow to Keep a Row Fixed in Microsoft Excel
How to Goal Seek in Microsoft ExcelHow to Insert a Comment in Microsoft Excel
How to Find Merged Cells in Microsoft ExcelHow to Unshare a Microsoft Excel File
How to Export a PDF to Microsoft ExcelHow to Calculate Z-Score in Microsoft Excel
How to Remove Comments in Microsoft ExcelHow to Do Covariance in Microsoft Excel
How to Use a Data Table in Microsoft ExcelHow to Use the Rank Function in Microsoft Excel
bottom banner