WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how many tabs are in a sheet

    2575 results for how many tabs are in a sheet

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

    2575 results for how many tabs are in a sheet

    How to duplicate a sheet in WPS Spreadsheet

    · Option 1:1. Use WPS Office to open the sheet.2. Click the title area of the sheet below, right-click and select Duplicate Sheet. · Option 2:1. Use WPS Office to open the sheet.2. While pressing the Ctrl key, click the left mouse button to drag the sheet to the desired position. Then, we can complete the copy of the sheet. · Option 3:1. Use WPS Office to open the sheet.2. Click the title area of the sheet below, right-click and select Move Sheet.3. In the pop-up dialog, choose Move t....

    xls Spreadsheet 5.7K views

    How to paste data as a picture in a sheet

    1. Copy a cell range (Ctrl + C).2. Click the Paste dropdown button → choose Paste as Picture. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes more than 100 built-in formulas, pivot tables, etc.

    xls Spreadsheet 3.5K views

    How to split columns in a sheet

    1. Select the target range in WPS Spreadsheet. 2. Click Data → Text to Columns3. Choose Delimited in the interface of Convert Text to Columns Wizard - Step 1 of 3”4. In the interface of “Convert Text to Columns Wizard - Step 2 of 3”, select the delimiters in terms of your demands. 5. Click Finish in the interface of “Convert Text to Columns Wizard - Step 2 of 3”. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

    xls Spreadsheet 7.9K views
    How to set header and footer in WPS Presentation

    How to set header and footer in WPS Presentation

    02:26

    How to set header and footer in WPS Presentation

    When using WPS Presentation, we sometimes add a header and/or a footer to make the slides look more professional. How can we realize it? In this example, get into the Insert tab, and click the Header and Footer button. Then, we will see the two tabs of Slide and the Notes and Handout in the Header/Footer dialog. · The Slide tabHere we can insert the date and time, footer, and page number in the footer, which are respectively positioned in the bottom-left, -middle, and -right areas of t....

    Presentation 11.3K views
    Unique features in Student Tools

    Unique features in Student Tools

    01:42

    Unique features in Student Tools

    Student Tools is a collection of functions in WPS Presentation specially optimized for student user groups, which is not available in any other office software on the market. Student Tools, on the far right of the toolbar, collects the features that students use most frequently to save their time to toggle back and forth between the tabs. There are three common views and two common masters collected from the View tab, which can meet the needs of most reading, reviewing and presentatio....

    Presentation 1.2K views
    How to print a table

    How to print a table

    12:23

    How to print a table

    This lesson summarizes the printing problems commonly encountered in the workplace1. How to make the printer obedient, forms are printed on a sheet of paper2. How to select the designated printing area3. When the form file is very long, how to set each page has a title line4. how to set the header and footer, so that your document more professional

    Spreadsheet 1.7K views
    The Camera in WPS Spreadsheet

    The Camera in WPS Spreadsheet

    01:44

    The Camera in WPS Spreadsheet

    Today we will get to know the Camera in WPS Spreadsheet. With this feature, we can convert the table into a picture, and the contents of the picture will change as those of the table. Here are two sheets: Itinerary and Tour Route Planning Table. To make it convenient for comparison, we would like to place them side by side. Most people may choose to copy the data of the Tour Route Planning Table sheet and paste it into the Itinerary sheet. However, this is not a perfect way. First, we....

    Spreadsheet 1.4K 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 1.5K views
    Prev 1 2 3 ... 321 322 Next
    WPS Academy
    Products
    Partners