Super User
Super User

Questions tagged [data-validation]

211 questions
43
votes
1 answer

Limit an Excel cell to one of two possible values

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell. How could I do this?
Josemalive
27
votes
4 answers

How to search for newline or linebreak characters in Excel?

I've imported some data into Excel (from a text file) and it contains some sort of newline characters. It looks like this initially: If I hit F2 (to edit) then Enter (to save changes) on each of the cells with a newline (without actually editing…
Highly Irregular
  • 3,121
21
votes
3 answers

How do I create a data validation list WITHOUT using cells?

I have a simple data validation dropdown that I'm trying to do, but I DO NOT WANT to use cells to populate my list. Something similar to what's below, but this obviously isn't working. What formula do I need to input to create a list of strings…
James Mertz
  • 26,529
20
votes
4 answers

Which characters are invalid for an MS-DOS filename?

I'm writing a filename I/O procedure in x86-16 assembly language. It takes eight characters (I don't need to support long filenames) from the keyboard and prints them to an on-screen text input field. At the moment I'm allowing numbers,…
My life is a bug.
  • 413
11
votes
1 answer

Setting a default value for a dynamic cascading validation list in Excel 2010

I have finally figured out how to build a dynamic cascading set of lists in Excel using Data Validation and the INDIRECT function. However, I'm running into a problem. I would like to set up my spreadsheet so that whenever a change is made in a…
Jay
  • 159
  • 1
  • 2
  • 6
9
votes
1 answer

Where is data validation text stored in Excel?

I have an Excel 2003 sheet with lots of different data validation rules. Is there anyway that they can be viewed other than through the regular data validation dialog? It would be helpful to export a list with validation error alerts, and rules,…
datatoo
  • 3,500
7
votes
1 answer

Excel, drop down lists

When I created custom drop down lists in excel, my excel sheets don't trim down to a smaller list when I start typing in the drop down list cell. For example if my drop down list is for USA States [AL...WY] and I type the character 'N' why doesn't…
Daniel
  • 1,445
6
votes
2 answers

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further cell, using Data Validation, I want to provide a…
Brad
  • 63
6
votes
4 answers

How do I force a user to use a specific format when entering time data?

I need to ensure the users of a particular spreadsheet are entering the time data in military time. I'm finding some folks are omitting the colon, and it's causing problems. Is there a way to force a specific formatting for a range of cells?
Sarah
  • 71
6
votes
3 answers

Excel: Update a value in a named range

I've got some cells in an Excel doc populated from a named range (data/validation/list source=MyNamedRange): Here, the A1:A3 range is named Foobar B5:B6 is under data validation with it's source set to 'Foobar' I'd like to be able to update cell's…
Vinzz
  • 162
5
votes
2 answers

show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown. Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop down list longer/bigger?
user222864
5
votes
3 answers

Excel 2010 data validation warning (compatibility mode)

We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation software. The current LabVIEW software can only handle the legacy .xls format, so we're forced to keep these worksheets as-is for the…
Adam Lawrence
  • 298
5
votes
0 answers

Check for damaged file mp3, m4a (aac) in Linux

I have around 15,000 music files stored on Ubuntu server (16.04), around 50% FLAC, 25% each mp3 and m4a (aac). I think maybe 3-5% are corrupted due to HDD hardware failure. The problems accumulated gradually for some time before I noticed. Files are…
BobM
  • 51
  • 2
4
votes
4 answers

Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule
udaya726
  • 173
4
votes
1 answer

Is there any way to embed tables from excel that have pull down menu

I may not be using the correct terminoloby, but, here goes. We have setup an Excel spreadsheet that is formatted into multiple 8.5 x 11 pages on one tab. The spread sheet has tables with a pull down menu on some of the pages. Once you select an…
sherri
  • 41
1
2 3
…
14 15