LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
PJH
 
Posts: n/a
Default Pick list or freeform text

I am trying to set up a spreadsheet so that in particular cells the option is
available to pick from a list or enter freeform text. I thought I had found
the answer in the data validation help file, but this does not seem to make
any difference. Have I misunderstood what this means?

"To specify how you want to handle blank (null) values, select or clear the
Ignore blank check box.
Note: If your allowed values are based on a cell range with a defined name,
and there is a blank cell anywhere in the range, setting the Ignore blank
check box allows any values to be entered in the validated cell. This is also
true for any cells referenced by validation formulas: if any referenced cell
is blank, setting the Ignore blank check box allows any values to be entered
in the validated cell."


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color text carried over from excel to merged list. Cyrus New Users to Excel 0 March 21st 06 03:26 PM
How can I wrap text in a drop down list? wrapped Excel Worksheet Functions 0 January 25th 06 05:53 PM
Making pick list conditional on selection from previous pick list Stewart Excel Discussion (Misc queries) 1 June 27th 05 11:30 AM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 07:10 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"