Tag: data-validation

29 Limit an Excel cell to one of two possible values 2010-04-13T12:39:12.260

19 How to search for newline or linebreak characters in Excel? 2011-12-21T02:02:23.697

16 Which characters are invalid for an MS-DOS filename? 2018-09-28T04:06:24.147

11 Setting a default value for a dynamic cascading validation list in Excel 2010 2011-09-09T23:03:36.110

9 Where is data validation text stored in Excel? 2010-01-09T00:53:35.707

7 How do I create a data validation list WITHOUT using cells? 2012-07-11T23:46:08.570

6 Excel, drop down lists 2009-10-21T19:20:37.503

6 Excel: Update a value in a named range 2010-03-26T13:23:58.500

5 Excel 2010 data validation warning (compatibility mode) 2011-06-23T18:53:37.183

5 How do I force a user to use a specific format when entering time data? 2011-08-18T06:19:24.600

5 show more than 8 items in the Data Validation drop down list in Excel 2014-06-25T13:50:33.480

4 Multi-value selection in an Excel cell 2009-07-25T19:44:36.757

4 Email address validation tool - recommendations/experience? 2010-02-01T12:23:36.223

4 Entering only Digits in Excel DataSheet Cell 2011-08-17T18:32:00.910

4 Is there any way to embed tables from excel that have pull down menu 2011-11-02T20:24:52.430

4 Check for damaged file mp3, m4a (aac) in Linux 2017-11-14T07:04:36.247

3 Unlocking Locked Drop Down boxes in Excel 2009-07-27T20:41:01.917

3 Custom Validation - Dependent Drop Down Lists 2010-12-20T06:37:07.247

3 Excel data validation for decimals, but without a range? 2011-06-09T19:17:32.313

3 Only Add Odd Or Even Numbers To A Cell 2011-06-16T20:26:20.430

3 Best way to visualize graph on a text console? 2011-08-28T21:52:33.700

3 Excel 2007 Data Validation: Validate Against List or Allow User to Enter Custom Value 2012-01-23T14:03:43.480

3 Excel Conditional Formatting 2012-03-20T10:00:18.013

3 MS Excel data validator does not accept call to the custom macro 2013-01-28T13:35:00.177

3 Excel data validation to whole column 2013-09-13T08:01:40.397

3 Data Validation arrow hidden from freeze panes? 2014-04-25T15:05:27.963

3 Data Validation of a Comma Delimited List 2014-05-27T03:32:31.973

3 Excel "Smart" Dropdown / Data Validation 2015-07-08T20:08:27.767

3 Can CPU overheating cause data corruption? 2015-09-13T01:04:32.220

3 Make dropdown list show hyperlinks 2016-06-02T11:57:26.470

2 Excel validation - can it be used to make sure duplicates are not entered? 2009-07-23T21:48:06.247

2 In-cell Validation Drop-down list - widen 2009-08-27T10:44:33.350

2 software tools for cleaning up messy data (flat files, Excel etc) semi-automatically? 2010-09-30T17:54:50.090

2 Need to recover data from a poorly burnt 8.5GB dual-layer DVD - Cannot copy half the data from the disc 2011-10-02T20:13:21.453

2 Table data entry - How to always have a blank row at the end of an Excel table 2011-12-31T00:47:03.167

2 Microsoft Excel validation based on adjacent cell 2012-02-14T01:40:13.800

2 How do I make a Data Validation drop-down exclude blanks? 2012-10-16T03:07:18.857

2 Enforce style of named list items in Excel 2010 2012-11-29T11:55:18.957

2 Remove corrupted files 2013-02-23T14:40:31.197

2 Enforcing format input into a cell 2013-03-01T15:49:26.710

2 How can I avoid typing in a value which already exists in another range in Excel 2010? 2013-09-06T19:07:24.847

2 Linking dropdown lists 2013-09-26T17:14:14.377

2 Policy consolidation by Account 2013-11-06T22:14:41.663

2 Can a drop down in Excel show long descriptions when clicked, but only a short code once selected? 2015-08-04T18:18:39.837

2 Linked dropdown lists? 2016-01-26T17:54:10.520

2 How can I Implement Dynamic Dependent Data Validation List in Excel 2016-10-20T20:32:54.947

2 How can I validate or format dates in excel 2016-10-20T21:20:52.507

2 excel lock data validation 2017-02-23T18:10:32.613

2 Why does the dropdown button in Excel data validation disappear? 2017-05-04T07:40:31.873

2 MS Excel - Data Validation 2017-05-23T02:24:56.260

