Summary of the Excel Strikethrough Shortcut Drop-down menusĪlso, you could use a drop-down menu to dictate the formatting of a specific cell. You can also use a second column, next to the items on your to-do list, with checkboxes that will trigger a strikethrough in the adjacent cells. This can take your to-do list to the next level. If you’re a power-user, you can use VBA to apply strikethroughs to cells by simply double-clicking them, thanks to VBA macros. We’ve gone over a few examples of different times that you can use the Strikethrough in Excel, here are some ideas… Using Double Click (VBA)
This is some very valuable real estate on your Excel screen, and taking advantage of it can make you much more productive, especially if you use a mouse and some of the functions you use frequently are buried in menus.īringing them right to the forefront can save you a lot of time if you don’t want to learn the keyboard shortcuts for everything. While you’re here, why not take a look at some of the other commands and options that you can add to your QAT? Just take note of the things you remove, in case you’re ever looking for them down the road.Ĭlick Okay, and admire your new customized Quick Access Toolbar in Excel. You can also remove any commands you don’t use, to have a clearer layout. Scroll down the long list of commands, and choose Strikethrough, and click “Add >” to add this command to your toolbar.
Locate your Quick Access Toolbar, and right-click on either any of the existing items or elsewhere on the ribbon itself and choose the option that says Customize Quick Access Toolbar.įrom the customization menu, under the “Choose commands from:” dropdown menu, select “All Commands.” To add the strikethrough command to your QAT… 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.
#MS WORD STRIKETHROUGH SHORTCUT 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.
0 kommentar(er)
