Get WPS Office on Mac
Download the macOS desktop version for documents, spreadsheets, presentations, and PDFs.

Download WPS Office for All Platforms
Find your device and get the right version
- Download .dmg
- Move to Applications
- Open WPS Office
Search Results
450 results for find and replace excel mac
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
450 results for find and replace excel mac
How to find, replace, and locate content
02:27How to find, replace, and locate content
When we are using WPS Document to edit documents, there is always a high frequency of using search and replace features. These features not only can help us locate content, and replace it with specified content but also can replace the format of the text. It saves us a lot of time when we are editing the document, and increases the efficiency of work. Take this document as an example, when we are reading, we may want to quickly know where the character named Bennet has appeared in the ....
The Go to and Find & Replace function of data
11:15The Go to and Find & Replace function of data
We mainly study two methods of targeted search, Go to and Find, which are the same in objectives to find the desired cells, and different in search mechanism. Specifically speaking, Go to plays its role based on the cell's own attributes, such as constants, formulas, and blanks. While Find is more flexibly used to set some keywords and cell formats.In addition to exact search, we can use the two wildcards, * and ?, to apply the approximate lookup to the text.
How to quickly locate and replace data
02:12How to quickly locate and replace data
When processing data in a Spreadsheet, we somtimes quickly need to locate the data among various data, or modify incorrect data in bulk. It would be convenient to use the Find and replace fucntion in WPS Spreadsheet. This video could be used in Microsoft Office Excel and Openoffice. Take the following table as an example, which records students’ grades on various subjects. Supposed that we want to find the E grade from the sheet. 1. Select all those ranges of cells that we want to find....
Quickly replace the content and font in WPS Presentation
01:40Quickly replace the content and font in WPS Presentation
When using WPS Presentation, we want to make changes to the specified content or font of the text. Take this slide as an example. If we want to quickly replace WPS in the text with WPS Office,Click the Home tab, then click the Replace drop-down button and choose Replace.Or use the shortcut key Ctrl+H.In the pop-up dialog box, enter WPS in the edit box. We can also set the replacement conditions as needed, such as Match case and Find whole words only.In the Find what box, enter WPS. Whi....
How to insert and find bookmarks in WPS Writer
01:13How to insert and find bookmarks in WPS Writer
No matter you are students, teachers or business workers, can create and edit documents efficiently by WPS Writer as text editors. Easy to use like Microsoft Word.We cannot finish reading a long document all at once, so we can create bookmarks for the document contents to record the location we saw this time. Click the position where the bookmark needs to be Inserted. Then, select the Insert tab and click the Bookmark button to pop up the dialog box. We can enter the name of the Bookma....
How to extract and replace the page content of a PDF file
01:23How to extract and replace the page content of a PDF file
When we are editing a PDF file, what should we do if we want to extract and replace several pages of the content?We can use the Extract Page and Replace pages functions of WPS Premium. If we want to extract the third page of this file and save it separately as a PDF file, click the Page tab, click Extract Page. In the Extract Mode box, select Extract selected page to PDF. In Page range, enter 3.We can add a watermark to the file, and we can also name the newly output file and set the s....
How to delete blank pages quickly
03:14How to delete blank pages quickly
Are you confused about the blank pages between pages in a document? And you only press the Backspace key repeatedly to delete them, and you fail sometimes.So how can we delete blank pages quickly? Here I'll introduce three methods to you. Tips: Before deleting the blank pages, we can show paragraph marks first to know why these blank pages were generated. Head to the Home tab, click the Show/Hide Editing Marks drop-down button and check Show/Hide Paragraph Marks.· Delete paragraph ....
How to use Navigation Pane
02:01How to use Navigation Pane
Navigation Pane works like GPS in WPS Office, allowing users to find and locate text and adjust article structures more efficiently. 1. We need to open the Navigation Pane. Click the View tab, select Navigation Pane, and then it will appear on the left. 2. We can also click the Navigation Pane drop-down button and choose Move to Right according to our habits.There are four icons on the left, namely, Content, Section Navigation, Bookmark, and Find and Replace.· ContentHere is the table ....