Microsoft excel help

This query is : Resolved

Guest

Guest (Querist)

22 January 2012 Dear experts, 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... ?

CA Suraj Lakhotia

CA Suraj Lakhotia (Expert)
Follow

22 January 2012 You can use data validation technique for same.
1.Type a-j in a column.
2.Go to the "destination cell" and select data validation from tools menu/data tab.
3. Select "List" in "Allow" field under the setting tab.
4. Give reference to the cells where you had typed a-j and the cell is now restricted.

You can also customise the input message and error message.

Message likes : 1 times

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Summarize this with AI

ChatGPT Perplexity Claude Google AI Grok

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

velichety.l.narasimharao

Akhila Ajayan

Amit Bagla

GIRISH K SATTI

Ravi

Subscribe Now

Microsoft excel help

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Article Assistant

Accountant

GST CONSULTANCY

CA Final

Manager- Finance and Compliance

GST CONSULTANT