Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
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
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.. :)
Posts
