Click Find & Select Go To Special under Home tab.3.In the Go To Special dialog box, check the Data validation and Same options, and finally click the OK button.
While we could simply type in the correct spelling, that wouldn't prevent someone from making the same mistake in the future.
This can be very useful because now you can use one sheet to store all of your reference lists like a database and use them on any other sheet in the workbook. This can be on the same sheet or on a differnet sheet.
I went ahead and selected cell A1 on Sheet2 for the example.
Well sometimes you can type it in incorrectly or you might have a long list of different types of expenses and incomes, so this can be a pain to maintain and remember. First, create a new workbook and on Sheet1 start off in row 1, column 1 (A1) and type in a few expense categories in the column. Now that you got your reference list, go ahead and select the cells with the data in them. Left click on A1 and hold the mouse button down and drag until you get to A8. Now in the box next to the formula textbox on the left (also called the Name box), type in a name for your list and press Enter. Doing this basically gives the cells from A1 to A8 a name so that the group of cells can now be referenced by a name rather than saying A1 through A8. Now we can use our list to create a dropdown menu with those values.
An easy solution in Excel is to create your own dropdown list of choices pulled from a particular column on the same sheet or another sheet. First select the cell where you want your dropdown list to be created.