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
(Expert)
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.
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Gst credit note by supplier
- Missed uploading GST Invoice
- Query on effect of registration of property
- GST on reimbursement of expenses
- Due date for filing return for the partner in partnership subjected to Tax Audit
- Whether output tax is taken credit by purchaser
- Wrong CMPo8 file
- Equity Share Sale and Purchase
- Additional trade name
- Visiting card purchase
- Classification of income of P Ltd company as business or profession
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
