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... ?
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
- Tax on Deemed Capital Gain
- Exiting partner in partnership firm in gst portal
- Type of Capital Gain
- F & O PROFIT REPORTING FOR AY 2026-27
- Regarding ITR filing with more value than showing in AIS/TIS
- Average Cost Of High Quality Diamonds
- Can a single LLP in India legally operate multiple unrelated businesses (Travel, Cloud Kitchen, Ecom
- Banking Related Issue
- TAX AUDIT QUESTION
- Difff in ais receipts and gst turnover
- TDS offline utility
- TDS on rent received on hardship compensation being rent on redevelopment of building
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
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
