What is the septs to create a Drop down list view in Excel. So that while entering repetavive data can be selected from that list as input.
Menu
dropdown list view in Excel
Replies (3)
S1. Enter the data in column wise at some place of the workbook.
S2. go to the cell where you want the drop down list and do the following
S3. In excel go to Data - validation - allow- list
S4. in source field select the data you have entered in S1.
Thats it you can do more validation by using this option
| Originally posted by :jeevan | ||
| " | S1. Enter the data in column wise at some place of the workbook. S2. go to the cell where you want the drop down list and do the following S3. In excel go to Data - validation - allow- list S4. in source field select the data you have entered in S1. Thats it you can do more validation by using this option |
" |
Thank you it works..
THE ALTERNATIVE:
S1. In excel go to Data - validation - allow- list
S2. in source field, ENTER YOUR DATA(USE COMMA AS SEPARATER)
**dm
Recent Topics :
- Consultation
- E-way notices2222
- Gst file not created
- Regarding 3CEB query
- Omitted E-Commerce Sales Reported in Table 14 but
- Omitted sales shown in GSTR-1 Table 14 but not in
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
- Which Aviation Services Can Air Ticketing Professi
Related Topics :
CAclubindia
