How to strikethrough excel mac how to#

You May Also Like the Following Tutorials:.

Removing Strikethrough In Google Sheets.

Add Strikethrough with Conditional Formatting.

Add Strikethrough with the Format Drop Menu.

Keyboard Shortcut to Apply Strikethrough In Google Sheets.

How to strikethrough excel mac how to#

We have also written a post that explains how to strikethrough text in MS Excel. And if that doesnвЂ™t work, then method #4 will resolve the formatting issue. 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. 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. When you have certain text formatted as strikethrough in your spreadsheet, you might want to remove it at a later point in time.