Tuesday, February 21, 2006

How to Create a List in Microsoft Excel

I keep forgetting how I can create list in Excel and then have to spend inappropriate amount to time figuring that one out and so…

Open the spreadsheet> Data> Validation> Settings> Allow: List> Source: {item1, item2, item3…}> Input Message> Title: {Your default message. Eg. Choose one…}> Error Alert {Fill the boxes as required}> OK

1 comment:

Alex said...

Some days ago I reinstalled my MS Excel and on unknown reasons a lot my data were corrupted.To my surprise myself helped-xlsx corrupted,this tool I found in own computer archives.As far as I remember tool is free and in addition it can both recover all these graphics, interviews, tables and reports in Microsoft Excel format.