Microsoft excel help

Dear all, is there any function for the following: I want to put either of the 10 characters? like the ans of a cell come with, a b c d e f g h i j! no other alphabet should come... ?
Replies (4)
Well i am not that clear with your question but i think you are speaking about list function under data validation check in google regarding list function in excel.if this is not the function that u needed kindly elobrate your question

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.

As suggested by Harsha & Krishna, if you still need a help see attached file.

For problem revert back.

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...

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details