After you define data validation in a cell, you may want to copy the data validation settings to other cells. For example, you may want to ensure that a user can only enter date values for the current year in a column of data, or you may want to use the same input message and error alert, but slightly modify the data validation settings in the other cells.
- Click the cell with the settings that you want to copy, and click Copy .
- Select the cells for which you want to duplicate the settings.
- On the Edit menu, click Paste Special.
Note In the Paste Special dialog box, the All and All except borders options also paste the data validation settings.
- Click Validation.
Note You cannot copy or paste data validation within cells of a list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) that is linked to a SharePoint site.