Traditional Culture Encyclopedia - The 24 Solar Terms - How to use the validity of EXCEL data to realize multi-level selection and entry
How to use the validity of EXCEL data to realize multi-level selection and entry
About how to use the validity of EXCEL data to realize multi-level selection and entry, the operation method in WPS“EXCEL "is as follows:
1. First, we input the data into Sheet2 and Sheet3 in the form, where Sheet2 is primary and secondary data and Sheet3 is secondary and tertiary data. Similar to the way of making the second-level drop-down menu before, we first enter Sheet2, select all the data, click Formula-Specify-only keep the check in front of the first line, and cancel everything else. Similarly, we enter Sheet3 again for operation;
2. Set the first-level drop-down menu: enter Sheet 1, select cell A2, enter data-validity-validity-selection order, and select cell A 1:C 1 of Sheet2 in the Source (that is, the content of the first-level drop-down menu);
(Note: Select an option after setting, otherwise an error will occur when setting Level 2. )
3. Set the secondary drop-down menu. Position the cursor in cell B2, then enter Data-Validity-Validity-Select Series, and enter "= Indirect (A2)" for confirmation;
4. Set the three-level drop-down menu. Select cell C2 and perform the same operation, except that "= indirect (B2)" is entered in the source. Finally, we select the A2:C2 cell and fill it down. At this point, our multi-level drop-down menu has been completed.
- Previous article:When is the solar term for heavy snow this year?
- Next article:What poems did Du Fu write about wanderers?
- Related articles
- How to clear the fuel consumption of Volkswagen Tiguan L
- Agricultural proverbs related to the twenty-four solar terms
- Is it still snowing in new york, USA? Now?
- The fastest solar term
- Ma Weidou said that a person's life is doomed. Can you believe it? What is fate?
- "Bears haunt the world" released the New Year's greeting song "Lucky Bear". Do you think it sounds good?
- As the saying goes, "When the solstice winter comes, there are four taboos". What should we avoid? Is the solstice in winter the first day of counting nine?
- How to replace the electromagnetic valve of Buick 2.4 carbon canister
- The b way to remove carbon deposits by yourself
- Which solar term is the most popular?