How to Add Strikethrough in Excel?

Have you ever wanted to add a strikethrough in Excel but didn’t know how? It’s easier than you think! In this article, we’ll show you how to add a strikethrough in Excel, step-by-step. We’ll go over the different ways to add a strikethrough, and how to customize it for your specific needs. Whether you’re a beginner or an experienced Excel user, by the end of this article you’ll be able to add a strikethrough in no time!

Adding Strikethrough in Excel

Adding a strikethrough to your Excel documents is a great way to visually indicate which items have been completed or to cross out text that is no longer applicable. Excel provides several different ways to add a strikethrough, making it easy to apply the formatting you need to your documents.

Using the Format Cells Dialog Box

The easiest way to add a strikethrough to a cell in Excel is to use the Format Cells dialog box. To open the dialog box, click on the cell you want to format and then click the “Format” button on the Home tab. In the dialog box, click on the “Font” tab and then check the box next to “Strikethrough”. Click “OK” to apply the formatting.

You can also use the shortcut key combination “Ctrl + 1” to open the Format Cells dialog box. Once the dialog box is open, you can use the same steps outlined above to apply the strikethrough formatting.

Using the Font Group on the Home Tab

Another way to add a strikethrough to a cell in Excel is to use the Font group on the Home tab. To use this method, click on the cell you want to format and then click the “Strikethrough” button in the Font group. This will apply the strikethrough formatting to the selected cell.

You can also use the shortcut combination “Ctrl + 5” to quickly apply a strikethrough to a cell. This is a quick and easy way to apply the formatting without having to open the Format Cells dialog box.

Using the Keyboard Shortcut

The final way to add a strikethrough to a cell in Excel is to use the keyboard shortcut. To use this method, click on the cell you want to format and then press the “Alt + Shift + 5” keys on your keyboard. This will apply the strikethrough formatting to the selected cell.

Adding Multiple Strikethroughs in Excel

If you need to add multiple strikethroughs to your Excel document, you can do so by using the Format Cells dialog box. To use this method, select the cells you want to format and then click the “Format” button on the Home tab. In the Format Cells dialog box, click on the “Font” tab and then check the box next to “Strikethrough”. Click “OK” to apply the formatting.

You can also use the shortcut key combination “Ctrl + 1” to open the Format Cells dialog box. Once the dialog box is open, you can use the same steps outlined above to apply the strikethrough formatting to multiple cells.

Using the Font Group on the Home Tab

Another way to add multiple strikethroughs to cells in Excel is to use the Font group on the Home tab. To use this method, select the cells you want to format and then click the “Strikethrough” button in the Font group. This will apply the strikethrough formatting to the selected cells.

You can also use the shortcut combination “Ctrl + 5” to quickly apply a strikethrough to multiple cells. This is a quick and easy way to apply the formatting without having to open the Format Cells dialog box.

Using the Keyboard Shortcut

The final way to add multiple strikethroughs to cells in Excel is to use the keyboard shortcut. To use this method, select the cells you want to format and then press the “Alt + Shift + 5” keys on your keyboard. This will apply the strikethrough formatting to the selected cells.

Few Frequently Asked Questions

Q1: What is a strikethrough?

A strikethrough is a horizontal line that is used to indicate a cancellation or deletion of text. It is commonly used in text editors and word processors to indicate that text should be removed or ignored. In Excel, a strikethrough is used to indicate that a cell value should not be used in calculations.

Q2: How do I add a strikethrough in Excel?

Adding a strikethrough in Excel is easy. First, select the cell or cells that you want to add the strikethrough to. Then, go to the Font section of the ribbon and click on the Strikethrough button. This will add a strikethrough to the selected cells.

Q3: Is there a shortcut for adding a strikethrough in Excel?

Yes, there is a shortcut for adding a strikethrough in Excel. To do this, you can press the keyboard shortcut of Alt + H + 4. This will add a strikethrough to the selected cells.

Q4: Can I apply a strikethrough to multiple cells at once?

Yes, you can apply a strikethrough to multiple cells at once in Excel. To do this, you must first select the cells that you want to apply the strikethrough to. Then, go to the Font section of the ribbon and click on the Strikethrough button. This will apply the strikethrough to the selected cells.

Q5: Is it possible to remove a strikethrough in Excel?

Yes, it is possible to remove a strikethrough in Excel. To do this, you must first select the cell or cells that have the strikethrough applied. Then, go to the Font section of the ribbon and click on the Strikethrough button again. This will remove the strikethrough from the selected cells.

Q6: Is there a way to quickly add a strikethrough to all cells in a range?

Yes, there is a way to quickly add a strikethrough to all cells in a range in Excel. To do this, you must first select the range of cells that you want to apply the strikethrough to. Then, go to the Home tab of the ribbon and click on the Format drop-down menu. From the Format drop-down menu, select the Strikethrough option. This will add a strikethrough to all cells in the selected range.

Strikethrough Shortcut in Excel (Keyboard Shortcuts)

By following the simple steps outlined in this article, you can now easily add strikethrough in Excel. Whether you want to emphasize an important point or just want to make your spreadsheet look visually appealing, strikethrough is the perfect tool for the job. With its help, you can make your data stand out and be easier to read. So go ahead and start using strikethrough in Excel to make your work look better!