Question

 Making a drop down list in all cells of a column in MS Excel 2007?

Answer Based upon the information you have given, using the Data Validation method is the best way to handle this.Just select the column of cells that you want to have the drop-down choices within. The g... Read More »
http://answers.yahoo.com//question/index?qid=20090614070148AAjJ4Df

Top Q&A For: Making a drop down list in all cells of a colum...

How to Add a Drop-Down List to a Spreadsheet Column in Excel?

Drop down lists are created in Excel by using data validation. Data validation lets you specify what information appears in your custom Excel drop down list. Using drop down list lets you pick wh... Read More »
http://www.ehow.com/how_7334553_add-list-spreadsheet-column-excel.html

How to Create a Drop Down List from a Range of Cells in Excel 2003?

To make data entry easier, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere on the worksheet. It really d... Read More »
http://www.wikihow.com/Create-a-Drop-Down-List-from-a-Range-of-Cells-in-Excel-2003

MS Excel: How do you delete the last three characters of all cells in a column?

If you knew for sure that the last three characters were always the same value (or were something similar enough to allow the use of "wildcard" characters), then a simple Find/Replace would work (C... Read More »
http://answers.yahoo.com//question/index?qid=20090623082846AApYHvu

How do I use the Excel drop down box to format cells?

Select the cell or cells you want to format. You can select them by holding down your mouse and placing it over the cell or cells you want to select. Right-click your mouse and choose the "Formal C... Read More »
http://www.answerbag.com/q_view/2122387


feedback
loading