The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore. Take this table as an example. Assume that we want to count how many Expense there are in the whole table. We can use the COUNT function to count the number of data in the table.Tips: The COUNT function in WPS can only be applied in counting number data, while the empty cells, logical value....

The function of Tabs in WPS Writer allows us to adjust the position of the text when typing by setting the horizontal Ruler, in order to align the text and symbols. And, it could be also used in Microsoft Office Word and Openoffice. How can we use the function of Tabs? If the ruler is not displayed in the document, we can click the View tab and check Ruler. The number on the Ruler represents the number of characters, and the page width on the current page is 41 characters width. Take t....

Are you still struggling to create a hierarchy like this one when you use WPS Presentation to make the company's annual report? Next, let's learn how to quickly create a hierarchy. Click the Insert tab and the WPSArt button to pop up the Insert WPSArt Dialog pane. Here, we can see the different types of Hierarchy. Click the graphic, and the corresponding application scenario description will be displayed on the right side.Click Hierarchy, and select one of the styles, finally c....

Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....

Many people don't know how to take screenshots when using WPS Writer. Let's take a look at how to use the WPS screenshot tool. First, click the Insert tab to find the Screenshot button. And in the Screenshot drop-down list, we can choose the screenshots of areas with different shapes. They are respectively: Rectangle screenshot, Oval screenshot, Rounded rectangle screenshot and Polygon screenshot. We can click Screenshot to take a screenshot within the WPS Writer interface. Its....

WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Slide Master can be the perfect fit for improving work productivity to uniform the fonts, background, and company logos when creating new slides. Without using Slide Master, every click with New Slide means creating a new blank slide with non-uniform formats. With the Slide Master function, we only need to set the background and font of ....