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 »

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 »

Can you use drop-down menus to populate other cells in Microsoft Excel If yes, how?

Let us say that you have your product information on a separate worksheet called "Products", where column "A" contains the names, column "B" contains the current price, and column "C" contains the ... Read More »