+ Reply to Thread
Results 1 to 2 of 2

Copy Data Validation settings without copying cell content or formatting

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Copy Data Validation settings without copying cell content or formatting

    Is there anything like "format painter" for data validation?

    Once I set up data validation for a cell, is it possible to copy those settings to another cell without having to do a cell copy & paste, which will also wipe out destination values and formatting?

    When setting conditional formatting, it gets carried along when you do a format paint, but data validation settings are not considered part of formatting.

    If VBA is the only way to do this, I can develop that solution on my own but I was hoping there was something built in that I was ignorant of.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Copy Data Validation settings without copying cell content or formatting

    Copy -> Paste Special -> Validation

    (inserting the validation won't "validate" any pre-existing values in the destination range(s))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1