{"id":1796,"date":"2026-11-01T02:32:23","date_gmt":"2026-11-01T02:32:23","guid":{"rendered":"https:\/\/iqsix.com\/index.php\/2026\/11\/01\/excel-strikethrough\/"},"modified":"2026-11-02T02:28:33","modified_gmt":"2026-11-02T02:28:33","slug":"excel-strikethrough","status":"publish","type":"post","link":"https:\/\/iqsix.com\/index.php\/2026\/11\/01\/excel-strikethrough\/","title":{"rendered":"How to Strikethrough in Excel: Shortcut and 4 Ways"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Short answer:<\/strong> the Excel strikethrough shortcut is <strong>Ctrl + 5<\/strong> on Windows. Select the cells and press it once to cross the text out, and again to remove the line. On a Mac, press <strong>Shift + Command + X<\/strong>. Prefer the menus? Use the small arrow in the Font group on the Home tab (or press Ctrl + 1) to open Format Cells, and on the Font tab tick <strong>Strikethrough<\/strong> under Effects.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Every step comes from Microsoft Support, checked in November 2026, for Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 on Windows and Mac, plus Excel for the web.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Windows shortcut:<\/strong> Ctrl + 5 (press it again to remove the line)<\/li>\n\n<li><strong>Mac shortcut:<\/strong> Shift + Command + X<\/li>\n\n<li><strong>Format Cells:<\/strong> Ctrl + 1 &gt; Font &gt; Effects &gt; Strikethrough &gt; OK<\/li>\n\n<li><strong>Part of a cell:<\/strong> press F2, select the characters, then Ctrl + 1<\/li>\n\n<li><strong>Excel for the web:<\/strong> Home &gt; Font Settings &gt; Strikethrough &gt; OK<\/li>\n\n<li><strong>Automatic:<\/strong> a conditional formatting rule crosses out finished tasks<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li class=\"\"><a href=\"#shortcut\">Excel strikethrough shortcut: Ctrl + 5<\/a><\/li><li class=\"\"><a href=\"#which\">Which way should you use?<\/a><\/li><li class=\"\"><a href=\"#format-cells\">How to strikethrough in Excel with Format Cells<\/a><\/li><li class=\"\"><a href=\"#part\">Strikethrough part of the text in a cell<\/a><\/li><li class=\"\"><a href=\"#web\">Strikethrough in Excel for the web<\/a><\/li><li class=\"\"><a href=\"#conditional\">Cross out finished tasks automatically<\/a><\/li><li class=\"\"><a href=\"#toolbar\">Add a strikethrough button to the Quick Access Toolbar<\/a><\/li><li class=\"\"><a href=\"#remove\">How to remove strikethrough in Excel<\/a><\/li><li class=\"\"><a href=\"#problems\">Excel strikethrough not working? Quick fixes<\/a><\/li><li class=\"\"><a href=\"#buy\">Get Microsoft 365 from IQSIX<\/a><\/li><li class=\"\"><a href=\"#faq\">Excel strikethrough: FAQ<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"shortcut\">Excel strikethrough shortcut: Ctrl + 5<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-shortcuts.webp\" alt=\"Excel strikethrough shortcut keys: Ctrl+5 on Windows, Shift+Cmd+X on a Mac, Ctrl+1 for Format Cells\" class=\"wp-image-1795\" srcset=\"https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-shortcuts.webp 1200w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-shortcuts-300x169.webp 300w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-shortcuts-1024x576.webp 1024w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-shortcuts-768x432.webp 768w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-shortcuts-80x45.webp 80w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-shortcuts-600x338.webp 600w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><figcaption class=\"wp-element-caption\">Strikethrough shortcuts for Excel on Windows and Mac.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Microsoft lists one shortcut that both adds and removes the line: \u201cApply or remove strikethrough formatting\u201d (<a href=\"https:\/\/support.microsoft.com\/en-us\/accessibility\/excel\/keyboard-shortcuts-in-excel\" target=\"_blank\" rel=\"noopener\">Keyboard shortcuts in Excel<\/a>). The keys that help with it:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Action<\/th><th>Windows<\/th><th>Mac<\/th><\/tr><\/thead><tbody><tr><td>Apply or remove strikethrough<\/td><td>Ctrl + 5<\/td><td>Shift + Command + X<\/td><\/tr><tr><td>Open the Format Cells box<\/td><td>Ctrl + 1<\/td><td>Command + 1<\/td><\/tr><tr><td>Edit the cell, to select characters<\/td><td>F2<\/td><td>F2<\/td><\/tr><tr><td>Undo<\/td><td>Ctrl + Z<\/td><td>Command + Z<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">Excel strikethrough shortcuts, from Microsoft Support, November 2026.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">To use the strikethrough shortcut in Excel, select one cell, a range, or whole rows or columns, and press Ctrl + 5. Press Ctrl + 5 again on the same cells to remove the line. On a Mac, Microsoft\u2019s list for Excel for Mac gives Shift + Command + X instead.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"which\">Which way should you use?<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Way<\/th><th>Best for<\/th><th>Works in<\/th><\/tr><\/thead><tbody><tr><td>Ctrl + 5 (Shift + Command + X)<\/td><td>The fastest way, for cells, ranges, rows or columns<\/td><td>Excel for Windows and Mac<\/td><\/tr><tr><td>Format Cells<\/td><td>Seeing a preview first, or setting other font effects at the same time<\/td><td>Excel for Windows, Mac and the web<\/td><\/tr><tr><td>Part of a cell<\/td><td>Crossing out one word or an old price inside a cell<\/td><td>Excel for Windows (edit the cell first)<\/td><\/tr><tr><td>Conditional formatting<\/td><td>To-do lists that cross out finished tasks by themselves<\/td><td>Excel for Windows and Mac<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">Four ways to strikethrough in Excel, from Microsoft Support, November 2026.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Strikethrough in Excel is only formatting. The value in the cell doesn\u2019t change, so you can still sort and filter the list, and formulas that use the cell still see the same number or text. Use it to show edits or completed tasks, as Microsoft suggests; if you want the data gone, delete it instead.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"format-cells\">How to strikethrough in Excel with Format Cells<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-format-cells-strikethrough.webp\" alt=\"How to strikethrough in Excel with the Format Cells box: Font tab, Effects, Strikethrough\" class=\"wp-image-1793\" srcset=\"https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-format-cells-strikethrough.webp 1200w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-format-cells-strikethrough-300x169.webp 300w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-format-cells-strikethrough-1024x576.webp 1024w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-format-cells-strikethrough-768x432.webp 768w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-format-cells-strikethrough-80x45.webp 80w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-format-cells-strikethrough-600x338.webp 600w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><figcaption class=\"wp-element-caption\">Format Cells > Font > Effects > Strikethrough (drawing, not a screenshot).<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Prefer the menus? In the desktop app, Microsoft\u2019s route to strikethrough in Excel goes through the font settings: \u201cTo apply strikethrough, superscript, or subscript formatting, click the Dialog Box Launcher, and select an option under Effects\u201d (<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/format-text-in-cells\" target=\"_blank\" rel=\"noopener\">Microsoft Support<\/a>).<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the cells you want to cross out.<\/li>\n\n<li>On the <strong>Home<\/strong> tab, in the Font group, select the <strong>Font Settings<\/strong> dialog box launcher (the small arrow in the corner), or press <strong>Ctrl + 1<\/strong>.<\/li>\n\n<li>On the <strong>Font<\/strong> tab, under <strong>Effects<\/strong>, tick <strong>Strikethrough<\/strong>.<\/li>\n\n<li>Select <strong>OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Microsoft also lists Ctrl + Shift + F, which opens Format Cells straight on the Font tab. The same Effects box holds Superscript and Subscript, and the Preview shows the result before you select OK.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"part\">Strikethrough part of the text in a cell<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Want to cross out one word, not the whole cell? Microsoft\u2019s steps for the other Effects options start with \u201cSelect characters in a cell or cell range\u201d and then open the font settings or press Ctrl + 1 (<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/format-text-or-numbers-as-superscript-or-subscript\" target=\"_blank\" rel=\"noopener\">Microsoft Support<\/a>). Strikethrough sits in the same Effects box, so:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the cell and press <strong>F2<\/strong>. Microsoft: F2 edits the active cell and puts the insertion point at the end of its contents.<\/li>\n\n<li>Select the characters you want to cross out.<\/li>\n\n<li>Press <strong>Ctrl + 1<\/strong>, tick <strong>Strikethrough<\/strong> under Effects and select <strong>OK<\/strong>.<\/li>\n\n<li>Press Enter to leave the cell.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Only the characters you selected get the line; the rest of the cell keeps its look. This is handy for a price list where you cross out the old price and type the new one next to it in the same cell.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"web\">Strikethrough in Excel for the web<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Microsoft says you can \u201cdraw a line through data in a cell to show edits or completed tasks\u201d with the font strikethrough option (<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/where-is-the-font-strikethrough-option-in-excel-for-the-web\" target=\"_blank\" rel=\"noopener\">Microsoft Support<\/a>). In Excel for the web:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the cells containing the data you want to format.<\/li>\n\n<li>Go to <strong>Home<\/strong>, and in the <strong>Font<\/strong> group select <strong>Font Settings<\/strong> to open the Format Cells dialog.<\/li>\n\n<li>Select <strong>Strikethrough<\/strong>, then select <strong>OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">To remove it, select the cells again, clear Strikethrough and select OK. Microsoft\u2019s \u201cFormat text in cells\u201d page also lists strikethrough among the options under Font on the Home tab of Excel for the web (<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/format-text-in-cells\" target=\"_blank\" rel=\"noopener\">Microsoft Support<\/a>).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conditional\">Cross out finished tasks automatically<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-done-tasks.webp\" alt=\"Excel to-do list where conditional formatting adds strikethrough to tasks marked Done with the formula =$B2=\"Done\"\" class=\"wp-image-1794\" srcset=\"https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-done-tasks.webp 1200w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-done-tasks-300x169.webp 300w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-done-tasks-1024x576.webp 1024w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-done-tasks-768x432.webp 768w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-done-tasks-80x45.webp 80w, https:\/\/iqsix.com\/wp-content\/uploads\/2026\/11\/excel-strikethrough-done-tasks-600x338.webp 600w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><figcaption class=\"wp-element-caption\">Conditional formatting crosses out every task marked Done.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A to-do list where tasks cross themselves out when you mark them done is a classic use of Excel strikethrough. Conditional formatting does it with a formula. Microsoft\u2019s rules: the formula must start with an equal sign and return TRUE or FALSE, and relative references let Excel adjust the formula for each cell in the range (<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/use-conditional-formatting-to-highlight-information-in-excel\" target=\"_blank\" rel=\"noopener\">Microsoft Support<\/a>). In our example, the tasks are in A2:A6 and the status is in B2:B6:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the task cells, here <strong>A2:A6<\/strong>.<\/li>\n\n<li>On the <strong>Home<\/strong> tab, select <strong>Conditional Formatting &gt; Manage Rules<\/strong>, then <strong>New Rule<\/strong>.<\/li>\n\n<li>Under Select a Rule Type, choose <strong>Use a formula to determine which cells to format<\/strong>.<\/li>\n\n<li>Enter the formula <code>=$B2=\"Done\"<\/code>.<\/li>\n\n<li>Select <strong>Format<\/strong>, open the <strong>Font<\/strong> tab and tick <strong>Strikethrough<\/strong>. A grey font color makes finished tasks fade too. Select <strong>OK<\/strong> until all the boxes are closed.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Now type Done in column B and the task next to it gets a line through it. Why $B2? The dollar sign fixes the column, so every cell checks column B, while the row number moves with each cell: A3 checks B3, A4 checks B4 and so on. Want the whole row crossed out? Select A2:B6 in step 1 instead; the same formula works.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"toolbar\">Add a strikethrough button to the Quick Access Toolbar<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Use strikethrough in Excel a lot and don\u2019t like shortcuts? Put it one click away. Microsoft\u2019s steps for a command that isn\u2019t on the ribbon (<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/customize-the-quick-access-toolbar\" target=\"_blank\" rel=\"noopener\">Customize the Quick Access Toolbar<\/a>):<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select <strong>Customize Quick Access Toolbar<\/strong> and choose <strong>More Commands<\/strong>.<\/li>\n\n<li>In the <strong>Choose commands from<\/strong> list, select <strong>Commands Not in the Ribbon<\/strong>.<\/li>\n\n<li>Find <strong>Strikethrough<\/strong>, select <strong>Add<\/strong>, then OK.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Can\u2019t find it in that list? Microsoft\u2019s tip: set Choose commands from to <strong>All commands<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"remove\">How to remove strikethrough in Excel<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Shortcut:<\/strong> select the cells and press Ctrl + 5 again (Shift + Command + X on a Mac).<\/li>\n\n<li><strong>Format Cells:<\/strong> press Ctrl + 1 and clear the Strikethrough box.<\/li>\n\n<li><strong>All formatting at once:<\/strong> Home &gt; Editing &gt; Clear &gt; Clear Formats. This removes all the formatting of the selected cells, not just the line.<\/li>\n\n<li><strong>The line keeps coming back:<\/strong> a conditional formatting rule adds it. Select the cells and go to Home &gt; Conditional Formatting &gt; Clear Rules &gt; Clear Rules from Selected Cells.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"problems\">Excel strikethrough not working? Quick fixes<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Ctrl + 5 does nothing on a Mac:<\/strong> Excel for Mac uses Shift + Command + X.<\/li>\n\n<li><strong>Only part of the text has the line:<\/strong> you selected characters inside the cell. Press Enter to leave the cell, select the whole cell, then press Ctrl + 5.<\/li>\n\n<li><strong>The line won\u2019t go away:<\/strong> a conditional formatting rule adds it; clear the rule (see above).<\/li>\n\n<li><strong>Can\u2019t find the option in Excel for the web:<\/strong> go to Home and select Font Settings in the Font group.<\/li>\n\n<li><strong>Pressed it by mistake?<\/strong> Undo with Ctrl + Z.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Excel freezing or closing while you work? Repair Office: see <a href=\"https:\/\/iqsix.com\/index.php\/2026\/10\/30\/microsoft-office-click-to-run\/#repair\">how to repair Microsoft Office Click to Run<\/a>. Cleaning up a list? See <a href=\"https:\/\/iqsix.com\/index.php\/2026\/10\/31\/remove-duplicates-in-excel\/\">how to remove duplicates in Excel<\/a>. Working with numbers? See <a href=\"https:\/\/iqsix.com\/index.php\/2026\/11\/02\/standard-deviation-in-excel\/\">how to calculate standard deviation in Excel<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"buy\">Get Microsoft 365 from IQSIX<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/iqsix.com\/index.php\/product\/microsoft-office-365-personal-pc-mac-1-device-1-year-microsoft-key\/\"><img loading=\"lazy\" decoding=\"async\" width=\"1555\" height=\"1555\" src=\"https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9.webp\" alt=\"Microsoft 365 Personal 1 year product key\" class=\"wp-image-1149\" srcset=\"https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9.webp 1555w, https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9-300x300.webp 300w, https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9-1024x1024.webp 1024w, https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9-150x150.webp 150w, https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9-768x768.webp 768w, https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9-1536x1536.webp 1536w, https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9-80x80.webp 80w, https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9-600x600.webp 600w, https:\/\/iqsix.com\/wp-content\/uploads\/2025\/04\/M365_Personal-2-9-100x100.webp 100w\" sizes=\"auto, (max-width: 1555px) 100vw, 1555px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Excel comes with Microsoft 365. IQSIX sells a <a href=\"https:\/\/iqsix.com\/index.php\/product\/microsoft-office-365-personal-pc-mac-1-device-1-year-microsoft-key\/\">Microsoft 365 Personal 1-year key<\/a> with Excel, Word, PowerPoint and Outlook: the Excel for Microsoft 365 version this guide covers, on Windows and Mac.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Redeem:<\/strong> enter the key at microsoft365.com\/setup with your Microsoft account (see <a href=\"https:\/\/iqsix.com\/index.php\/2026\/10\/17\/redeem-microsoft-365-product-key\/\">how to redeem a Microsoft 365 product key<\/a>).<\/li>\n\n<li><strong>Delivery:<\/strong> by email after your payment is confirmed (or on WhatsApp if you ask).<\/li>\n\n<li><strong>Payment:<\/strong> crypto, card, or a Remitly bank or mobile money transfer at checkout.<\/li>\n\n<li><strong>Questions first?<\/strong> Ask us on WhatsApp or through our <a href=\"https:\/\/iqsix.com\/index.php\/contact-us-2\/\">contact page<\/a>.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-text-color has-background wp-element-button\" href=\"https:\/\/iqsix.com\/index.php\/product\/microsoft-office-365-personal-pc-mac-1-device-1-year-microsoft-key\/\" style=\"border-radius:8px;color:#ffffff;background-color:#046bd2\">Buy Microsoft 365 Personal<\/a><\/div>\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-text-color has-background wp-element-button\" href=\"https:\/\/wa.me\/19179248236?text=Hi%20IQSIX%2C%20I%20have%20a%20question%20about%20Microsoft%20Office\" style=\"border-radius:8px;color:#ffffff;background-color:#25D366\" target=\"_blank\" rel=\"noopener\">Ask us on WhatsApp<\/a><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Writing in Word too? See <a href=\"https:\/\/iqsix.com\/index.php\/2026\/11\/01\/hanging-indent-in-word\/\">how to do a hanging indent in Word<\/a> and <a href=\"https:\/\/iqsix.com\/index.php\/2026\/11\/01\/clear-formatting-in-word\/\">how to clear formatting in Word<\/a>. Not sure which Office to pick? Read <a href=\"https:\/\/iqsix.com\/index.php\/2026\/10\/18\/microsoft-365-vs-office-2024\/\">Microsoft 365 vs Office 2024<\/a>, or see all our <a href=\"https:\/\/iqsix.com\/index.php\/product-category\/softwares\/\">software keys<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"faq\">Excel strikethrough: FAQ<\/h2>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What is the shortcut for strikethrough in Excel?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Ctrl + 5 on Windows; press it again to remove the line. Microsoft lists Shift + Command + X for Excel for Mac.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-2\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I strikethrough in Excel without the shortcut?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Select the cells, press Ctrl + 1 or use the Font Settings launcher on the Home tab, tick Strikethrough under Effects on the Font tab and select OK.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-3\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Can I strikethrough only part of a cell?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Yes. Press F2 to edit the cell, select the characters, press Ctrl + 1, tick Strikethrough and select OK. Only the selected characters get the line.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-4\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I strikethrough in Excel for the web?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Select the cells, go to Home and select Font Settings in the Font group, select Strikethrough and select OK.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-5\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I cross out a task when it is done?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Use conditional formatting: select the task cells, add a new rule of the type Use a formula to determine which cells to format, enter a formula such as =$B2=&#8221;Done&#8221;, then select Format &gt; Font &gt; Strikethrough.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-6\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I remove strikethrough in Excel?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Select the cells and press Ctrl + 5 again, or clear the Strikethrough box in Format Cells. If a conditional formatting rule adds the line, clear that rule.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><em>Sources, checked 1 November 2026: Microsoft Support \u2013 <a href=\"https:\/\/support.microsoft.com\/en-us\/accessibility\/excel\/keyboard-shortcuts-in-excel\" target=\"_blank\" rel=\"noopener\">Keyboard shortcuts in Excel<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/format-text-in-cells\" target=\"_blank\" rel=\"noopener\">Format text in cells<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/where-is-the-font-strikethrough-option-in-excel-for-the-web\" target=\"_blank\" rel=\"noopener\">Where is the font Strikethrough option in Excel for the web?<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/format-text-or-numbers-as-superscript-or-subscript\" target=\"_blank\" rel=\"noopener\">Format text or numbers as superscript or subscript<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/use-conditional-formatting-to-highlight-information-in-excel\" target=\"_blank\" rel=\"noopener\">Use conditional formatting to highlight information<\/a> and <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/customize-the-quick-access-toolbar\" target=\"_blank\" rel=\"noopener\">Customize the Quick Access Toolbar<\/a>. IQSIX is not affiliated with Microsoft.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to strikethrough in Excel: the Ctrl+5 shortcut (Shift+Command+X on a Mac), the Format Cells box, part of a cell, Excel for the web and conditional formatting for finished tasks.<\/p>\n","protected":false},"author":4,"featured_media":1792,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1796","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"_links":{"self":[{"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/posts\/1796","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/comments?post=1796"}],"version-history":[{"count":3,"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/posts\/1796\/revisions"}],"predecessor-version":[{"id":1820,"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/posts\/1796\/revisions\/1820"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/media\/1792"}],"wp:attachment":[{"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/media?parent=1796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/categories?post=1796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iqsix.com\/index.php\/wp-json\/wp\/v2\/tags?post=1796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}