How do you create a drop down list in Excel?

Asked by Last Modified  

1 Answer

Follow 1
Answer

Please enter your answer

Advanced Excel & PowerPoint Trainer

Hi Jitesh Please find the Steps Below:Seelct a Cell---- Data menu---- Data Validation--- Allow (Choose LIST) from drop Down---- Source box( Select the range of data)---- OK
Comments

Related Questions

How to write square in excel?
Format > Cells > Font > check Superscript then type '2' which will appear as superscript Format > Cells > Font > uncheck Superscript
Profile Photo
Dharmendra
0 0
View Comments9
How do I rename a worksheet in MS Excel?
Double click the worksheet name, then replace the existing name with a new name and press the enter key
Profile Photo
Dhanshri
1 0
View Comments7
How to use vlookup in excel?
Syntax for using vlookup function is =VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUMBER)
Profile Photo
Ankita
0 0
View Comments7
Excel formulas in advance level?
In excel we have lot of staff and formulas, we can learn based on your requirement, in excel vlookup, hlookup, pivot table if condition, sumif ifs, countA, if ifs, data validation, etc. and we have to...
Profile Photo
ManojGS

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons



Introduction to VBA editor
G

Gagan G.

0 0
View Comments0

Excel Tip: VLOOKUP formula limitations
1. Vlookup is not case-sensitive 2. If Lookup value has duplicates in the lookup column, then it returns 1st found value 3. Vlookup cannot pull values which are on the left side from Lookup column 4....
Profile Photo

Basic EXCEL Tips
Learn Use of MAX function in EXCEL: Penalty of Rs. 2% or Minimum Rs. 100 Amount Penalty Formula Rs 1000 200 +MAX(1000*2%,100) Rs 400 100 +MAX(400*2%,100)
Profile Photo

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you