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 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....

Quickly download and install WPS Office on Windows 10

Welcome to WPS Official Academy! You must need handy office software at both workplace and campus, and WPS Office is the best choice for you. Wondering how to quickly download and install WPS Office on Windows 10? Continue to read and master it in 3 minutes! l What is WPS OfficeWPS Office is a high-performance and user-friendly office software launched by the Kingsoft team of China. Since 1988, WPS Office has never stopped improving its functions and user experience. As an all-in-one o....

WPS Office vs. Microsoft Office: Which fits you better?

Are you still weighing up various options regarding a handy and affordable office software? Microsoft Office and WPS Office are both the most popular and trustworthy office suite in the market. WPS Office vs. Microsoft Office, which is the most suitable one for you? This free tutorial provided by WPS Official Academy will guide you through the comparison between WPS Office and Microsoft Office. l WPS Office vs. Microsoft Office: ModulesØ WPS OfficeWPS Office is an all-in-one office sui....

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....

How to unhide the ribbon

The ribbon may be hidden in two situations.· Toolbar:If the toolbar is hidden, we can click the Show the Toolbar button. · Tab:1. If the ribbon is hidden, we can click the Menu button. 2. Click Options in the drop-down menu.3. Select Customize Ribbon in the Options popup window.4. We can see the Customize Ribbon area at the right corner of the interface. Here, we can check the tab we want to unhide and click OK. To be office specialists, you could learn how to use WPS Office online in ....

How to check the file location

· Option 11. Find the tab of the file in the Tab bar.2. Right-click, then we can see a drop-down menu.3. Select Open File Location. · Option 21. Click the Menu drop-down button, then we can see a drop-down menu.2. Select File → Properties. Now Property dialog box will pop up.3. Select General. In the Location area, we can find out the file location. · Option 31. Click the Menu button → select Options. Then a Options dialog box will pop up.2. Select File Location. Then we can find out t....