Useful tips

How do I Strikethrough text in Excel 2013?

How do I Strikethrough text in Excel 2013?

While your mouse is over the selected text, right-click and then select “Format Cells” from the popup menu. When the Format Cells window appears, select the Font tab. Check the Strikethrough checkbox. Click on the OK button.

Is there a hotkey for Strikethrough?

For a quick single strikethrough effect, you can use a keyboard combination to quickly reach the outcome. On a PC: the shortcut is Alt + H + 4. So, you select a piece of text or an entire paragraph and hit these keys on your keyboard. On a Mac: The keyboard shortcut is Cmd+Shift+X.

How do I add a Strikethrough to my toolbar in Excel?

To add Strikethrough to the Quick Access Toolbar in Excel:

  1. Click the down arrow to the right of the Quick Access Toolbar and select More commands from the drop-down menu.
  2. Below Choose command from, select All Commands from the drop-down menu.
  3. In the list of commands, click Strikethrough and then click Add.

How do I do a Strikethrough in Excel?

How to Find Cells With Strikethrough in Excel

  1. Select any cell in the spreadsheet, then click the “Home” tab.
  2. Click “Options,” then click the “Format” button.
  3. Click the “Font” tab.
  4. Click “Find All” and a list of every cell that contains strikethrough text will appear at the bottom of the Find and Replace window.

What is the keyboard shortcut for strikethrough in Excel?

Additionally, the strikethrough effect can be applied or removed by simultaneously pressing the Ctrl + 5 keys on your keyboard. That is the keyboard shortcut for Strikethrough in Excel 2013.

How to apply strikethrough to range of cells in Excel?

Just select the cell where you want to apply the strikethrough format and press Control + 5. If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut. You can also select non-adjacent ranges and then apply the strikethrough format.

How to add strikethrough to quick access toolbar in Excel?

Right-click on any existing QAT icon or the ribbon tabs and select ‘Customize Quick Access Toolbar…’. In the Excel Options dialogue box, select All Commands from the drop-down. Scroll down and select Strikethrough from the list. Click on Add. Click OK. This will add the strikethrough icon in the quick access toolbar.

How to find and replace strikethrough format in Excel?

This post will show you one method to accomplish it using Find and Replace feature. Just do the following steps: Step2: go to Home tab, click Find & Select button under Editing group. And select Find from the context menu list. And the Find and Replace dialog will open.