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

Answer 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 »

Top Q&A For: How do I use the Excel drop down box to format ...

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 »

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 »

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

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 »

Anybody tell me how to copy cells automatically in MS excel just by selecting cells by arrow key?

I am not sure why you would want to alter the typical functioning of the arrow keys, it would not be a wise decision. There are many shortcut key combinations of selecting cells within MS-Excel: ... Read More »