Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Find and replace functions in Spreadsheet
· Option 1:
[Find]
1. Click Home → Find and Replace →Find
2. Enter the keyword you want to find.
[Replace]
1. Click Home → Find and Replace →Replace
2. Enter the keyword you want to find in the first box, with contents to replace with in the second box.
3. Click Replace to replace the items one by one.
4. You can also click Replace All to replace all items.
· Option 2: Use short keys
[Find]Ctrl + F
[Replace]Ctrl + H
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
Also Read:
- 1. How to use Lookup and Reference functions in WPS Office Excel
- 2. How to Find and Replace in Word for Your Paper? [For Students]
- 3. How to use IF, AND, OR functions in excel with text
- 4. How to replace "space” with "paragraph mark”
- 5. How to replace text in excel
- 6. How to find and replace in Word