How to compare two excel sheets and highlight differences

In this article, you will know how to quickly compare two excel sheets and highlight differences with only 6 simple steps as follows. How to quickly compare two excel sheets for differences in values? You can use the View Side-by-Side comparison function if your boss requires you to immediately find out the differences between the two Excel sheets.For example, this is book1 and this is book2, click on View Side-by-Side and you can manually find out the differences in their values row b....

How to check and update WPS Office version

1. Open WPS Office. Click the Home icon in the upper-left corner, and then click Global Settings → About WPS Office.2. In the pop-up box, we can view the current version information and check updates. For all, easy your work with WPS office suite. Free download WPS office for PC, Mobile, Windows, Mac, Android, iOS online.

How to download files in WPS Cloud

1. Open WPS Office.2. Click Open → My Cloud Files.3. Place the cursor on the file we want to download, right-click and select Export in the shortcut menu, then we can download files in WPS Cloud. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.

How to search file history in WPS Office

1. Open the WPS Office.2. Enter the content in the search box on the home page, then we can view the file history. For all, easy your work with WPS office suite. Free download WPS office for PC, Mobile, Windows, Mac, Android, iOS online.

How to add a hyperlink

1. Open the file in WPS Writer.2. Select the object we want to insert a hyperlink, the right-click to select Hyperlink in the drop-down menu. Or we can use its shortcut key Ctrl+K. 3. Then a Hyperlink dialog box will pop up. In the dialog box, we can enter the link in the Address area. We can also use other ways to insert different types of hyperlink according to our needs.4. Now clink OK. 5. Then we have successfully add a hyperlink! WPS office software could be compatible with Micros....

How to convert an image to a PDF file in WPS Office

We use powerful PDF in our daily life nearly every day. WPS pdf converter is easy and free for people to use.We can use this feature in Writer, Spreadsheet, Presentation and PDF. Here, we will take WPS Presentation as an example. It is also the same in WPS Writer and WPS Spreadsheet.1. Open WPS Office. 2. Select the Tools tab → and then click Picture to PDF. Then a Picture to PDF dialog box will pop up.3. Click the Add button in the dialog box. Then we can choose the picture we want to....

How to remove files in WPS Cloud

· Remove a single file:1. Click the Open tab → My Cloud Files.2. Place the cursor on the file to be deleted, right-click the file, and click Delete. · Remove multiple files:1. Press the keyboard Ctrl+left mouse button or press the Shift+left mouse button to multi-select the files that need to be deleted.2. Click the right mouse button, and click Delete to remove files in batches. For all, easy your work with WPS office suite. Free download WPS office for PC, Mobile, Windows, Mac, Andro....

How to customize shortcut keys in WPS

This feature only supports WPS Writer for the time being.1. Use WPS Office to open the document first.2. Click Menu → Options in the upper left corner, and select Customize Ribbon.3. Click Customize. Then we can choose the feature that we want to customize shortcut keys in this Customize Keyboard popup box.4. We can find the needed command according to its related categories. 5. After we choose the right command in Commands, we can customize the shortcut key in the Specify Keyboard Seq....