Dear friends, Pls find the attachment file&Pls tell me how to creat this in excell with screen shot. Regards Naresh And Team
From India, Hyderabad
Acknowledge(4)
Amend(0)
4From India, Hyderabad
Acknowledge(4)Amend(0)
It's done by Data validation. From the Excel File menu (2007):
First to select an area which we need validation as yes or No. Go to file menu - Data - Data validation. Data validation - settings - in the validation criteria, Allow box you have to select list. Then in the source box you have to type yes, no (whatever list you want, you can type there). Then click OK.
From Kuwait, Kuwait
Acknowledge(7)
Amend(0)
First to select an area which we need validation as yes or No. Go to file menu - Data - Data validation. Data validation - settings - in the validation criteria, Allow box you have to select list. Then in the source box you have to type yes, no (whatever list you want, you can type there). Then click OK.
From Kuwait, Kuwait
Acknowledge(7)+2 more
Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Jadu File - Excel Help.xls
10 ways to format Excel data.pdf