WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to number pages in excel

    892 results for how to number pages in excel

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    892 results for how to number pages in excel

    How to apply accounting number format in WPS Spreadsheet

    How to apply accounting number format in WPS Spreadsheet

    00:56

    How to apply accounting number format in WPS Spreadsheet

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

    Spreadsheet views
    How to delete blank pages quickly

    How to delete blank pages quickly

    03:14

    How to delete blank pages quickly

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

    Writer views
    How to insert or delete pages in a PDF file

    How to insert or delete pages in a PDF file

    01:19

    How to insert or delete pages in a PDF file

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

    PDF views
    How to enter a number starting with 0 in the Spreadsheet

    How to enter a number starting with 0 in the Spreadsheet

    01:38

    How to enter a number starting with 0 in the Spreadsheet

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

    Spreadsheet views
    How to insert blank pages

    How to insert blank pages

    00:38

    How to insert blank pages

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

    Writer 0.1232 views
    How to set header and footer in odd and even pages respectively

    How to set header and footer in odd and even pages respectively

    03:08

    How to set header and footer in odd and even pages respectively

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

    Writer views
    How to set the header row across pages

    How to set the header row across pages

    00:50

    How to set the header row across pages

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

    Writer views
    How to convert Excel to PDF

    How to convert Excel to PDF

    02:50

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

    Spreadsheet views
    Prev 123...111112 Next
    WPS Academy
    Products
    Partners