WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to recover overwritten excel file in windows 8

    94 results for how to recover overwritten excel file in windows 8

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

    94 results for how to recover overwritten excel file in windows 8

    How to view two sheets side by side

    How to view two sheets side by side

    01:09

    How to view two sheets side by side

    When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

    Spreadsheet views
    Use the Mail Merge function to input tabular data quickly

    Use the Mail Merge function to input tabular data quickly

    01:49

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

    Writer views
    How to merge and split PDF files

    How to merge and split PDF files

    01:25

    How to merge and split PDF files

    WPS PDF could help edit PDF files and freely convert between PDF and Word, Excel, PowerPoint, and JPG files online. When editing PDF files, we often need to merge multiple PDF files or split a PDF file. So how can we do that?· Merge PagesTake this file as an example. When we need to merge multiple PDF files into one, click the Page tab, then click Merge Page. Now the WPS PDF to Word Converter dialog box will pop up. Click the Add files button in the upper right corner and select other ....

    PDF 0.1179 views
    Text direction in WPS Presentation

    Text direction in WPS Presentation

    02:34

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

    Presentation 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
    The Graffiti function used to mark in PDF

    The Graffiti function used to mark in PDF

    01:41

    The Graffiti function used to mark in PDF

    Do you know how to draw on a PDF file? Let's try the "Graffiti" function! It can make your notes on PDF more fancy. Open the PDF in WPS Office. Get into the "Comment" tab, and click "Graffiti". In its dropdown list, we can access quick settings of the ink mark, including line colour, opacity, and line width. We can also use the shortcut keys "Alt+R" to open the settings window.Supposed that you need to mark continuous content, follow these few steps. Click "Draw curve". Then, choos....

    PDF views
    How to use the MID function in WPS Spreadsheet

    How to use the MID function in WPS Spreadsheet

    01:54

    How to use the MID function in WPS Spreadsheet

    When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

    Spreadsheet views
    Why error message #REF! occurs and how to solve it

    Why error message #REF! occurs and how to solve it

    03:18

    Why error message #REF! occurs and how to solve it

    The error message "#REF" is common in table calculations. In general, there are mainly two causes. First, the referenced cells in the formula are deleted or replaced by other cells. Second, the formula references invalid cell ranges or values. Then how can we solve these problems? · The referenced cells in the formula are deleted or replaced by other cells.o The referenced cells in the formula are deleted.Take this table as an example. 1. To calculate the total sales of computers t....

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