WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how do i freeze the top 2 rows in excel

    101 results for how do i freeze the top 2 rows in excel

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

    101 results for how do i freeze the top 2 rows in excel

    How can we freeze the pane in WPS Spreadsheet

    How can we freeze the pane in WPS Spreadsheet

    02:28

    How can we freeze the pane in WPS Spreadsheet

    When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....

    Spreadsheet 0.1769 views
    Insert a table into the text & convert between text and table

    Insert a table into the text & convert between text and table

    02:48

    Insert a table into the text & convert between text and table

    When we use WPS Document at work, we often need to create a table in order to make the document more organized. But how are we going to make it? Take this blank document as an example. Click the upper tab Insert-Table. We can choose the corresponding number of rows and columns according to actual needs.For instance, if I want to make a table with 2 rows and 8 columns, just select 2*8 in the table area and click the left mouse button. You can also click Insert-Table-Insert Table. Then ....

    Writer views
    SUBTOTAL function: Calculate the data with the hidden value

    SUBTOTAL function: Calculate the data with the hidden value

    02:33

    SUBTOTAL function: Calculate the data with the hidden value

    Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

    Spreadsheet 0.1546 views
    Page setup and print-out for spreadsheets

    Page setup and print-out for spreadsheets

    02:07

    Page setup and print-out for spreadsheets

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables and more. Includes advanced animation, slide transitions, and support for video, images, audio and even Flash.In the last chapter, we focus on the contents related to the page setting and printout of spreadsheets, and we often encounter various problems when printing, among which four FAQs will be introduced here. · 1: My form is incomplete. What can I do?Click the ....

    Spreadsheet views
    Custom sorting in WPS Spreadsheet

    Custom sorting in WPS Spreadsheet

    02:14

    Custom sorting in WPS Spreadsheet

    We often need to sort the data to organize the table in our work, so how can we sort the data in a table? Take this table as an example. We want to sort the Overall result of this table from largest to smallest.1. Select the cell range in the Overall result column, and click the Home tab, then click the Sort drop-down button.2. Select Descending in the drop-down menu, and then select these two options Expand the selection and Continue with the current selection in the pop-up Sort Warni....

    Spreadsheet 0.2482 views
    Use the Today function to quickly calculate days between dates

    Use the Today function to quickly calculate days between dates

    01:57

    Use the Today function to quickly calculate days between dates

    In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....

    Spreadsheet 0.1814 views
    WPS Spreadsheet basic editing

    WPS Spreadsheet basic editing

    02:12

    WPS Spreadsheet basic editing

    This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....

    Spreadsheet 0.1024 views
    Learn pivot table from the beginning

    Learn pivot table from the beginning

    04:27

    Learn pivot table from the beginning

    A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....

    Spreadsheet 0.4978 views
    Prev 123...1213 Next
    WPS Academy
    Products
    Partners