Question EN

How do I strikethrough text in Excel?

Answer

Select the cell or text, then press Ctrl+5. Or go to Format Cells → Font tab → check 'Strikethrough'.

Detailed explanation

Strikethrough is useful for marking completed tasks or outdated data.

Quick Method — Keyboard Shortcut

Select the cell or text inside it and press:

Ctrl + 5

Press again to remove the strikethrough.

Through the Menu

Select the cells
Press Ctrl+1 (Format Cells dialog)
Go to the Font tab
Check Strikethrough
Click OK

Partial Strikethrough

You can strike through just part of the text in a cell:

Double-click the cell (edit mode)
Select the text you want
Press Ctrl+5

Conditional Formatting

For automatic strikethrough (like for completed tasks), use conditional formatting with a custom format.

02.02.2026 Excel / Google Sheets

Need a custom formula?

Describe your task — AI will generate a working formula in seconds

Generate Formula

Related Questions

How do I calculate a percentage in Excel?

Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.

How do I round numbers in Excel?

Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.

How do I calculate an average in Excel?

The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.

How do I raise a number to a power in Excel?

Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).

How do I get the absolute value in Excel?

The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.

Great formula!

Sign in to save formulas and get more free requests

Sign in for free