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 »

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 »

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 »

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 »

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 »