WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to add strikethrough line in excel

December 13, 2021
6.0K Views

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.  Strikethrough line can show a completed task, a marked error, or introduce WPS tutorials with Microsofts heading, as you can see, it can expressthe author'sopinion in an annoying funny way.

1. Open your table with WPS Spreadsheet.

2. Select the cells or texts you want to add the strikethrough line on. Head to the Home tab > Settings > Cells. You can also use the shortcut key Ctrl+1.

3. Click Font > Effect > check Strikethrough.

4. Also, you can add the strikethrough line in batches. Select the area that contains the content. Head to the Home tab > Find and Replace > Replace or use the shortcut key Ctrl+H.

5. Type the content you want to add Strikethrough line on at Find what and Replace with. Then click Options > Format on the right of Replace with > Format > Font > Effect > check Strikethrough > OK > Replace All.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.