![strikethrough shortcut excel mac strikethrough shortcut excel mac](https://nutsandboltsspeedtraining.com/wp-content/uploads/2019/11/Screen-Shot-2019-11-06-at-5.07.23-PM.png)
You can use methods #1 through #3 to remove strikethrough from your cells in seconds. No more struggling to remove the strikethrough formatting in your MS Excel worksheet. Since the rule is no longer in effect, cells A6 and A11 are not formatted anymore. In our example, all duplicate entries were formatted as strikethrough. Move your mouse over Clear Rules and from the menu that opens, select Clear Rules from Selected Cells.Īny conditional formatting will be removed. Step #2: Select Clear RulesĬlick on the Conditional Formatting icon to get to the dropdown menu. Step #1: Select the range of cellsĭrag your cursor across the required range of cells. You can use this method if the above ones don’t work.
![strikethrough shortcut excel mac strikethrough shortcut excel mac](http://nutsandboltsspeedtraining.com/wp-content/uploads/2020/03/Strikethrough-Shortcut-3-2.jpg)
In this particular example, you can’t remove the strikethrough in cells A6 and A11 because it’s formatted that way. If none of the above methods work, it’s probably because the cell is conditionally formatted that way. Method #4: Remove Conditional Strikethrough in MS Excel Using the Clear Rules Option This would remove the strikethrough formatting from the selected cell. Step #4: Uncheck the strikethrough checkbox This opens up the Format Cells dialog box. Right-click on the cell and you will see a new list of options. If it’s a range of cells, just drag your cursor across it and select all of them.Ĭonfirm your choice using the Name box. To remove the strikethrough, select that cell. While shortcut keys and the main menu are always good to know and use, sometimes a simple right click can let you access the most popular commands. Now, you can see that the strikethrough formatting from cells A2 and A3 has been removed. Under the Effects section, you can see a Strikethrough checkbox. You’ll now see the Format Cells dialog box. Go to the Font section and click on the extend icon, which is a small arrow in the bottom right corner of that section, as shown below.Īlternatively, you can use the keyboard shortcut Ctrl + Shift + F or Ctrl + 1. Step #3: Open font settingsĬlick on the Home tab in the top menu bar to change the ribbon. If it’s a range of cells, just drag your cursor across it and select all of them. Step #2: Select a cell or a range of cells Open an existing worksheet or create a new one if you don’t have an existing workbook. This method uses the normal ribbons to access the required commands. Knowing what is where in your ribbons will allow you to work with ease. Once you do that, the cell will not show the strikethrough formatting. Press Ctrl on your keyboard and also 5 at the same time if you use Windows.įor Mac, use ⌘ + SHIFT + X to remove the strikethrough. You can confirm your choice in the Name box. Select the cell in which you want to remove the strikethrough format from the text. Open your workbook or create a new one if you don’t have an existing workbook. This is one of the easiest and quickest methods to remove a strikethrough in MS Excel. Remove conditional strikethrough in MS Excel using the Clear Rules option.4 Methods to remove strikethrough in MS Excel: Fortunately, there are several quick and easy methods in MS Excel to remove the strikethrough. But watch out for the amount the key combinations vary between programs and operating systems.When you have certain text formatted as strikethrough in your spreadsheet, you might want to remove it at a later point in time. Prepped with this knowledge you’ll be one productive task master, satisfyingly scoring lines through that endless pile of tasks.
Strikethrough shortcut excel mac windows#
After that close both windows and you’re good to go. Control-5 or Alt-Shift-5 are the most common so maybe the easiest to remember. Below ‘press new shortcut key’ enter a new shortcut for strike through. Click the strikethrough checkbox and this will open another window called ‘customise keyboard’. If done correctly, the cursor will turn into a clover. With that open hit Alt and Control at the same time and press +. Go back to that font customiser window mentioned above by pressing Control-D. If you want to create your own Strikethrough shortcut in Word for Windows you can. There you have it, the longest strikethrough shortcut known to man. This will check the strikethrough style, then press enter. Then press Control-D to open the font customiser window. Highlight that task you’ve just nailed or that mistake made by a colleague you’re about to humiliate. You may need to use a convoluted work around.
Strikethrough shortcut excel mac for windows 10#
However, if you’re using Word for Windows 10 the below shortcuts might not work. This is typically seen in Word documents that have been doing their rounds hoovering up amends and criticism. Other than marking something as complete strikethrough can be used to mark something as corrected.