Last updated: December 16, 2016 The strikethrough effect in Microsoft Excel 2010 is helpful when you wish to indicate that information in a cell should be ignored, yet you do not want to delete that information. But the strikethrough effect can be distracting, especially when it is used a lot, and the effect remains applied to the information if you copy and paste it into another spreadsheet or document. If you are finding the strikethrough effect to be problematic, then you are probably looking for a way to remove it.
The effect is not included in the ribbon, however, so you need to use a keyboard shortcut or a secondary menu in order to apply or remove it. Our tutorial below will show you where to find the strikethrough option so that you can eliminate it from your selected cells. Getting Rid of Strikethrough Effect in Excel 2010 Text The steps in this article will assume that you have a spreadsheet which contains text with the strikethrough effect, and that you wish to remove that effect. If you instead wish to add the strikethrough effect to some of the cells in your spreadsheet, the will show you how. Step 1: Open your spreadsheet in Microsoft Excel 2010. Step 2: Select the cell(s) containing the strikethrough text that you wish to remove. Step 3: Click the Home tab at the top of the window, then click the Format Cells: Font button at the bottom-right corner of the Font section in the Office ribbon.
I know how to do a strikethrough on Mac, I just wanted to know if there were a shortcut for doing so. I routinely keep 'to-do' lists and the like on TextEdit, and on my PC I'd go down the list and Ctrl-5 to cross off things on Word.
Step 4: Check the box to the left of Strikethrough, then click the OK button at the bottom of the window. Summary – How to turn off strikethrough in Excel 2010. Select the cells containing the strikethrough text you wish to remove.
![Through Through](/uploads/1/2/5/4/125499613/198667641.gif)
Click the Home tab. Click the Format Cells: Font button at the bottom-right corner of the Font section in the ribbon.
![Shortcut for strike through in excel on mac mac Shortcut for strike through in excel on mac mac](/uploads/1/2/5/4/125499613/323232668.gif)
Check the box to the left of Strikethrough to remove the check mark. Click the OK button.
The method for adding strikethrough to text in Excel 2010 is very similar. The steps below will walk you through it. How to Strikethrough in Excel 2010 The steps below will show you how to select a group of cells and apply the strikethrough effect to the data in those cells. Step 1: Use your mouse to highlight the Excel cells that you would like to strikethrough. Step 2: Click the Home tab at the top of the window.
Step 3: Click the small dialog launcher button at the bottom-right corner of the Font ribbon section. Step 4: Check the box to the left of Strikethrough to apply the effect to the data in the selected cells. Click the OK button to close the window. Note that you can also toggle the strikethrough effect on or off for selected cells by using the default shortcut. The shortcut for the strikethrough effect in Excel 2010 is Ctrl + 5. Is there too much formatting applied to your cells, and you would prefer to remove all of it at once?
Learn from a group of cells, or even the entire spreadsheet.