WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        1515 results for excel sequence

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

        1515 results for excel sequence

        How to convert Excel to PDF

        How to convert Excel to PDF

        02:50

        How to convert Excel to PDF

        PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

        Spreadsheet 30.2K views
        Fill handle: Use Ctrl+D to fill

        Fill handle: Use Ctrl+D to fill

        01:07

        Fill handle: Use Ctrl+D to fill

        We sometimes need to deal with tables containing various content. Then we may find it troublesome even to use the fill handle to pull down and fill. Here, we will introduce two convenient methods to you. The first method is to double-click the fill handle. After filling the first data in column A, double-click the fill handle, then the data will be automatically filled in sequence order. Now we can see the data has been filled automatically in the row range of column B. In the digital ....

        Spreadsheet 7.4K views
        Use the fill handle to quickly enter data

        Use the fill handle to quickly enter data

        02:59

        Use the fill handle to quickly enter data

        AutoFill can help us quickly enter some regular data, which is an essential skill in using WPS Spreadsheet to deal with different data. It includes Fill Numerical Value, Fills Data, Fill Text, Custom Text Filling, and Fill Formulas.Take this table as an example. If we want to fill in the numbers 1 to 10 in column A, select cell A2 and move the cursor to the lower right corner of cell A2. At this time, the cursor will turn into a small black solid cross. Press and hold the left mouse bu....

        Spreadsheet 15.7K 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 40.1K views
        How to customize text shortcut keys

        How to customize text shortcut keys

        01:33

        How to customize text shortcut keys

        We can process and edit documents more quickly by flexibly using shortcut keys.Then, how can we customize shortcut keys in WPS Office? First, click Menu and Options to enter the Customize Ribbon interface.You can see Keyboard shortcuts in the lower-left corner. Click Customize to take you to the custom settings dialog. Take Insert Picture as an example. Head to the Insert tab in the left categories, and then find Insert Picture in the corresponding commands on the right.You can see th....

        Writer 13.4K views
        Quickly replace the content and font in WPS Presentation

        Quickly replace the content and font in WPS Presentation

        01:40

        Quickly replace the content and font in WPS Presentation

        When using WPS Presentation, we want to make changes to the specified content or font of the text. Take this slide as an example. If we want to quickly replace WPS in the text with WPS Office,Click the Home tab, then click the Replace drop-down button and choose Replace.Or use the shortcut key Ctrl+H.In the pop-up dialog box, enter WPS in the edit box. We can also set the replacement conditions as needed, such as Match case and Find whole words only.In the Find what box, enter WPS. Whi....

        Presentation 14.7K views
        Use SUMIFS function with multiple criteria

        Use SUMIFS function with multiple criteria

        02:27

        Use SUMIFS function with multiple criteria

        In our work, we often need to filter through multiple criteria for statistics. At this time, we can use the SUMIFS function. The grammatical structure of the SUMIFS function is: “SUMIFS(Sum range, Range1, Criteria 1, Range2, Criteria2...)”Using the data in this table as an example, we want to calculate The total amount of imported fruits from South Korea greater than $50,000. There are two conditions. One is South Korea, and the other is the amount>$50,000.First, after clicking cell E5....

        Spreadsheet 21.5K views
        Quickly fill cells with multiple methods

        Quickly fill cells with multiple methods

        04:07

        Quickly fill cells with multiple methods

        As for beginners, they usually enter data manually when they first use Spreadsheet. It is time-consuming and also easy to cause mistakes. So today we are going to learn a few tips to help you quickly fill in the data in the worksheet.· Fill contents down into the tableTake this table as an example, select the area that needs to be filled, first click the Home tab, then click the Fill button-and then select Fill down. (Notes: The shortcut key is Ctrl+D.) · Fill contents right into the t....

        Spreadsheet 17.3K views
        Prev 1 2 3 ... 189 190 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube