WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to keep first row visible in excel

    2640 results for how to keep first row visible in excel

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

    2640 results for how to keep first row visible in excel

    Use format painter to adjust the styles in batches

    Use format painter to adjust the styles in batches

    01:28

    Use format painter to adjust the styles in batches

    Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency. Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painter button, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells. Then how....

    Spreadsheet 3.5K views

    How to insert a row in excel

    Main keyword: to insert a row in excel How to insert a row in excel quickly? If you need to work your charts in Excel and you haven't been able to because you don't know how to insert a row in excel. Do not worry because you will be able to know the necessary steps to learn everything related to how to insert several rows and complete your work with the greatest success. Inserting a row in excel allows you to make your tables more complete, and you can add all the content you....

    xls Spreadsheet 1.2K views

    How to insert row shortcut in excel

    Main keyword: excel insert row shortcut. Excel insert row shortcut to get your jobs done much faster Excel has become one of the most used programs worldwide since it allows you to organize tasks. People who use Excel are surely looking for a guide to provide more information on certain techniques. It is fair that you learn everything about Excel, in this way your work will be in perfect condition. Today you have the opportunity to learn and excel insert row shortcut and thus add rows ....

    xls Spreadsheet 2.4K 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 6.3K views

    How to add a row in excel using shortcut

    How to add a row in Excel? How to add a row in excel? Excel is a program that offers you many features to create and edit professional spreadsheets. It allows you to add new rows to the sheet, making the steps simple and fast. If you notice a row skipped, you can add it at any time. Below you will get to know 3 methods of how to add a row in excel. How to add a row in excel quickly? 1. The first step of how to add a row in excel 2016 is to locate the Excel file. Double click the file t....

    xls Spreadsheet 856 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 2.6K views

    How to change row height in excel

    If you are looking to change the row height in Excel, there are a few different ways that you can go about it. One way is to use the ribbon, while another is to use the VBA code. Another method is to just use the key combination. Ways to Change Row Hight in Excel on Mac online. There are a few ways to change the row height in Excel. One way is to use the shortcut key (Ctrl+left arrow or Ctrl+right arrow). Another way is to use the menu option (File > Options > Cells and Lines). The th....

    xls Spreadsheet 1.6K views

    How to Add Total Row in Excel (3 Easy Methods)

    3 easy methods to learn how to add total row in excel If you want to learn how to add a total row in excel, you should know that you will first need to create a table with the data. A total row in Excel will give you a quick overview of different columns in a table. Here are 3 primary methods you can use to learn how to add total row in excel. How to add total row in excel using the table design tab? To learn how to add total row in excel 2016 using the table layout, you will need to p....

    xls Spreadsheet 5.3K views
    Prev 1 2 3 ... 329 330 Next
    WPS Academy
    Products
    Partners