Copy data validation settings

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 Button image.
  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.

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

Applies to:
Excel 2003