Excel shortcuts

How to Use the Strikethrough Shortcut in Excel

If you're like most people, you probably use the strikethrough shortcut in Excel all the time. After all, it's a great way to quickly remove unwanted text from a cell. But did you know that there's more to the strikethrough shortcut than just deleting text?

In this article, we'll show you how to use the strikethrough shortcut in Excel to its full potential. We'll also share some tips on how to make the most of this handy tool.

The Basics: How to Use the Strikethrough Shortcut in Excel

The strikethrough shortcut in Excel is simple to use. Just select the text you want to remove and press the following keys on your keyboard:

Ctrl + 5

That's it! The selected text will now have a line through it, indicating that it's been removed. You can still see the text, but it's now clearly marked as deleted.

One thing to keep in mind is that the strikethrough shortcut only works on selected text. So if you want to remove the strikethrough from a cell, you'll need to select the entire cell. To do this, just click on the cell and press the following keys on your keyboard:

Ctrl + A

Now that the entire cell is selected, you can press the strikethrough shortcut keys to remove the strikethrough. Keep in mind that this will also remove any other formatting, such as bold or italics, from the cell.

How to Use the Strikethrough Shortcut to Delete Text

The strikethrough shortcut is a great way to quickly remove unwanted text from a cell. But did you know that you can also use it to delete text?

To delete text using the strikethrough shortcut, simply select the text you want to delete and press the following keys on your keyboard:

Ctrl + 5

The selected text will now have a line through it, indicating that it's been deleted. You can still see the text, but it's now clearly marked as deleted. To actually delete the text, simply press the delete key on your keyboard.

How to Use the Strikethrough Shortcut to Format Text

In addition to deleting text, the strikethrough shortcut can also be used to format text. For example, you can use it to add a line through selected text, or to change the color of selected text.

To format text using the strikethrough shortcut, simply select the text you want to format and press the following keys on your keyboard:

Ctrl + 5

The selected text will now have a line through it. To change the color of the selected text, simply press the following keys on your keyboard:

Ctrl + Shift + 5

The selected text will now be highlighted in the color you selected. You can also use the strikethrough shortcut to add other formatting, such as bold or italics, to selected text.

How to Use the Strikethrough Shortcut to Insert Text

In addition to deleting and formatting text, the strikethrough shortcut can also be used to insert text. To insert text using the strikethrough shortcut, simply select the cell where you want to insert the text and press the following keys on your keyboard:

Ctrl + 5

The selected cell will now have a line through it. To actually insert the text, simply type the text you want to insert and press the enter key on your keyboard.

How to Use the Strikethrough Shortcut to Move Text

In addition to deleting, formatting, and inserting text, the strikethrough shortcut can also be used to move text. To move text using the strikethrough shortcut, simply select the text you want to move and press the following keys on your keyboard:

Ctrl + 5

The selected text will now have a line through it. To actually move the text, simply use the arrow keys on your keyboard to move the text to the desired location.

How to Use the Strikethrough Shortcut to Copy Text

In addition to deleting, formatting, inserting, and moving text, the strikethrough shortcut can also be used to copy text. To copy text using the strikethrough shortcut, simply select the text you want to copy and press the following keys on your keyboard:

Ctrl + 5

The selected text will now have a line through it. To actually copy the text, simply press the following keys on your keyboard:

Ctrl + C

The selected text will now be copied to the clipboard. You can then paste the text into the desired location.

How to Use the Strikethrough Shortcut to Save Time

As you can see, the strikethrough shortcut is a versatile tool that can be used for more than just deleting text. By taking the time to learn how to use the strikethrough shortcut to its full potential, you can save yourself a lot of time and effort.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.