Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Enter Data Manually In Worksheet Cells. Click the down arrow on the right side of the Source box to accept the input and expand the dialog box. Click on a cell.
Activate cell A15 in the Sheet1 worksheet. Type the abbreviation Tot and press the ENTER key. The entries automatically display in the worksheet Formula bar.
Click the down arrow on the right side of the Source box to accept the input and expand the dialog box.
On the worksheet click a cell. On the worksheet click a cell. After you have found the cells that have data validation you can change copy or remove validation settings. Click in the Series values box and delete the default entry.