How to do strikethrough in excel mac how to#

If this is something you’re going to be using often, and you don’t want to simply use the keyboard shortcut, you can add the Strikethrough command to your QAT (quick access toolbar) for quick access. Adding Strikethrough Button to the Quick Access Toolbar You may need to save your workbook and reopen it in Excel for the web in order to view the changes you’ve made. Select the Strikethrough option, and you’re all set. You can choose between subscript, superscript, and strikethrough. Now, you can choose a handful of different effects in the Effects section. Simply open your spreadsheet in Excel for desktop and click over to the Home tab if you aren’t there by default.įrom there, look at the section just below where you edit the font color or background color, there’s a small little arrow in the corner, and clicking this will open the Format Cells box.

If you would prefer to click your way to a strikethrough, you can do so using the Format Cells launcher in the Home tab of the Excel desktop application. Add Strikingthroughs Using The Format Cells Launcher

You can select a single cell to apply this formatting to with the shortcut, or you can select multiple cells at once and press the same keyboard shortcut to add strikethrough to all of them.

How to do strikethrough in excel mac how to#

Start by selecting the cell or cells within which you would like to add your strikethrough, and then press CTRL + 5.ĬTRL + 5 is how to add a strikethrough to cells in an Excel worksheet. If you want to use a keyboard shortcut to add a strikethrough in Excel, it’s one of the easier keyboard shortcuts you’ll encounter. Keyboard Shortcut for Excel Strikethrough If you want to learn about using an Excel strikethrough shortcut, you’re in the right place. If shortcuts feel overwhelming, just try to learn a few at a time, and before you know it, you’ll be cruising around your sheets using nothing but your keyboard, and it can be a lot more quick and productive when you get really good at it. Well, since Excel isn’t focused on word processing or text editing to the same degree, it’s not quite as simple to add a strikethrough but learning the shortcuts will make it easy and fast. If you’ve used just about any word processor, you would expect to see a strikethrough option right there in the top menu, right? It gives you an instant visual cue of your progress, and you can do fun things like setting up a checkbox with tasks next to it that automatically adds a strikethrough when you check the box. That’s where using a strikethrough works nicely, it lets you know visually that this particular text can be ignored for the time being, but it’s still readable if you give it a closer look.īut this style choice isn’t only useful to help simplify more complex documents, it’s also perfect for very simple sheets like a checklist or a to-do list.Īdding a strikethrough as you complete a task is incredibly rewarding, much more so than simply moving on to the next item or task. Spreadsheets can become incredibly complex, and sometimes taking a bit of information off the table when it’s no longer needed is useful, but you don’t want to hide it completely.