WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • recover deleted sheet in excel workbook

    57 results for recover deleted sheet in excel workbook

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

    57 results for recover deleted sheet in excel workbook

    How to split a workbook into multiple files

    How to split a workbook into multiple files

    01:39

    How to split a workbook into multiple files

    We often need use the Split Book function so that we can split a workbook into multiple files at work. Take this workbook as an example, which is a table of goods sales from January to September. Now we want to split it into three workbook files. 1. Head to the Home tab, click the Split Sheet drop-down button,and select Split Book.2. In the pop-up dialog, the current file is checked by default, and you can also split other files by clicking Add more files.3. When finished, click Next t....

    Spreadsheet views
    How to set a worksheet in WPS Spreadsheet

    How to set a worksheet in WPS Spreadsheet

    03:53

    How to set a worksheet in WPS Spreadsheet

    The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

    Spreadsheet views
    More features in Split and Merge

    More features in Split and Merge

    04:37

    More features in Split and Merge

    In our daily work, we often need to split or merge worksheets.Most people use an easy way of copying and pasting, but it is a waste of time. In Microsoft Excel, we may need plug-ins, VBA or Power Query, etc., to split or merge workbooks.For convenience, WPS Spreadsheets provides the function of splitting and merging workbooks. First, let's learn about the splitting function. WPS Office provides three ways of splitting.· Split Sheets By ContentTake this workbook as an example, which....

    Spreadsheet views
    Set password to protect privacy in WPS spreadsheet

    Set password to protect privacy in WPS spreadsheet

    02:03

    Set password to protect privacy 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. Our spreadsheet can be encrypted to protect privacy. Security in the Options allows us to do so. Take this table as an example. We click Menu and select Options in the drop-down list. A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook" and File sharing options for this workbook. If we want to encrypt....

    Spreadsheet views
    More features in Document Encryption

    More features in Document Encryption

    02:14

    More features in Document Encryption

    Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....

    Spreadsheet views

    How to unlock excel sheet in WPS Spreadsheet

    · Option 1If we have set up password protection:1. Use WPS Office to open the spreadsheet.2. Click the Review tab.3. Click the Unprotect Sheet button.4. In the pop-up Unprotect Sheet dialog box, enter the password you set before, and then click OK. · Option 2 If there is no password protection:1. Use WPS Office to open the spreadsheet.2. Click the Review tab.3. Click the Unprotect Sheet button. Then we can unlock excel sheet in WPS Spreadsheet. To be office excel advanced, you could le....

    Spreadsheet 0.2349 views
    Track changes

    Track changes

    01:30

    Track changes

    Excel worksheets are frequently used for teamwork. We want to record and track the modifications made by each member. Today, we will learn how to use the "Track Changes" function.Take this table as an example, we want to get the revision history of the data.First, go to the "Review" tab, and click "Highlight changes" at "Track Changes."Then, check "Track Changes While Editing" to track the changes in your sheet. By doing so, you can highlight the changes including time, reviser, and r....

    Spreadsheet views
    How to consolidate data in WPS Spreadsheet

    How to consolidate data in WPS Spreadsheet

    01:28

    How to consolidate data in WPS Spreadsheet

    In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

    Spreadsheet 0.1635 views
    Prev 123...78 Next
    WPS Academy
    Products
    Partners