Show All

Hide All

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.

1. Click the cell with the settings that you want to copy, and click Copy .
2. Select the cells for which you want to duplicate the settings.
3. 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.

4. 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.