2 Excel: Data validation list enable option for all values 2017-11-06T10:25:07.917

2 Excel allowing deletion of cell contents of data validated cell 2017-12-15T21:21:43.127

2 Auto-populate cells in Excel 2017-12-23T12:39:57.883

1 How to input only unique values in a column in Excel 2007 2010-07-17T18:02:19.707

1 How do I prevent users from entering a blank value in an Excel sheet? 2010-12-23T21:19:58.733

1 When I'm compressing GBs of data with 10k plus of files and directories, how do I know there's no corruption? 2011-03-10T19:45:51.060

1 Excel 2007 vs Excel 2010: Data Validation values using Named Ranges and the INDIRECT function 2011-11-01T18:07:03.583

1 Conditional Data Validation 2011-11-02T12:33:50.320

1 How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values? 2012-10-16T01:26:19.107

1 Excel Data Validation with multiple choices and free text 2012-11-02T18:10:20.957

1 Excel: Reference Dropdown Cell in Countif Formula 2014-02-24T00:38:45.427

1 How to have a drop-down in a cell only if certain cells have text 2014-05-29T01:55:21.057

1 How to set up data validation to allow only a date or a specific string 2014-10-08T16:56:06.187

1 Creating a list from another list's value 2014-11-13T18:09:20.780

1 how to verify TBs of data copied from cloud 2014-11-18T20:51:16.203

1 How to validate autonumbering in MS Excel 2015-04-04T10:59:10.657

1 How to use validation to make sure cell value starts with specific word 2015-04-27T15:35:44.123

1 Dependent Drop Down lists and Data Validation; Multiple Lists 2015-06-10T14:55:43.613

1 Data Validation list to add multiple item, comma seperated in the same list excel 2013 2015-09-16T09:14:17.490

1 Cell with 2 options and I want to add a third 2015-10-03T03:19:03.500

1 Excel: Separate Currency Values from Rest of Line 2016-01-03T20:56:28.767

1 Is there any way(e.g. software etc.) where data can be matched visually 2016-01-11T10:15:19.867

1 Is it possible to make Excel auto-filter case sensitive? 2016-12-20T21:17:39.047

1 IF/THEN drop down list 2017-03-25T12:03:47.753

1 Custom Data Validation requiring a numerical 00-00 format 2017-05-30T21:02:49.857

1 Excel 2016 Data Validation Not Working After Close & Re-Open 2017-06-02T12:32:26.590

1 Forcing negative input depending on type 2017-07-06T02:37:22.687

1 Remove Duplicates when column data is in Drop Down List 2017-08-04T16:28:21.580

1 Excel 2013 Formula to validate binary data and exclude blank cells (would also love help simplifying current formula) 2017-08-30T14:26:56.963

1 excel data validation list only upper case 2017-09-15T10:02:00.880

1 Data Validation From 2 Lists EXCEL 2010 2017-09-29T08:38:52.577

1 How do I show Data Validation red circles when sheet is protected? 2017-10-22T01:29:56.933

1 Using an Array in Excel's Data Validation 2018-02-06T17:53:33.653

1 Excel Dynamic Drop Down Lists based on a Matrix 2018-03-20T07:28:17.440

1 Conditional defalt on data validation list 2018-08-10T18:16:47.357

1 Data Validation in Excel - Two Cells can't be the same 2019-03-05T20:37:27.520

1 Pivot Table ineffectively capturing Multiple Selection Data Validated Cells 2019-03-22T09:57:09.890

1 Adding multiple validations to a cell 2019-08-27T07:39:09.860

1 MS Excel. How to get around pivoting data that has blank placeholder columns? 2019-09-10T09:32:27.997

1 Excel - Manual Column(s) Beside Imported Data 2019-10-29T01:26:12.093

1 Custom data validation 2019-11-27T15:50:52.817

0 Statically Display Excel drop-down boxes 2009-10-16T10:40:00.320

0 Using Excel Lookup Function and Handling Case Where No Matches Exist 2010-04-20T11:01:00.597

0 How do I ensure only integers and with no duplicated values can appear in a column in Excel 2007? 2010-07-19T17:29:28.433

0 Validate a cell containing formula 2010-11-22T16:46:32.170

0 How do I clear cells with list data validation based on another column's value? 2011-08-17T19:16:57.887

0 Is there a way to verify that data files are not corrupted after reformatting? 2011-12-08T06:53:22.590

0 excel: the name but not the contents of a named range is the only option shown in drop down list 2012-03-13T14:54:29.607

0 Restricting symbols allowed in cells of Excel spreadsheet 2012-03-16T12:59:54.543