WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to freeze first two rows in excel

    438 results for how to freeze first two rows in excel

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

    438 results for how to freeze first two rows in excel

    How to delete blank rows of table in batches

    How to delete blank rows of table in batches

    00:51

    How to delete blank rows of table in batches

    When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once? We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, ....

    Spreadsheet views
    How to view two documents side by side in WPS Writer

    How to view two documents side by side in WPS Writer

    00:54

    How to view two documents side by side in WPS Writer

    No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Do you still jump back and forth between two documents when you need to compare the revision between them? At this time, we can place the two documents in the same interface with the help of View Side by Side. Let's take these two documents as an example, one is the original document, and the other is the revised document. Open either of thes....

    Writer views
    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

    Compare two sheets for duplicate rows in WPS Office Excel

    Welcome to WPS Official Academy to check the contents of how to compare two excel spreadsheets for duplicate rows. It would be a waste of time to search for duplicate rows by comparing each two rows manually. WPS Office provides a function of Highlight Duplicates to help you compare two sheets for duplicate rows quickly. Let’s have a try step by step. Here we take two lists of participants as examples. We want to find out the participants who have participated in both conferences by hi....

    Spreadsheet views
    Use data check method to quickly find difference items

    Use data check method to quickly find difference items

    01:40

    Use data check method to quickly find difference items

    Are you still checking table data one by one? Here are two practical methods that can help us find data difference items quickly. Take this table as an example. How can we do it, if we want to quickly find out the data difference items in the rows from Database1 to Database4? First, we select the cell range, then click the Home tab, and click the Find and Replace drop-down button. Select the Go To option under the drop-down menu, or we can also use the shortcut key Ctrl+G to open the d....

    Spreadsheet views

    How to unhide rows in excel

    When using WPS Spreadsheet to process data, the Hidden Row function can hide the data temporarily not in need. The double line presents in between two columns means one/several column(s) has/have been hidden. For instance, Column B is hidden in the following screenshot. How can we show the hidden rows again in excel?1. Select Columns A to C.2. Right-click on it, and choose Unhide. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

    Spreadsheet 0.1578 views

    How to hide rows in excel

    · Hide a single row1. Right-click on the target row for operation.2. Choose Hide from the pop-up list. · Hide rows within a continuous range range1. Right-click to select a continuous row range.2. Choose Hide from the pop-up list. · Hide multiple row selections 1. Long-press Ctrl on the keyboard, while using the mouse to left-click the rows for operations.2. Right-click on the last row(s) selected, and choose Hide from the list. To be office excel advanced, you could learn how to use....

    Spreadsheet views

    How to freeze panes in WPS Spreadsheet

    We can freeze the panes in three different ways.· Freeze to1. Select the cell below the rows and to the right of the columns that we want to freeze when scrolling.2. Click the Home tab → and then click the Freeze Panes button.3. Now click the first option in this drop down menu. · Freeze First Row1. Use WPS Office to open the form and click the Home tab → and then click the Freeze Panes button.2. Now click Freeze First Row.Then we can easily freeze the first row of this table. · Freeze....

    Spreadsheet 0.233 views
    Prev 123...5455 Next
    WPS Academy
    Products
    Partners