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

        1500 results for autofill excel

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

        1500 results for autofill excel

        Quick Tip: How to Use Autofill in Excel

        How to use autofill in excel online, 2016 and 2019: To automatically fill a set of cells in Excel, use AutoFill. Numerous simple to follow AutoFill examples may be found on this page. There are no boundaries! For instance, enter the numbers 10 in cell A1 and 20 in cell A2. Drag the fill handle downward while selecting cells A1 and A2. The small green box in the lower right corner of a selected cell or range of selected cells is the fill handle. Note: Based on the pattern of the first t....

        xls Spreadsheet 12.3K views
        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
        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
        Combine the SUBSTITUTE and LEN functions

        Combine the SUBSTITUTE and LEN functions

        02:57

        Combine the SUBSTITUTE and LEN functions

        Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

        Spreadsheet 12.2K views
        How to display the obscured table text in WPS Writer

        How to display the obscured table text in WPS Writer

        01:56

        How to display the obscured table text in WPS Writer

        When a table is inserted in a word document, the text in the table may not display completely. Do you know how to fix it? l Case 1: Table exceeds page sizeWhen we copy the table in other platforms to insert it into the document, and the table exceeds the page width, the text on the right of the table will be incomplete.In most cases, we can use the mouse to slowly drag the box line to adjust to the appropriate position, which is too troublesome.Here is a practical trick helping you ad....

        Writer 7.4K views
        INDEX MATCH formulas

        INDEX MATCH formulas

        02:11

        INDEX MATCH formulas

        In the previous videos, we've learned about the usages of INDEX and MATCH formulas, respectively.The INDEX function can return a value in a cell regarding its column and row number in an array. Combining the INDEX MATCH formulas makes it flexible in value lookup. We can break the limitations of VLOOKUP and realize the reverse lookup. Here is a form recording the personal information of staff. How can we look up the 'Number' of a corresponding staff? We can run the INDEX MAT....

        Spreadsheet 9.7K views

        How to make excel cells expand to fit text automatically in excel

        How To Make Excel Cells Expand To Fit Text Automatically-WPS Academy In the recent years, excel has become the most emerging and powerful software program. Excel serves as a unique and powerful platform for storing and analyzing data. It is the most significant tool in today’s digital world used by the people belonging to any field. However, to access the features of excel one should have a proper knowledge about them. Most of the excel features are compatible for 2016/2019/mac/online ....

        xls Spreadsheet 15.8K views

        How to create custom number format with text in Excel

        How to Custom cell format number with text in Excel with Multiple Methods -WPS Academy: We'll employ various distinct methods to add text and numbers to a cell format in the sections that follow. We'll start by using the Format Cells box. Formulas, the CONCATENATE function, and the TEXT function will all be used later. To help you comprehend the goal of our job, an example data set is supplied. In Excel, use the Formal Cells Box to create custom numbers with text: The steps b....

        xls Spreadsheet 15.2K views
        Prev 1 2 3 ... 187 188 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