More features in Document Encryption

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

Unique Features in File Collect

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. In the workplace, collecting all kinds of documents is frequently needed. At this time, a file folder is always wanted to collect what we need by sending a sharing link to others At present, such a function is not available in other office software on the market. Fortunately, WPS launched the File Collect feature for a more efficient office experience. ....

Use the Mail Merge function to input tabular data quickly

WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....

Set the page printing area in WPS Office Spreadsheet

What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

Print page setup in WPS Spreadsheet

When we need to print a table, if we are not satisfied with the effect of the currently displayed page, how can we quickly set up the page? Take this table as an example. Click Print Preview in the quick access toolbar to enter the print preview interface. Click the Page Setup button, then the Page Setup dialog box will pop up. In the Page tab, we can adjust the Orientation and Scaling of the page and the related settings of the printer. In the Margins tab, we can precisely adjust the....

More features in Split or Merge

WPS Writer is easy to use as Microsoft Word. WPS and Microsoft Word both have the Split and Merge function, but what is the difference between them? We will use the same document to compare. For Microsoft Word, if we want to merge the file, head to the Insert tab, click the drop-down list at Object, select Text from File. Then select the files to be merged, and click OK.This method merges the whole document by default, and the scope of merging cannot be selected. If we want to split do....

How to set page borders in WPS Writer

When adjusting the page layout of a word document, we can add page borders and change their styles. In this example, if we want to insert page borders of the palm tree style, how can we realize it? First, click the Page Layout tab, and choose Page Borders to pop up the Borders and Shading window. Here we can access the settings of the page borders, including style, color, and width. We can see the page border of palm trees in the category of Art. In the Preview interface, we can choose....

More features in Picture to Text

Both WPS Writer and Microsoft Word have the function of Converting pictures to text. What are the differences between them? Microsoft Word itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, "OneNote."1. Copy the picture to OneNote, and right-click it to select Copy Text from Picture.2. Finally, paste the text into PowerPoint or Word as needed. In WPS Writer, it is much more convenient to do the conversion in the docum....