Excel Hack

Strikethrough shortcut Excel

Excel has a strikethrough feature that draws a line in the middle of text or value to indicate that it has been canceled. You can apply a strikethrough quickly and easily by using the shortcuts we will show you. We will show you how to apply a strikethrough using the shortcut keys and how to apply a strikethrough from the Format Cells dialog box. This method is useful when you want to show that you have completed a task or activity in a clear way.

Strikethrough shortcut

Apply strikethrough

Windows
Ctrl + 5

Mac
control + 5 or command + shift + X

Display the Format Cells dialog box

Windows
Ctrl + Shift + F or Ctrl + Shift + P
Access Key: Alt + H + F + N

Mac
control + shift + P

Apply a strikethrough to the entire text in a cell

This is a way to display a strikethrough for the entire text in a cell using a shortcut key.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell to which you want to apply the strikethrough.

The strikethrough was applied

The strikethrough line was applied

Press Ctrl + 5. Now the strikethrough is applied.

Apply strikethrough to some text

Select a cell

Select the cell that contains the text to which you want to apply the strikethrough.

Select a portion of the text

Press F2 to activate the cell edit mode, and press Shift + (Left Arrow key) to select the text to which you want to apply the strikethrough.

Strikethrough applied to a portion of text

Press Ctrl + 5 to apply a strikethrough to the selected text.

Apply strikethrough to multiple texts

Select a cell

Select the cell to which you want to apply the strikethrough.

Select multiple cells

Press Shift + (Down Arrow key) to select multiple cells where you want to apply the strikethrough.

Apply a strikethrough to multiple texts

Press Ctrl + 5 to apply a strikethrough to multiple texts.

Apply strikethrough from the Format Cells dialog box

Select a cell

Select the cell to which you want to apply the strikethrough. Press Ctrl + Shift + F or Alt + H + F + N.

Press Alt + K,Enter

The Format Cells dialog box will appear.

Press Alt + K to check the strikethrough checkbox, and press Enter.

The strikethrough line was applied

The strikethrough has been applied.