Excel Tip of the Day

Easily apply previously created validation rules to new cells (Excel 2002)

If you've set up data validation rules in Excel, you may find that you want to apply the same validation criteria to another range, or even another workbook. Fortunately, this is very easy to do without recreating all the rules. First, select a range containing the cells that already have the validation rules you want applied. Press [Ctrl]C to copy the range. Then, right-click on the first cell in the range where you want to apply the rules. From the shortcut menu, select Paste Special. When the Paste Special dialog box appears, select the Validation option and then click OK.

(Content provided by Element K Journals)

(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
PrintPrint CloseClose

Copyright © 2001 - 2018 MJ Technologies, LLC.  All rights reserved.