Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • insert drop down list in excel

      464 results for insert drop down list in excel

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

      464 results for insert 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 1,846 views
      How to insert shapes in WPS Presentation

      How to insert shapes in WPS Presentation

      02:04

      How to insert shapes in WPS Presentation

      Shapes inserted in slides could make a presentation more attractive. How can we insert shapes in a presentation document? First, click the Insert tab, and click the Shapes button. In the selection list, we can see that there are different categories, namely Lines, Rectangles, and Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners, Callouts, and an Action button. Here we take the shape of Heart, which could be found in the Basic Shapes drop-down list. Insert it by....

      Presentation 271 views
      How to add a cover page in WPS Writer

      How to add a cover page in WPS Writer

      00:47

      How to add a cover page in WPS Writer

      WPS Writer is a terrific tool for adding a cover to your resume or report if you want them to have a great impression on others. How can we add a cover page to a document?We can turn to Cover Pages in the Section tab or click Cover Pages in the Insert tab. Click the Cover Pages button in the drop-down list, and we can see that there are different kinds of covers to choose from, including Business, Resume, Thesis and Transverse. After selecting the cover page, we can change the build-i....

      Writer 160 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 6 views
      How to use the screenshot tool in WPS Writer

      How to use the screenshot tool in WPS Writer

      01:29

      How to use the screenshot tool in WPS Writer

      Many people don't know how to take screenshots when using WPS Writer. Let's take a look at how to use the WPS screenshot tool. First, click the Insert tab to find the Screenshot button. And in the Screenshot drop-down list, we can choose the screenshots of areas with different shapes. They are respectively: Rectangle screenshot, Oval screenshot, Rounded rectangle screenshot and Polygon screenshot. We can click Screenshot to take a screenshot within the WPS Writer interface. Its....

      Writer 195 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 2,526 views
      More features in Screenshot

      More features in Screenshot

      01:56

      More features in Screenshot

      Both WPS Spreadsheets and Microsoft Excel have the function of a screenshot. What are the differences between them? In Microsoft, we can click the Screenshot drop-down button and select one of the Available Windows to take a screenshot. Click Screen Clipping to capture the screen by adjusting its size manually, and only the area outside the Excel document is available. In WPS Spreadsheets, we have two ways of screenshot for your selection.Option 11. Click the Insert tab, click the Scre....

      Spreadsheet 34 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 4 views
      Prev 123...5758 Next
      WPS Academy