Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....

Both WPS Spreadsheets and Microsoft Excel have the function of a screenshot. What are the differences between them? In Microsoft, we can click the Screenshot drop-down button and select one of the Available Windows to take a screenshot. Click Screen Clipping to capture the screen by adjusting its size manually, and only the area outside the Excel document is available. In WPS Spreadsheets, we have two ways of screenshot for your selection.Option 11. Click the Insert tab, click the Scre....

The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

If you want to save multiple pictures in a table, a common practice is to save them one by one. It will be very troublesome when there are a large number of pictures. Today, we will learn a quick tip to export pictures in batches. Taking this table as an example, we can see that there are many pictures in the table. First, change the suffix name of this table file in accordance with the suffix of the zip file. Here, we change the .xlsx format to .rar format and then decompress the file....

The filter function is often used in data processing, but only when the data is vertically arranged. Today we will filter data horizontally using two ways.· 1. Transpose dataTake this table as an example. To filter the sales of all categories, we need to select and copy the entire table with Ctrl+C and then right-click Transpose at Paste Special. By doing so, the table is transformed into a vertically-oriented table. Go to the Home tab, and click AutoFilter to get the sales of all cat....

Do you know how to split your worksheet?Take this table as an example. Seeing the sales performance from January to July, we need to split the monthly sales into individual workbooks and send them to the leader. It is too cumbersome to copy and paste the data one by one and generate new files. Fortunately, we can use the function of Split Books by Sheet. In this table, we click the Data tab, then click the Split Sheet drop-down button, and select Split Books By Sheet in the drop-down m....

Sometimes we don't want to enter duplicate information from the collected data. We will take the unique telephone number as an example to show how to use the Validation function to prevent duplicate values.Select this column, and click Validation at Data, you can also use the shortcut Alt+D+L. Head to the Setting tab, click the Allow drop-down button and select Custom, and enter countif(D:D,D1)=1.This formula will make the value in cell D1 only appears once in column D; otherwise, ....

When processing a table, we may find that some information contains parentheses, but it'd be troublesome to delete them one by one. Today, we're going to learn the skill to delete these parentheses and the content inside quickly. Take this table as an example. There are parentheses following the actors' names, and we want to delete these parentheses and the nationality inside. 1. Select the cell range which contains the parentheses and press Ctrl+H to pop up the Replace di....