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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Confusion around Form 26QB fields
- Tds on building rent monthly
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- RCM INVOICING FROM NOV-2024
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- TDS under section and rate of TDS
- GST input on scooter purchased
- TDS under section 194Q and TCS under section 206C
- GST input on car insurance and repairs
- GST input on Diwali gift to employee
- GST input on Mobile Handset
- Material and freight in same invoice
- TDS under section 194J inclusive of reimbursement of expenses
- TDS on Material and Labour in same invoice
Trending Online Classes
CAclubindia
