WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • freeze a row in excel

    316 results for freeze a row in excel

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

    316 results for freeze a row 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

    How to highlight every other row in Excel?

    When dealing with an Excel document with huge amounts of data, we may find it difficult to differentiate one row from another.At this point, highlighting alternate rows has been proven to make your data more readable and easier on the eyes. Here are the steps. 1. Select the desired cell range. Click the Home tab > Conditional formatting > New Rule to pop up a dialog. 2. In the Select a Rule Type area, select Use a formula to determine which cells to format. 3. Input the formula "=MOD(....

    Spreadsheet views
    How to set the header row across pages

    How to set the header row across pages

    00:50

    How to set the header row across pages

    When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

    Writer views
    Rows and columns tools in WPS Spreadsheet

    Rows and columns tools in WPS Spreadsheet

    02:34

    Rows and columns tools in WPS Spreadsheet

    Today, we are going to show you the usage of the Rows and Columns tool in the WPS Spreadsheet. This tool can help us set the rows and columns of cells and make our work easier with WPS Spreadsheet like Microsoft Excel. Take this table as an example. We need to adjust the row height and column width of the current table.1. Select all tables, click the Home tab, and click Rows and Columns. Select AutoFit Row Height and AutoFit Columns Width. The WPS Spreadsheet will automatically adjust ....

    Spreadsheet 0.1945 views
    Quickly adjust the row height and column width

    Quickly adjust the row height and column width

    01:36

    Quickly adjust the row height and column width

    Adjusting the row height and column width is a necessary skill for the layout of the table content. So, how can we adjust the row height and column width? The easiest way to adjust the row height and column width is to position the mouse on the dividing line of the row number and column label and drag the dividing line to adjust the row height and column width. We will find that using this method is difficult to completely unify the row height and column width in the table, and the ope....

    Spreadsheet views
    General format and special format

    General format and special format

    01:27

    General format and special format

    When we use WPS Spreadsheet to enter data, we often need to convert between the general and the special format. So let's take a look at what is the general format of cells, what is the difference between them, and how we can convert them. Take this table as an example. The cell contents in the first row of this table are all in the General format. The General format means that the contents of the cells are simply expressed in numerical form. The second row of the table is in a spec....

    Spreadsheet 0.1859 views
    Add blank rows in an individual table

    Add blank rows in an individual table

    01:02

    Add blank rows in an individual table

    Sometimes there are several tables in one worksheet, and we want to add blank rows in one of the tables. How can we solve it? Take this worksheet as an example. Suppose we need to add a blank row in the left table. At this time, if we use the frequently used method, which is to select the desired range and right-click to insert a blank row, we can find that a blank row is also inserted in another table. Thus, we need to use another method to insert the blank row.Firstly, select the loc....

    Spreadsheet views
    Table rows, columns, cells, and status bar

    Table rows, columns, cells, and status bar

    03:27

    Table rows, columns, cells, and status bar

    In the last video, we just talked about the worksheet and workbook in the WPS Spreadsheet. So in this video, we will learn about the Spreadsheet interface elements: rows, columns, cells, and those tools in the lower status bar.On the left is the row, and the marked numbers 1, 2, and 3 are called the row number. Above is the column, and the marked numbers A, B, and C are called the column number. The grids in the middle are called cells.When expressing the position of a cell, we use col....

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