Harsha
(Financial Accountant)
(60 Points)
Replied 22 January 2012
* Krishna *
(CA Student)
(6149 Points)
Replied 22 January 2012
Yes, there is such provision in Excel. First type alphabets from a to j somewhere in the worksheet and then Select the rows/columns in which above rule should be applied and then select Data Menu, then choose Data Validation (in Data Tools Tab) and Choose Settings Tab, then in Allow option select List and target the list of a to j typed earlier and press ok. Its done. You can also create Error Alert after Setting tab. Hope this helps.
Exshail
(Software)
(1576 Points)
Replied 25 January 2012
As suggested by Harsha & Krishna, if you still need a help see attached file.
For problem revert back.
Prashanth
(Chartered Accountant)
(2322 Points)
Replied 25 January 2012
Hi,
Step1:-Go To Data Validation in Data option
Step2:-Then Select settings,and from the drop down box select List option
and then enter a,b,c…..so on and at last ok...
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
CAclubindia
