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

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

How can we insert or delete pages of the original file when editing a PDF file?Take this file as an example. Click the Page tab, then click the Insert Pages drop-down menu. Here, we can choose to insert a Blank page. Its shortcut key is Ctrl+Alt+I.In the popup dialog box, we can set the size, direction, number, and insertion position of the new page. Click OK to insert a blank page.We can also create a new page from the file by Select from PDF. Its shortcut key is Ctrl+Alt+T.After sel....

Are you confused about the blank pages between pages in a document? And you only press the Backspace key repeatedly to delete them, and you fail sometimes.So how can we delete blank pages quickly? Here I'll introduce three methods to you. Tips: Before deleting the blank pages, we can show paragraph marks first to know why these blank pages were generated. Head to the Home tab, click the Show/Hide Editing Marks drop-down button and check Show/Hide Paragraph Marks.· Delete paragraph ....

What can we do if we want to set the header and footer in odd and even pages respectively? Take this article as an example. Double-click the header of the home page, and click the Header and Footer Options in the Header/Footer tab, then you will see a pop-up dialog box. l Page different settings 1.Check Different first page in the Page different settings to set the header and footer of the first page separately. 2.Check Different odd and even pages to set the header and footer of odd....

After editing the document, we sometimes may want to insert a blank page in the middle to supplement related content. So how can we do that? After clicking the page, click the Blank Page drop-down button in the Insert tab. Here, we can choose Vertical Text Box or Horizontal Text Box.GIf If we want to delete a blank page, place the mouse on the blank page. Now hold down the Backspace key, and press the Delete key to delete the blank page.GIf This skill could be compatible with Microsoft....

When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

When projecting slides with WPS Presentation, we sometimes hide some of the slides for better projection effect.The hidden slides cannot be projected or printed. So how can we print them without changing their hidden state?Take this slide as an example. In the thumbnail on the left of the screen, you can see a small delete icon at the slide page number, indicating the slide is hidden.You need to click the Menu button in the upper-left corner and click Print.Click the check box Use the ....