{"id":43080,"date":"2024-04-22T16:50:05","date_gmt":"2024-04-22T14:50:05","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=43080"},"modified":"2024-06-10T21:54:02","modified_gmt":"2024-06-10T19:54:02","slug":"strikethrough-shortcut","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/strikethrough-shortcut\/","title":{"rendered":"Strikethrough Shortcut for Mac &amp; Windows in Excel &#8211; Step by Step Guide"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Strikethrough-shortcut.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-43267 size-large\" title=\"Strikethrough shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Strikethrough-shortcut-1024x576.png\" alt=\"Strikethrough shortcut\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Strikethrough-shortcut-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Strikethrough-shortcut-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Strikethrough-shortcut-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Strikethrough-shortcut-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Strikethrough-shortcut.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/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\/strikethrough-shortcut\/#Introduction_to_Strikethrough_in_Excel\" title=\"Introduction to Strikethrough in Excel\">Introduction to Strikethrough in Excel<\/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\/strikethrough-shortcut\/#Mastering_Strikethrough_Shortcuts_for_Windows_Users\" title=\"Mastering Strikethrough Shortcuts for Windows Users\">Mastering Strikethrough Shortcuts for Windows Users<\/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\/strikethrough-shortcut\/#Cross-Platform_Tips_for_Using_Strikethrough\" title=\"Cross-Platform Tips for Using Strikethrough\">Cross-Platform Tips for Using 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\/strikethrough-shortcut\/#Advanced_Techniques_and_Troubleshooting\" title=\"Advanced Techniques and Troubleshooting\">Advanced Techniques and Troubleshooting<\/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\/strikethrough-shortcut\/#FAQ_Excel_Strikethrough_Shortcut_Insights\" title=\"FAQ: Excel Strikethrough Shortcut Insights\">FAQ: Excel Strikethrough Shortcut Insights<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction_to_Strikethrough_in_Excel\"><\/span>Introduction to Strikethrough in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Understanding the Role of Strikethrough in Data Management<\/h3>\n<p>In the world of spreadsheets, strikethrough isn&#8217;t just for show\u2014it&#8217;s a secret messenger. When you spot text with a line scored cleanly through it in Excel, it signals that you&#8217;re looking at tasks wrapped up with a bow or items that have sashayed off the must-have list. With a glance, this detail distinguishes the done from the do, or the outdated from the updated. It&#8217;s a nifty tracker for changes without altering the historical script of your data-driven narrative. Think of strikethrough as your data&#8217;s way of saying, &#8220;Been there, done that,&#8221; without losing its place in the story.<\/p>\n<h3>Differences Between Mac and Windows Excel Versions<\/h3>\n<p>When you&#8217;re juggling between Mac and Windows, you&#8217;ll notice each has its own spin on Excel, making the transition between them a bit like learning dialects of the same language. For starters, Windows loves its control key, while Mac is partial to the command key. This means shortcuts will often use similar key combinations but with a platform-specific twist.<\/p>\n<p>In Windows, you&#8217;re living in a world where &#8220;Ctrl&#8221; is the master key to shortcuts, and strikethrough is no exception. Meanwhile, Mac users rely heavily on the &#8220;Command&#8221; key in their Excel adventures. The interface and menus can vary slightly, too, with options and features positioned in bespoke locations dictated by the operating system&#8217;s design language.<\/p>\n<p>This subtle interplay between the two versions means that, while the core functions remain reliably consistent, the way you interact with them might take some getting used to as you switch from one to the other.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mastering_Strikethrough_Shortcuts_for_Windows_Users\"><\/span>Mastering Strikethrough Shortcuts for Windows Users<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Keyboard Shortcut to Apply Strikethrough in Excel for Windows<\/h3>\n<p>If you&#8217;re working with Excel on a Windows machine, the strikethrough shortcut is like the superhero of keyboard commands\u2014it&#8217;s quick, effective, and saves the day in a pinch. Whenever you need to cross out some text, simply select the cell or the specific text within the cell, and summon the strikethrough with a swift Ctrl + 5.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A553A42.433101_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-GIF_1.gif\" alt=\"Strikethrough Shortcut\" width=\"692\" height=\"382\" \/><\/p>\n<p>The text in question will wear a neat line across its middle in a blink, marking the task complete or the item obsolete. This keyboard incantation is as simple as it gets, saving you the journey through the labyrinth of menus and settings.<\/p>\n<p>Whether you&#8217;re dealing with a solitary cell or a swath of them, this keystroke is your trusty sidekick, ready to dash across your data with the speed of light (or at least as fast as you can press two keys).<\/p>\n<p>&nbsp;<\/p>\n<h3>Adding a Strikethrough Button to the Quick Access Toolbar<\/h3>\n<p>If you find yourself reaching time and again for that strikethrough format, it&#8217;s a smart move to give it a permanent home. You can add a strikethrough shortcut button right to the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/quick-access-toolbar-in-excel\/\" target=\"_blank\" rel=\"noopener\">Quick Access Toolbar (QAT)<\/a> in Excel for Windows, ensuring it&#8217;s just a click away.<\/p>\n<p>Let&#8217;s carve that pathway to quick strikethrough access:<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Click the small downward-pointing arrow located at the very top of the Excel window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A563A09.222464_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-2.png\" alt=\"Strikethrough Shortcut\" width=\"585\" height=\"640\" \/><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span> <\/strong>Expand the QAT &amp; choose &#8216;More Commands&#8230;&#8217; from the drop-down options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A573A08.455373_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-3.png\" alt=\"Strikethrough Shortcut\" width=\"1235\" height=\"731\" \/><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span> <\/strong>In the &#8216;Customize the Quick Access Toolbar,&#8217; change the &#8216;Choose commands from:&#8217; dropdown to &#8216;Commands Not in the Ribbon&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A573A37.007126_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-4.png\" alt=\"Strikethrough Shortcut\" width=\"1668\" height=\"869\" \/><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span> <\/strong>Scroll down to find and select &#8216;Strikethrough&#8217; then click the &#8216;Add &gt;&gt;&#8217; button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A583A01.993130_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-5.png\" alt=\"Strikethrough Shortcut\" width=\"1631\" height=\"887\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong><\/span> Hit &#8216;OK&#8217; and the deed is done. The strikethrough icon now graces your QAT.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A583A14.412095_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-6.png\" alt=\"Strikethrough Shortcut\" width=\"677\" height=\"675\" \/><\/p>\n<p>Whenever the urge strikes to strike-through, that button is ready for action, freeing you from the extra steps you&#8217;d otherwise take.<\/p>\n<p>Now, the line-through effect is a single-click wonder\u2014you could say it&#8217;s a shortcut to a shortcut, making your workflow smoother and letting you strike through the noise with speed and grace.<\/p>\n<p>Essentially, by customizing your QAT, you&#8217;re crafting your very own Excel command center, tailored just for your daily tasks and efficiency.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Cross-Platform_Tips_for_Using_Strikethrough\"><\/span>Cross-Platform Tips for Using Strikethrough<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>How to Strikethrough Only Part of a Cell<\/h3>\n<p>Need to make just a word or a chunk of text in a cell walk the line? It&#8217;s possible! Here&#8217;s how to apply that selective <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-strikethrough\/\" target=\"_blank\" rel=\"noopener\">strikethrough in Excel<\/a>:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Input your text into Excel cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A583A51.906970_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-7.png\" alt=\"Strikethrough Shortcut\" width=\"623\" height=\"262\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> After typing, manually select the specific word or phrase you want to strike through. Right-click and choose &#8220;Format Cells.&#8221; In the Format Cells dialog box, go to the Font tab, and check the &#8220;Strikethrough&#8221; option. Click OK. Repeat step 2 for each word or phrase you want to selectively strike through in different cells or within the same cell by manually selecting them and applying the formatting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A593A19.688420_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-GIF_8.gif\" alt=\"Strikethrough Shortcut\" width=\"1652\" height=\"958\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>Alternatively, press Ctrl + 5 (or \u2318 + Shift + X on a Mac) to apply that stylish strikethrough and boom\u2014partial text crossed out.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T193A593A57.067667_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-GIF_9.gif\" alt=\"Strikethrough Shortcut\" width=\"1092\" height=\"736\" \/><\/p>\n<p>This handy trick allows you to send a precise message about specific elements within a cell, keeping the rest untouched and visible.<\/p>\n<p>Remember, the goal is to communicate effectively\u2014not just about what&#8217;s complete or obsolete but also to show what still demands attention. That&#8217;s the power of partial strikethrough; it&#8217;s a nuanced paintbrush in your data visualization toolkit.<\/p>\n<p>&nbsp;<\/p>\n<h3>Conditional Formatting with Strikethrough for Dynamic Data Presentation<\/h3>\n<p>When your spreadsheet is the stage, and data&#8217;s the star, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/conditional-format-a-cells-value\/\" target=\"_blank\" rel=\"noopener\">conditional formatting<\/a> with strikethrough is like the director\u2014cueing the right visual cues at precisely the right time. This feature allows cells to adapt, putting on a strikethrough costume automatically when they meet your set of rules.<\/p>\n<p>Here&#8217;s the lowdown on setting the stage for conditional strikethrough:<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Highlight the cells you want the rules to apply to.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A003A16.572726_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-10.png\" alt=\"Strikethrough Shortcut\" width=\"708\" height=\"472\" \/><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span> <\/strong>Dive into the &#8216;Home&#8217; tab and choose &#8216;Conditional Formatting&#8217;, then &#8216;New Rule\u2026&#8217;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A003A34.714785_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-11.png\" alt=\"Strikethrough Shortcut\" width=\"1527\" height=\"677\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>Opt for &#8216;Use a formula to determine which cells to format&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A003A45.715673_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-12.png\" alt=\"Strikethrough Shortcut\" width=\"1192\" height=\"792\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4: <\/strong><\/span>Craft your formula. For instance, <code>=$B2=\"Present\"<\/code> will hunt down cells where &#8220;Present&#8221; is written. Then hit &#8216;Format\u2026&#8217;,<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A013A00.466375_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-13.png\" alt=\"Strikethrough Shortcut\" width=\"1131\" height=\"797\" \/><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span> <\/strong>Flick on the &#8216;Strikethrough&#8217; checkbox in the &#8216;Font&#8217; tab. Click \u2018Ok\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A013A15.224546_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-14.png\" alt=\"Strikethrough Shortcut\" width=\"1349\" height=\"926\" \/><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6:<\/span> <\/strong>After clicking on &#8216;OK&#8217; once more, the deal is sealed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A013A30.437392_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-15.png\" alt=\"Strikethrough Shortcut\" width=\"666\" height=\"355\" \/><\/p>\n<p>Now, like a spreadsheet chameleon, the cells will change their look\u2014in this case, strike out text\u2014based on your set of rules.<\/p>\n<p>Conditional strikethrough adds depth to your data&#8217;s story, highlighting progress, changes, or areas that need attention without manual updates.<\/p>\n<p>Immerse yourself in the freedom and clarity this brings\u2014watching your data-style itself on the fly is a bit like having an assistant who anticipates your needs before you even vocalize them.<\/p>\n<p>Whether it&#8217;s tracking project milestones or managing inventory, conditional strikethrough is a dynamically, turning your Excel canvas into an interactive dashboard.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Techniques_and_Troubleshooting\"><\/span>Advanced Techniques and Troubleshooting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Utilizing Macros for Strikethrough Formatting<\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-macros-vba-webinar-training\/\" target=\"_blank\" rel=\"noopener\">Embracing Macros in Excel<\/a> is like having a wizard by your side. You can create a spell\u2014or in Excel terms, a macro\u2014to add the strikethrough format with a flourish that no muggle manual method can match. Let&#8217;s brew this enchanting potion:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Invoke the VBA editor by pressing Alt + F11 when you&#8217;re in Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A013A49.736637_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-16.png\" alt=\"Strikethrough Shortcut\" width=\"1720\" height=\"894\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2: <\/strong><\/span>Click on &#8216;Insert&#8217; from the menu, and select &#8216;Module&#8217; to weave your new magic area.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A033A12.848581_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-17.png\" alt=\"Strikethrough Shortcut\" width=\"1731\" height=\"882\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>In the module cauldron, conjure up the following code:<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Sub Strikethrough()\r\n\r\nSelection.Font.Strikethrough = True\r\n\r\nEnd Sub<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Strikethrough Shortcut\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640981572024-04-16T203A053A32.155540_Excel_Quick_Tip_Strikethrough_Shortcut_for_Mac_26_Windows_-18.png\" alt=\"Strikethrough Shortcut\" width=\"1359\" height=\"827\" \/><\/p>\n<p><span style=\"font-size: calc(var(--editor-zoom-font-size) + var(--lumo-font-size-m));letter-spacing: 0.04em;font-family: inherit;color: var(--lumo-body-text-color)\">Once this macro is invoked, it&#8217;ll leap into action, striking through whatever you&#8217;ve highlighted.<\/span><\/p>\n<p>Remember the incantation: Macros apply their charm to the selected range. So, before you unleash the spell, make sure you&#8217;ve chosen the right cells for the transformation.<\/p>\n<p>Whether you&#8217;re in the world of budgeting spells or scheduling charms, a strikethrough macro can slash your formatting time, letting you focus on the real magic: analyzing and interpreting your data&#8217;s story.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQ_Excel_Strikethrough_Shortcut_Insights\"><\/span>FAQ: Excel Strikethrough Shortcut Insights<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Can I Split a Cell and Apply Strikethrough in Excel?<\/h3>\n<p>Absolutely, you can split the contents of a cell into separate cells using the &#8216;Text to Columns&#8217; feature and then apply strikethrough formatting individually. Just remember, splitting cells is different from applying partial strikethrough within a single cell.<\/p>\n<p>Make sure your data is prepped and ready for splitting to keep everything tidy and intentional. Once split, use your strikethrough shortcut or formatting menu to cross out what&#8217;s needed\u2014leaving your data clearly communicated and visually on point.<\/p>\n<h3>How Do I Remove Strikethrough Applied by Mistake?<\/h3>\n<p>Oops! If strikethrough sneaks into your cell by accident, reverse it with a cinch. Press Ctrl + 5 (Windows) or \u2318 + Shift + X (Mac) with the cell selected. This toggle removes the <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/where-is-the-font-strikethrough-option-e6df3b9d-cea6-4406-9271-5a5a52d66738\" target=\"_blank\" rel=\"nofollow noopener\">strikethrough<\/a> just as easily as it was applied.<\/p>\n<p><strong>Insert Quick Undo GIF Placeholder: Removing accidental strikethrough with keyboard shortcut<\/strong><\/p>\n<p>Or, dip into the &#8216;Format Cells&#8217; dialog (Ctrl + 1 or \u2318 + 1), untick the strikethrough option, and say goodbye to the unwanted line-through. Your data will be back to its pristine state before you know it.<\/p>\n<h3>Are There Alternative Methods to Strikethrough Without Shortcuts?<\/h3>\n<p>Certainly! If shortcuts aren&#8217;t your cup of tea, the traditional route via the Format Cells dialog is your next best friend. Right-click the cell(s) in question, pick &#8216;Format Cells,&#8217; then hop over to the Font tab, tick the strikethrough box, and hit OK.<\/p>\n<p>This method can be a few more clicks, but it\u2019s straightforward and gets the job done, especially if you&#8217;re already navigating through other formatting options. It&#8217;s also a favorite for the mouse mavens who prefer a more point-and-click approach to their Excel escapades.<\/p>\n<h3>Is there a shortcut for Strikethrough in Excel?<\/h3>\n<p>Yes, there is! To swiftly apply a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/mac-strikethrough\/\" target=\"_blank\" rel=\"noopener\">strikethrough in Excel<\/a>, use these keyboard shortcuts:<\/p>\n<ul>\n<li>On Windows, press Ctrl + 5.<\/li>\n<li>On Mac, the shortcut is \u2318 + Shift + X.<\/li>\n<\/ul>\n<p>These shortcuts are quick, reliable, and work on selected text within a cell or on the cell as a whole. Jump into the fast lane of formatting with these key combinations.<\/p>\n<h3>How to apply strikethrough on excel mac version?<\/h3>\n<p>Applying strikethrough in Excel on a Mac is a breeze with this sleek shortcut:<\/p>\n<ul>\n<li>Press \u2318 + Shift + X after selecting the text or cell you want to format.<\/li>\n<\/ul>\n<p>Alternatively, dive into the Format Cells dialog (\u2318 + 1), tick the strikethrough checkbox under the Font tab, and voil\u00e0\u2014your text is crossed out with the precision of a digital tailor.<\/p>\n<h3>How possible to copy\/link the formatting part as well?<\/h3>\n<p>Copying or linking formatting\u2014including strikethrough\u2014in Excel is doable using the Format Painter. This handy tool clones your formatting from one cell and brushes it onto another with just a couple of clicks:<\/p>\n<ol>\n<li data-list=\"ordered\">First, click the cell with the strikethrough you&#8217;d like to copy.<\/li>\n<li data-list=\"ordered\">On the &#8216;Home&#8217; tab, click the paintbrush icon known as the &#8216;Format Painter&#8217;.<\/li>\n<li data-list=\"ordered\">Then, paint away! Click on the cell(s) where you want the strikethrough applied.<\/li>\n<\/ol>\n<p>When the paint dries, you&#8217;ll see your stripes replicated exactly where you wanted. It&#8217;s a smooth way to ensure consistent formatting without reapplying settings from scratch.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn the quick strikethrough shortcut for Excel on Mac &amp; Windows. Efficiently manage your data with dynamic formatting tips, shortcuts &amp; more.<\/p>\n","protected":false},"author":1,"featured_media":43267,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Strikethrough Shortcut for Mac &amp; Windows in Excel - Step by Step Guide","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[1],"tags":[2437,2439,2438],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/43080"}],"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=43080"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/43080\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/43267"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=43080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=43080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=43080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}