+ Reply to Thread
Results 1 to 5 of 5

Data Validation - Add Blank

  1. #1
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Data Validation - Add Blank

    I was not able to find an answer on internet...
    How to add a blank to data validation without help range
    Data Validation - List - Select1,Blank

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Data Validation - Add Blank

    I'm not sure what you mean - can't visualise it.

    You have a habit of being rather too succinct.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Re: Data Validation - Add Blank

    I know !
    Help column, starting A1:
    Select1
    A2 is empty

    In B1 , I have Data validation - List - Range - A1:A2 , so I have Select1 and "Empty/Blank"

    How can I add a Blank without range help ?
    Like : Select1,Char(130)

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Data Validation - Add Blank

    Sample workbook, please.

  5. #5
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Re: Data Validation - Add Blank

    Look, Data Validation, List , and then A1,A2,A3...(so 3 options). I want to add a 4th one, which is blank !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Blank cells data validation
    By Yaghoub61 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2020, 11:11 AM
  2. Replies: 3
    Last Post: 07-24-2017, 01:41 PM
  3. Replies: 1
    Last Post: 07-22-2016, 04:03 PM
  4. data validation - ensuring a blank
    By tariq1 in forum Excel General
    Replies: 3
    Last Post: 11-18-2010, 12:19 PM
  5. Blank cells - Data validation
    By MarkBlackburn86 in forum Excel General
    Replies: 1
    Last Post: 05-11-2010, 10:22 AM
  6. Loading Column Data with blank Rows into Data Validation Box
    By ExcelMonkey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2005, 02:05 PM
  7. Data Validation to only accept Y and N and NO blank
    By Joe HM in forum Excel General
    Replies: 3
    Last Post: 03-10-2005, 09:06 AM

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