Poradnik Excela

How to Apply Strikethrough in Excel

Strikethrough is a useful formatting tool for marking completed tasks or indicating obsolete data in Excel. You can apply it quickly using a simple keyboard shortcut or the settings menu.

Zrób to z SI

Krok po kroku

1
Zaznacz komórki
Click and drag to select the cell or range of cells you want to apply the strikethrough to.
2
Open Format Cells
Press Ctrl + 1 on your keyboard, or right-click the selection and choose 'Format Cells'.
3
Apply Strikethrough
Go to the 'Font' tab, check the 'Strikethrough' box under the Effects section, and click OK.

Wskazówki

Use the keyboard shortcut Ctrl + 5 to toggle strikethrough on and off instantly without opening the menu.

Najczęstsze pytania

Can I apply strikethrough to only part of the text in a cell?

Yes, double-click the cell to enter edit mode, highlight the specific text, then press Ctrl + 1 and check the Strikethrough box.