Have you tried each and every possible method?? still not working?? let excel to repair the sheet now. The worksheet may be corrupted. Try copying the data to a new worksheet or workbook, and the dropdown arrows may reappear. Or, try to repair the file as you open it: In Excel, choose File | Open […]
Drop Down List in Excel Cell
To make a Drop Down List in a Excel cell, Select the cell Data Menu Click Validation For the drop down list Allow, choose LIST In the text box Source add items separated by comma. Click OK
Line Break Within Excel Cell
Yesterday I was writing Test Cases and I want to have line break with in an Excel cell. I tried several methods but non worked for me. Finally I googled and found out the way. Press Alt+Enter Yep.. it’ll work for you too.. 🙂