435 results for add drop down list in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
435 results for add drop down list in excel
How can we create a drop-down list
01:33How 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....
Use Validation to restrict data change
02:24Use 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....
How to set the line numbers in WPS Writer
01:56How to set the line numbers in WPS Writer
The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....
How to add a cover page in WPS Writer
00:47How 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....
How to sort with a custom list
01:36How 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 ....
Quickly filter classified data
01:41Quickly 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,....
How to insert shapes in WPS Presentation
02:04How 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....
Skillfully use Conditional Formatting to highlight performance
01:21Skillfully use Conditional Formatting to highlight performance
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the....