My dear friends: Any body could tell me how to create drop menu in Ms. Excel xp cells. I am really needy to know this. Abdul Naseer Ansari Afghanistan

See MS Excel's Help - Look for "Create a drop-down list from a range of cells" (I looked up the word "drop" to find the above.) HTH Bryan

To create a drop-down list from a range of cells, use the Validation command under the Data menu. To create a list of valid entries for the drop-down list, type the entries in a single column or row without blank cells. For example: A 1 Sales 2 Finance 3 R&D 4 MIS Note You may want to sort the data in the order that you want it to appear in the drop-down list. If you want to use another worksheet or another workbook, do one of the following: Use a different worksheet in the same workbook Type the list on that worksheet, and then define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the list. How? Select the cell, range of cells, or nonadjacent selections (nonadjacent selection: A selection of two or more cells or ranges that don't touch each other. When plotting nonadjacent selections in a chart, make sure that the combined selections form a rectangular shape.) that you want to name. Click the Name box at the left end of the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.). Name box Type the name for the cells, for example, ValidDepts. Press ENTER. Note You cannot name a cell while you are changing the contents of the cell. Use a different worksheet in a different workbook Type the list on that worksheet, and then define a name with an external reference to the list. How? Open the workbook that contains the list of drop-down entries. Open the workbook where you want to validate cells, point to Name on the Insert menu, and then click Define. In the Names in workbook box, type the name, for example, ValidDepts. Accept the default value in the Refers to: box, and then click OK. In the Refers to box, delete the contents, and keep the insertion pointer in the box. On the Window menu, click the name of the workbook that contains the list of drop-down entries, and then click the worksheet that contains the list. Select the cells containing the list. In the Define Name dialog box, click Add, and then click Close. Notes If several users need to open the workbook simultaneously, set the workbook to read-only recommended when you save it. For more information, see Prompt to open a file as read-only. The workbook must be open for users to use the validation list. You can record a macro to open it automatically whenever the workbook with the data validation is opened. For more information about creating and using macros, see About macros in Excel. Select the cell where you want the drop-down list. On the Data menu, click Validation, and then click the Settings tab. In the Allow box, click List. To specify the location of the list of valid entries, do one of the following: If the list is in the current worksheet, enter a reference to your list in the Source box. If the list is on a different worksheet in the same workbook or a different workbook, enter the name that you defined for your list in the Source box. In both cases, make sure that the reference or name is preceded with an equal sign (=). For example, enter =ValidDepts. Make sure that the In-cell drop-down check box is selected. To specify whether the cell can be left blank, select or clear the Ignore blank check box. Optionally, display an input message when the cell is clicked. How? Click the Input Message tab. Make sure that the Show input message when cell is selected check box is selected. Type the title and text for the message (up to 225 characters). Specify how you want Microsoft Office Excel to respond when invalid data is entered.