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 Threads
- Inverted Rate structure .
- Exemption to be climed
- GST TDS u/s 51 Applicability on RBI and it's subs
- Time allowed to buy another asset
- ITR not processed for the FY 2024-25
- Gift of money to my wife.
- Tax Audit If you show Loss
- GST Tax invoice Value Rs..234000
- Can I claim benefit under 54F if I sell my equity
- Income tax refund 25/26
Related Threads
CAclubindia
