Drop down list allows you to enter data into an Excel spreadsheet from a preset list of entries. This can be done to make data entry easier or to limit the number of choices. Enter the data on sheet from which you wish to create your drop down list (different cell for each list item)
Select the cell that contains the formula that you want to copy. On the Home tab, in the Clipboard group, click Copy. Do one of the following: To paste the formula and any formatting, on the Home tab, in the Clipboard group, click Paste. To paste the formula only, on the Home tab, in the
Select the cell that contains the formula that you want to move. On the Home tab, in the Clipboard group, click Cut. You can also move formulas by dragging the border of the selected cell to the upper-left cell of the paste area. Any existing data is replaced. Do one of the following: To paste
