WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • create drop down list in excel

    430 results for create drop down list in excel

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

    430 results for create drop down list in excel

    How can we create a drop-down list

    How can we create a drop-down list

    01:33

    How can we create a drop-down list

    How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....

    Spreadsheet 0.1846 views
    How to sort with a custom list

    How to sort with a custom list

    01:36

    How to sort with a custom list

    How can we sort the table with a custom list when designing a report? Today, we will learn how to create a custom list for sorting.For example, we want to sort this table by position. Click Custom Sort in the Data tab to pop up a dialog.By default, the system sorts letters and integers in ascending or descending order on their values.Click the drop-down list at Order and select Custom Lists.Custom lists on the left tell the built-in sorting rules. We can customize the sorting rules at ....

    Spreadsheet views
    Use VLOOKUP function to create dynamic charts

    Use VLOOKUP function to create dynamic charts

    03:44

    Use VLOOKUP function to create dynamic charts

    In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....

    Spreadsheet views
    Set password to protect privacy in WPS spreadsheet

    Set password to protect privacy in WPS spreadsheet

    02:03

    Set password to protect privacy in WPS spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Our spreadsheet can be encrypted to protect privacy. Security in the Options allows us to do so. Take this table as an example. We click Menu and select Options in the drop-down list. A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook" and File sharing options for this workbook. If we want to encrypt....

    Spreadsheet views
    How to customize draw borders for tables

    How to customize draw borders for tables

    01:19

    How to customize draw borders for tables

    When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

    Spreadsheet 0.3937 views
    Quickly filter classified data

    Quickly filter classified data

    01:41

    Quickly filter classified data

    How to quickly extract data of a certain category from a large amount of data? The filtering feature of WPS Office can help us to do it quickly. Take this table as an example. How are we going to filter out the data of New York? 1. Select any cell in the list.2. Click the Home tab.3. Click the AutoFilter drop-down button or use the shortcut key CTRL+Shift+L to set. Then the data list will enter the filtering state. 4. Click the gray inverted triangle arrow in the header cell of Branch,....

    Spreadsheet 0.2526 views
    Use Validation to restrict data change

    Use Validation to restrict data change

    02:24

    Use Validation to restrict data change

    We want to lock the cells after checking the table data and prevent it from being further changed. What can we do?In today's tutorial, you will learn how to use the Validation function to restrict data change.Step one, select the E column, and then add a drop-down list named checked.Click Validation at Data, and you can also use the shortcut Alt+D+L.In the Setting tab, select List at Allow, and enter checked at Source. Finally, click OK.By doing so, we can select checked in the dro....

    Spreadsheet views

    How to create a dropdown list in WPS Spreadsheets

    When using WPS Spreadsheets to process a spreadsheet with a large number of data to fill in, creating a dropdown list in the target cells is able to boost our working efficiency, since we can choose one of the options from the dropdown list to fill the target cells rather than typing the contents word by word. An example of cells with a dropdown list is shown below. How can we realize it? An example of cells with a dropdown list inserted · Option 1: 1. Select the cell range to insert d....

    Spreadsheet 0.2091 views
    Prev 123...5354 Next
    WPS Academy
    Products
    Partners