More features in Screenshot

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

Text direction in WPS Presentation

When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....

More features in Screenshot

Both WPS Writer and Microsoft Word have the function of the screenshot. What are the differences between them? In Microsoft Word, two methods are available. One is Available Windows, which means to capture the opened windows on our desktop; the other is Screen Clipping. We need to capture the screen by manually adjusting its size in this mode, and only the area outside the Excel document is available. In WPS Writer, we can enter the Insert tab and click the Screenshot drop-down button.....

How to convert Excel to PDF

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

Text to Columns: Sort data quickly

When creating tables, we sometimes need to import data from outside, and this data often requires secondary classification processing. We now want to classify the data in the table into Name, Age and Telephone. So how can we do that?1. We select column A, click the Data tab.2. Click the Text to Columns drop-down button. 3. Then select the Text to Columns option in the drop-down menu.In the popup dialog box, we can see two options.+One is Delimited. Here, we can use symbols as the basis....

TEXT formula in WPS Spreadsheet

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

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