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.. 🙂