How to set drop-down options in Excel

Indifferent to life

Favorable reply

Excel forms are often used in work. Sometimes we want to limit the selection in the form. How to set it

Operation method

Open an excel table, select the cell to be set, as shown in the figure, find the data, and click to enter

Find the data validity, as shown in the figure, and click to enter

The interface pops up as shown in the figure below. Click the drop-down triangle in Allow, as shown in the figure below

Find the sequence and click to select it, as shown in the figure

In the source box that appears, enter the options you want to set, such as excellent, average, and poor. Note that they should be separated by commas in English

Finally, make sure that the drop-down options appear in the cell. The options are excellent, average, and poor

Indifferent to life 2024-05-29 23:46:19

The above contents quoted, excerpted or reproduced on this website are only for the exchange or reference of website visitors. The views or information in the text have nothing to do with Aiwen, and any matters and legal liabilities related to it have nothing to do with Aiwen.

Latest answers Change

one

Q: How to use the Unicom flow card after recharging

Answer:

Answer: If the Unicom flow card is a pure data card, the SIM card is generally the same as the general mobile phone card. However, if the mobile phone card is inserted into the current mobile phone, it is inserted into the mobile phone for use, but it has no voice call function. If the mobile phone is not a dual card dual standby mobile phone and the flow card needs to be used, the original card can only be pulled out first and then inserted into the data card for use. The pure data card, also known as the user ID card and smart card, must be installed on the digital mobile phone before it can be used. The computer chip stores the digital mobile phone customer information, encrypted key, user's phone book and other contents, which can be used to identify network customers and encrypt the voice information of customers when they are talking. Dual card dual standby is a new term in the mobile phone industry. Dual card dual standby refers to that the mobile phone can be inserted with two mobile phone cards and can be standby at the same time. To put it simply, consumers can use the mobile phone numbers of two networks on one mobile phone when using dual card dual standby mobile phones, and can use the mobile phone numbers of two CDMA networks when using CDMA dual card dual standby mobile phones. The dual card dual standby mobile phone can be set to the following three conditions: only SIM1 card is on; Only SIM2 card is on; Double card open. With dual card and dual standby mobile phones, busy people will not have to hold two mobile phones in their hands, which is simple and convenient.

two

Can I stay overnight with noodles made in winter 2020-03-21

three

What is the place of origin 2020-07-23

four

How to fry chicken fillet 2020-07-15

five

What is the character of type b blood 2019-05-27

Related recommendations

Is there a shelf life for eyebrow powder

The eyebrow powder has a shelf life. Generally, the shelf life of makeup is 5 years. In the case of Kaifeng, the foundation, eye shadow, eyebrow powder, blush, lipstick and lip gloss can be used for three years if they are used normally, but the lipstick and lip gloss can only be used for two years if they are often contaminated. Even if not used up

Details>

Question time: August 12, 2019

When did the touch screen mobile phone come out

1993. The "Simon" launched by IBM in 1993 is the first smart phone in the world, although there was no such term at that time. It combines the functional features of mobile phones and PDAs, and for the first time has a built-in touch screen, although the early touch screen

Details>

Question time: December 11, 2020

What does it mean to be resourceful

Being resourceful means that people are very crafty, think carefully about things, and have a cruel heart. Generally speaking, the said strategy is to take some abnormal channels and means to achieve a certain purpose

Details>

Question time: August 5, 2019

Which is uncomfortable, dry or wet

The body feels colder when it is wet and cold. Because if the humidity in the air is high, water or ice is actually constantly evaporating, and evaporation will absorb heat. If the absorbed heat is obtained from the human body, the human body will naturally feel colder. Just like in the north, the same

Details>

Question time: December 7, 2019

Conditions for registration of attending physician examination

The basic conditions for applying for the examination of attending physician include: 1. Abide by the Constitution and laws of the People's Republic of China. 2. Comply with the Law of the People's Republic of China on Medical Practitioners and obtain the qualification of medical practitioners. 3. Have good medical ethics and professionalism. 4. Resident standardization has been implemented

Details>

Question time: November 22, 2021-12

Is Afghanistan Jewish

Afghanistan is not Jewish. Afghans include more than 30 ethnic groups, of which Pashtuns are the majority, and the rest are Tajiks, Uzbeks, Hazaras, Chahar Aimak, Turkmen, Baluchistans, etc. His ancestors have come for many times

Details>

Question time: September 26, 2021

How did mercury come from

In ancient times, when making mercury, it was necessary to prepare cinnabar, place it in a container with an opening, heat and burn it, and introduce the generated steam into the container to store mercury through a pipe. Mercury can be obtained after the steam is completely cooled. Mercury is the common name of mercury. Mercury is a chemical element

Details>

Question time: February 8, 2020

What is the food rich in enoic acid

The food rich in enoic acid is fish. DHA is the abbreviation of unsaturated fatty acid docosahexaenoic acid. Enoic acid is one of the important substances for human brain development and growth. The most DHA content is fish orbital fat, followed by fish oil, so eating more fish can make children smart

Details>

Question time: November 9, 2020

5 jin glutinous rice with a few jin dry zongzi leaves

Generally, 4-5 jin of glutinous rice needs about one jin of dry zongzi leaves. If only 5 jin of glutinous rice is prepared, one jin and a half of dry zongzi leaves can be prepared. Not every piece of dry zongzi leaves bought in the market is necessarily good. There will be some scrap rates when packaging zongzi, taking these factors into account

Details>

Question time: September 15, 2021

Which year was the Zhengde period of the Ming Dynasty

The reign of Zhengde in the Ming Dynasty belongs to 1505, the first year of Zhengde in 1505, and the 13th year of Zhengde in the Ming Dynasty is 1518. Zhu Houzhao, Emperor Wuzong of the Ming Dynasty (October 26, 1491 - April 20, 1521), the 11th generation of the Ming Dynasty (1505-1521)

Details>

Question time: December 17, 2020

Is Guangdong DPB and Germany DPB the same company

Guangdong DPB and Germany DPB are not the same. Guangdong Deborah Industrial Co., Ltd. is a limited liability company registered in Baiyun District, Guangzhou, Guangdong Province on June 13, 2010. Deborah is a German kitchen appliance company established in 1879. Guangdong Debo Industry Co., Ltd

Details>

Question time: March 28, 2021

How to use the Miracle Rebirth Constellation

Illuminate all stars of a constellation to activate additional badge attributes. The lighted star meets certain requirements, which can activate the Star Power badge and obtain additional attributes. Each constellation lights up the required number of stars to activate the force of the zodiac and obtain additional attributes. The power of the stars and the ecliptic

Details>

Question time: December 16, 2019

What's the black one in the scallop meat?

The black one in the scallop meat is the digestive gland of scallop, which is equivalent to the sewage (viscera) of animals. Its main function is the digestive system and excretory system of scallop. The digestive gland of scallop contains waste, toxin, heavy metal or sediment excreted, which is inedible. Scallops because

Details>

Question time: June 19, 2020

Is Static Electricity Harmful to Babies

NO.1 Skin inflammation Current generated by static electricity will attract dust in the air. These dusts contain a large number of viruses, bacteria and toxic substances. These dusts attach to the baby's delicate skin through static electricity, causing irritation to the baby's skin and affecting the light of the baby's skin

Details>

Question time: March 15, 2019