{"id":47768,"date":"2024-06-16T12:00:53","date_gmt":"2024-06-16T10:00:53","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=47768"},"modified":"2024-06-12T20:24:51","modified_gmt":"2024-06-12T18:24:51","slug":"excel-strikethrough","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-strikethrough\/","title":{"rendered":"The Ultimate Guide to Excel Strikethrough Text"},"content":{"rendered":"<p>Excel Strikethrough is a formatting feature that allows you to draw a line through text or numbers within a cell. This is particularly useful for indicating that certain tasks are completed or that specific data entries are no longer relevant. Strikethrough helps maintain a record of past information without deleting it, making it easier to track changes and updates within your spreadsheets. In this article, we will cover different ways to apply strikethrough in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a>.<\/p>\n<p><strong>Key Takeaways:<\/strong><\/p>\n<ul>\n<li>Purpose and Utility: Strikethrough helps in visually marking completed or irrelevant items without removing them from the spreadsheet, aiding in better data management and historical tracking.<\/li>\n<li>Keyboard Shortcuts: Apply Strikethrough quickly using keyboard shortcuts \u2013 Ctrl + 5 on Windows and Command + Shift + X on Mac \u2013 for efficient editing.<\/li>\n<li>Ribbon Customization: Customize your Excel Ribbon to include a Strikethrough button for easy access, allowing you to apply this formatting with a single click.<\/li>\n<li>Conditional Formatting: Use conditional formatting to automate Strikethrough based on specific criteria, saving time and ensuring consistency in your data presentation.<\/li>\n<li>Partial Strikethrough and Removal: Strikethrough can be applied to partial text within a cell for detailed editing, and it can be removed without affecting the underlying data, preserving data integrity.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-strikethrough\/#Striking_Out_A_Quick_Overview\" title=\"Striking Out: A Quick Overview\">Striking Out: A Quick Overview<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-strikethrough\/#The_Strikethrough_Toolkit\" title=\"The Strikethrough Toolkit\">The Strikethrough Toolkit<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-strikethrough\/#Manual_versus_Automatic_Applying_Strikethrough\" title=\"Manual versus Automatic: Applying Strikethrough\">Manual versus Automatic: Applying Strikethrough<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-strikethrough\/#Special_Cases_and_Tips\" title=\"Special Cases and Tips\">Special Cases and Tips<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-strikethrough\/#Removing_Strikethrough_Without_Losing_Data_Integrity\" title=\"Removing Strikethrough Without Losing Data Integrity\">Removing Strikethrough Without Losing Data Integrity<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-strikethrough\/#Frequently_Asked_Questions\" title=\"Frequently Asked Questions\">Frequently Asked Questions<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Striking_Out_A_Quick_Overview\"><\/span>Striking Out: A Quick Overview<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>What Is Excel Strikethrough?<\/h3>\n<p>Excel Strikethrough is like your virtual highlighter but instead of making things stand out, it helps you indicate the completion or irrelevance of tasks and items directly onto your data sheet. Imagine having a to-do list and drawing a line through each item you&#8217;ve completed \u2013 that&#8217;s exactly what the Strikethrough feature does to your text or numbers in Excel cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T093A453A10.282284_Master_Excel_Strikethrough_Text_in_Seconds-_1.png\" alt=\"Excel Strikethrough\" width=\"472\" height=\"218\" \/><\/p>\n<h3>Significance of Using Strikethrough in Spreadsheets<\/h3>\n<p>In the realm of spreadsheets, where each cell&#8217;s content carries meaning, Strikethrough plays a vital role. It&#8217;s a visual indicator to quickly communicate the status of tasks, financial entries, or any point of data without removing historical entries.<\/p>\n<p>For instance, in budget tracking, a Strikethrough lets you see both original estimates and alterations at a glance. It&#8217;s an excellent way to maintain a clean yet informative spreadsheet, as it fosters a non-destructive editing environment where nothing gets lost in the shuffle.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"The_Strikethrough_Toolkit\"><\/span>The Strikethrough Toolkit<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Method 1: Keyboard Shortcuts for Speedy Editing<\/h3>\n<p>If you&#8217;re all about efficiency and speed, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/333-excel-keyboard-shortcuts\/\" target=\"_blank\" rel=\"noopener\">keyboard shortcuts<\/a> are your best friend in Excel. To swiftly apply the Strikethrough format to your data, simply select your desired text, cell, or cell range and press Ctrl + 5 on <strong>Windows<\/strong>.<\/p>\n<p><strong>Mac users, <\/strong>on the other hand, should use the Command + Shift + X combo. Voil\u00e0! The selected data now appears crossed out. And guess what? If you change your mind or hit the shortcut by mistake, just press the same keys again to undo the Strikethrough.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select the cell you want to strikethrough.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T093A493A41.223577_Master_Excel_Strikethrough_Text_in_Seconds-_2.png\" alt=\"Excel Strikethrough\" width=\"632\" height=\"317\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Now, hold &#8216;<strong>CTRL+5<\/strong>&#8216;. You will then see a strikethrough in the selected cell &#8216;<strong>A2<\/strong>&#8216;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T093A533A27.417720_Master_Excel_Strikethrough_Text_in_Seconds-_3.png\" alt=\"Excel Strikethrough\" width=\"636\" height=\"438\" \/><\/p>\n<p>It&#8217;s that easy \u2013 no menus, no extra clicks.<\/p>\n<h3>Method 2: Ribbon Customization for Easy Access<\/h3>\n<p>For those who prefer mouse clicks over keyboard shortcuts, customizing your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-f1-hide-unhide-the-ribbon\/\" target=\"_blank\" rel=\"noopener\">Excel Ribbon<\/a> is a lifesaver. By adding a Strikethrough button to the Ribbon, you can mark items as complete with a single click, any time you need. Let&#8217;s walk through the simple process:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Right-click anywhere on the Ribbon and choose &#8216;Customize the Ribbon&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A033A40.126266_Master_Excel_Strikethrough_Text_in_Seconds-_4.png\" alt=\"Excel Strikethrough\" width=\"841\" height=\"419\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Choose the &#8216;Home&#8217; tab and click &#8216;New Group&#8217; to create a custom group for your button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A033A49.296378_Master_Excel_Strikethrough_Text_in_Seconds-_5.png\" alt=\"Excel Strikethrough\" width=\"1585\" height=\"913\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>Name your group something like &#8216;My Formats&#8217; for easy recognition.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A043A05.178272_Master_Excel_Strikethrough_Text_in_Seconds-_gIF_6.gif\" alt=\"Excel Strikethrough\" width=\"1040\" height=\"862\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>With your new group selected, choose &#8216;Commands Not in the Ribbon&#8217; from the drop-down menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A043A18.595059_Master_Excel_Strikethrough_Text_in_Seconds-_7.png\" alt=\"Excel Strikethrough\" width=\"1025\" height=\"841\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span> <\/strong>Scroll to find &#8216;Strikethrough,&#8217; select it, and click &#8216;Add.&#8217;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A043A34.658793_Master_Excel_Strikethrough_Text_in_Seconds-_8.png\" alt=\"Excel Strikethrough\" width=\"1031\" height=\"839\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6: <\/strong><\/span>Hit &#8216;OK&#8217; to save your changes, and presto! Your Strikethrough button is ready for action on the Ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A043A44.693218_Master_Excel_Strikethrough_Text_in_Seconds-_9.png\" alt=\"Excel Strikethrough\" width=\"1027\" height=\"838\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">RESULT:<\/span> <\/strong>Now, anytime your spreadsheets need a little tidying, your trusty Strikethrough tool is just a click away.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A043A55.999811_Master_Excel_Strikethrough_Text_in_Seconds-_GIF_10.gif\" alt=\"Excel Strikethrough\" width=\"1920\" height=\"516\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Manual_versus_Automatic_Applying_Strikethrough\"><\/span>Manual versus Automatic: Applying Strikethrough<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Step-by-Step for Manual Application<\/h3>\n<p>Applying Strikethrough to your text manually in Excel may seem like a task, but with these easy steps, you&#8217;ll be crossing off items in no time:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Start by selecting the cell or range where you want to apply Strikethrough.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A323A37.487079_Master_Excel_Strikethrough_Text_in_Seconds-_11.png\" alt=\"Excel Strikethrough\" width=\"565\" height=\"216\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Right-click the selection and select &#8216;Format Cells&#8217; from the context menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A323A46.130072_Master_Excel_Strikethrough_Text_in_Seconds-_12.png\" alt=\"Excel Strikethrough\" width=\"862\" height=\"710\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>In the &#8216;Format Cells&#8217; dialog box, go to the &#8216;Font&#8217; tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A333A09.972675_Master_Excel_Strikethrough_Text_in_Seconds-_13.png\" alt=\"Excel Strikethrough\" width=\"1267\" height=\"726\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>Look for the Strikethrough checkbox and click on it to mark it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A333A26.413085_Master_Excel_Strikethrough_Text_in_Seconds-_14.png\" alt=\"Excel Strikethrough\" width=\"714\" height=\"681\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5: <\/strong><\/span>Finish by clicking &#8216;OK,&#8217; and you will see the Strikethrough effect applied to your selection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A353A21.759513_Master_Excel_Strikethrough_Text_in_Seconds-_15.png\" alt=\"Excel Strikethrough\" width=\"702\" height=\"648\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>RESULT: <\/strong><\/span>This manual method gives you the control to apply this format to specific items, maintaining a versatile and organized sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A353A42.485819_Master_Excel_Strikethrough_Text_in_Seconds-_16.png\" alt=\"Excel Strikethrough\" width=\"567\" height=\"216\" \/><\/p>\n<h3>Automatic Strikethrough with Conditional Formatting<\/h3>\n<p>Harness the power of Excel&#8217;s <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/conditional-formatting\/\" target=\"_blank\" rel=\"noopener\">conditional formatting<\/a> to apply a Strikethrough automatically based on certain conditions \u2013 it&#8217;s like setting your spreadsheet on autopilot. Follow these steps to create your own rule:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>First, select the range of cells you wish to apply automatic Strikethrough to.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A533A08.987399_Master_Excel_Strikethrough_Text_in_Seconds-_17.png\" alt=\"Excel Strikethrough\" width=\"392\" height=\"205\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Head over to the &#8216;Home&#8217; tab and locate &#8216;Conditional Formatting&#8217; in the &#8216;Styles&#8217; group. Click it and select &#8216;New Rule.&#8217;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A543A16.863211_Master_Excel_Strikethrough_Text_in_Seconds-_18.png\" alt=\"Excel Strikethrough\" width=\"1191\" height=\"556\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>In the &#8216;New Formatting Rule&#8217; dialog, choose &#8216;Use a formula to determine which cells to format.&#8217;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A563A14.507340_Master_Excel_Strikethrough_Text_in_Seconds-_19.png\" alt=\"Excel Strikethrough\" width=\"520\" height=\"527\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>Enter the condition formula in the box that reads &#8220;Format values where this formula is true.&#8221; For example, typing <code>=B3=\"Completed\"<\/code> will apply Strikethrough to any cell in your selected range that contains the word &#8220;done.&#8221; After setting the formula, click &#8216;Format&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T103A593A07.032416_Master_Excel_Strikethrough_Text_in_Seconds-_20.png\" alt=\"Excel Strikethrough\" width=\"520\" height=\"527\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5: <\/strong><\/span>Now move to the &#8216;Font&#8217; tab, and choose &#8216;Strikethrough.&#8217; Confirm all your actions with &#8216;OK,&#8217; and watch as cells automatically get struck through when they meet the conditions you specified.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A003A04.113213_Master_Excel_Strikethrough_Text_in_Seconds-_21.png\" alt=\"Excel Strikethrough\" width=\"699\" height=\"708\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6:<\/span> <\/strong>Now you can preview the strikethrough formatting selected by you, then click &#8220;OK&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A013A33.028744_Master_Excel_Strikethrough_Text_in_Seconds-_22.png\" alt=\"Excel Strikethrough\" width=\"510\" height=\"515\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">RESULT:<\/span> <\/strong>Automatic Strikethrough ensures your spreadsheet remains up-to-date with minimal manual intervention, saving you time for more important tasks.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A023A20.311240_Master_Excel_Strikethrough_Text_in_Seconds-_23.png\" alt=\"Excel Strikethrough\" width=\"393\" height=\"224\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Special_Cases_and_Tips\"><\/span>Special Cases and Tips<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Handling Partial Strikethroughs in a Cell<\/h3>\n<p>Sometimes, you might want to apply a Strikethrough to just a fragment of the text in a cell, rather than the entire cell content. This precision editing can be done through a few additional steps:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Double-click the cell to enable editing mode or press F2 after selecting the cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A043A49.191543_Master_Excel_Strikethrough_Text_in_Seconds-_24.png\" alt=\"Excel Strikethrough\" width=\"635\" height=\"317\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Highlight only the portion of text you want to strike through by dragging your mouse over it or using the Shift + arrow keys.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A063A27.351400_Master_Excel_Strikethrough_Text_in_Seconds-_25.png\" alt=\"Excel Strikethrough\" width=\"634\" height=\"268\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>With the text selected, either right-click and choose &#8216;Format Cells&#8217; or use the familiar shortcut; &#8216;Ctrl + 1&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A073A43.338344_Master_Excel_Strikethrough_Text_in_Seconds-_26.png\" alt=\"Excel Strikethrough\" width=\"552\" height=\"408\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>In the &#8216;Format Cells&#8217; dialog box, tick the &#8216;Strikethrough&#8217; checkbox under the &#8216;Font&#8217; tab &amp; Click &#8216;OK&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A083A45.457905_Master_Excel_Strikethrough_Text_in_Seconds-_27.png\" alt=\"Excel Strikethrough\" width=\"1163\" height=\"615\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">RESULT:<\/span> <\/strong>You will see that only the selected part of the text has the Strikethrough effect.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A103A08.030026_Master_Excel_Strikethrough_Text_in_Seconds-_28.png\" alt=\"Excel Strikethrough\" width=\"477\" height=\"215\" \/><\/p>\n<p>This little trick lets you bring attention to specific parts of your data while keeping the rest untouched and clearly visible.<\/p>\n<h3>Gaining Efficiency with Format Painter<\/h3>\n<p>To replicate Strikethrough formatting across different parts of your spreadsheet with finesse, the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-painter-multiple-cells\/\" target=\"_blank\" rel=\"noopener\">Format Painter tool<\/a> is your go-to feature. Here&#8217;s how to use it:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Select the cell that has the Strikethrough format you want to copy.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A143A43.759157_Master_Excel_Strikethrough_Text_in_Seconds-_29.png\" alt=\"Excel Strikethrough\" width=\"556\" height=\"271\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Click the &#8216;Format Painter&#8217; icon in the &#8216;Home&#8217; tab (it looks like a paintbrush).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A143A54.388221_Master_Excel_Strikethrough_Text_in_Seconds-_30.png\" alt=\"Excel Strikethrough\" width=\"406\" height=\"376\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>Then, simply select the cells where you&#8217;d like to apply the same formatting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A163A26.174670_Master_Excel_Strikethrough_Text_in_Seconds-_GIF_31.gif\" alt=\"Excel Strikethrough\" width=\"636\" height=\"468\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Removing_Strikethrough_Without_Losing_Data_Integrity\"><\/span>Removing Strikethrough Without Losing Data Integrity<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Purging Strikethrough formatting from your Excel cells without disturbing the actual data is straightforward. If your data&#8217;s integrity is key, follow these simple steps:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Click on the cell or select the range where you want to remove Strikethrough.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A203A18.462769_Master_Excel_Strikethrough_Text_in_Seconds-_32.png\" alt=\"Excel Strikethrough\" width=\"475\" height=\"217\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Press Ctrl + 1 to open the &#8216;Format Cells&#8217; dialog box, or right-click and choose &#8216;Format Cells&#8217; from the context menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A203A54.709455_Master_Excel_Strikethrough_Text_in_Seconds-_33.png\" alt=\"Excel Strikethrough\" width=\"799\" height=\"808\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>Under the &#8216;Font&#8217; tab, you&#8217;ll find the Strikethrough option. Uncheck the box next to &#8216;Strikethrough.&#8217; Hit &#8216;OK&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A223A45.956853_Master_Excel_Strikethrough_Text_in_Seconds-_34.png\" alt=\"Excel Strikethrough\" width=\"1177\" height=\"676\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>RESULT:<\/strong> <\/span>And just like that, the Strikethrough is gone, leaving your data untouched and readable.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A243A28.136611_Master_Excel_Strikethrough_Text_in_Seconds-_35.png\" alt=\"Excel Strikethrough\" width=\"478\" height=\"187\" \/><\/p>\n<p><strong>For those using conditional formatting<\/strong>,<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Navigate to the &#8216;Home&#8217; tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A343A47.306218_Master_Excel_Strikethrough_Text_in_Seconds-_36.png\" alt=\"Excel Strikethrough\" width=\"521\" height=\"203\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Choose &#8216;Conditional Formatting,&#8217; then &#8216;Manage Rules.&#8217;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A353A04.338596_Master_Excel_Strikethrough_Text_in_Seconds-_37.png\" alt=\"Excel Strikethrough\" width=\"393\" height=\"268\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Delete the rule associated with Strikethrough.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A383A54.960656_Master_Excel_Strikethrough_Text_in_Seconds-_38.png\" alt=\"Excel Strikethrough\" width=\"849\" height=\"401\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>RESULT: <\/strong><\/span>By unwinding the format carefully, you maintain the sanctity of your data, ensuring its accuracy and reliability for any future analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Excel Strikethrough\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia651090442024-06-10T113A393A04.801186_Master_Excel_Strikethrough_Text_in_Seconds-_39.png\" alt=\"Excel Strikethrough\" width=\"392\" height=\"205\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span>Frequently Asked Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>How to do strikethrough text in Excel?<\/h3>\n<p>To do <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/where-is-the-font-strikethrough-option-e6df3b9d-cea6-4406-9271-5a5a52d66738\" target=\"_blank\" rel=\"nofollow noopener\">strikethrough text in Excel<\/a>, select the cells you want to format and then use either the keyboard shortcut Ctrl + 5 or go to the Home tab, find the &#8216;Font&#8217; group, and click the Strikethrough button. These actions will cross out the text in the selected cells immediately.<\/p>\n<h3>What is the shortcut for strikethrough text?<\/h3>\n<p>The shortcut for applying strikethrough text in Excel is Ctrl + 5 on a Windows computer and Command + Shift + X on a Mac. Just select your text and press these keys to toggle the strikethrough on and off.<\/p>\n<h3>Can Strikethrough Be Sorted or Filtered within Excel?<\/h3>\n<p>Strikethrough itself cannot be directly used as a criterion for sorting or filtering in Excel. If you need to sort or filter by strikethrough, you would have to use a workaround, like adding a helper column to indicate the status of cells that are struck through and then filter based on that column.<\/p>\n<h3>Are There Any Strikethrough Accessibility Features for Excel Online Users?<\/h3>\n<p>Excel Online users have access to most of the standard accessibility features found in Excel, including strikethrough formatting. However, they currently cannot select non-adjacent cells to apply strikethrough directly. Users must format cells individually or use keyboard shortcuts. Additionally, assistive technologies like screen readers can read out formatted text, including strikethrough, to aid users with visual impairments.<\/p>\n<h3>Where is the font strikethrough option?<\/h3>\n<p>In Excel, the strikethrough option is found in the &#8216;Font&#8217; group under the &#8216;Home&#8217; tab. To access it, click the small diagonal arrow at the bottom right of the &#8216;Font&#8217; group, which opens the &#8216;Format Cells&#8217; dialog box. Alternatively, you can press Ctrl + 1. In the dialog box, go to the &#8216;Font&#8217; tab and check the &#8216;Strikethrough&#8217; option.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn to apply &amp; manage Excel strikethrough for efficient data handling. Explore keyboard shortcuts, conditional formatting &amp; VBA for seamless editing.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"The Ultimate Guide to Excel Strikethrough Text","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[10],"tags":[1501,2437],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/47768"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=47768"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/47768\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=47768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=47768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=47768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}