How to encrypt excel files in windows 10

The digital world full of hackers, data breaches and cyber bullying, one’s personal information can easily be leaked. Excel files consist of sensitive information, personal finances and records which are vulnerable to leaking. To protect important data and files from prying eyes excel has a very useful and distinctive feature of encrypting files. Encrypting the files fully secures your data and sensitive content which prevents other users from making changes in files. It will pro....

How to update only the page number in a table of contents

1. Open the document we want to edit in WPS Writer.2. Click on the table of contents.3. Click References tab → and then click the Update TOC button.4. Now a Update Table of Contents small dialog box will pop up. Check Update page numbers only.5. Finally, click OK. This skill could also be used in Microsoft Office Word and OpenOffice.

How to add columns in excel on Windows

How to add columns in excel on Windows. In today’s world, the use of Word has increased so much that any type of work, be it office work or any other kind of work, it cannot be done without Microsoft Office or WPS Office. Our day-to-day work requires us to work smartly by using these two software and this cannot be done if you do not know how to use them. You first need to have a grasp on this software, you need to understand the basics of it. Just like in excel, many people, who....

How to convert text file into excel file in Windows 10

Excel plays a vital role in any financial model and it provides easy ways to work under a lot of functions and programs. This updated excel comes up with much more interesting function and built-in formulas through which mankind save time up to 50% and increase the speed of productivity along with their learning skills. These programs are very easy to use. There are many ways by which we convert text files to excel. Convert text files to excel via the internet. To convert text files to....

How to Compare Excel Files for differences in Windows

Given that an Excel workbook only displays one sheet at a time, comparing two Excel files can be challenging. When there is a large amount of data that has to be compared, this becomes more challenging and error-prone. Thankfully, Excel has some great capabilities that make it simple to open and compare two Excel files. You can compare two excel files or multiple excel files by viewing them side by side. Compare two excel files by viewing them side by side You can compare two excel fil....

How to recover unsaved excel files in windows and mac

All of us have been there. Imagine, you have spent a lot of effort on a document and you thought you were done for the day. But, suddenly you are forced to shut down without saving it, you ran out of the battery, power outage or the application closes on its own. It is a scary feeling. Now your only way out is to try and watch tutorials on how to recover unsaved the excel files. Thankfully, WPS office have backup that you can use to recover unsaved excel files. All these methods to rec....

How to view thumbnail in PDF file in windows 10

1. Use WPS Office to open the PDF file.2. Click the Navigation button at the bottom to pop up the Navigation Pane on the left side of the page.3. Click the View Thumbnail icon.Or we can use the shortcut Alt+Shift+2 to view thumbnail. With WPS PDF, you can read, take annotation, compress, convert PDF to jpg, highlight, search, process & edit pdf documents on Windows, mac pc and android mobiles.