Excel2013 setting data validity method

Time: 2021-09-11Source: Huajun Informationauthor:

Instead, I will use an example to show you how to set data validity. Let’s take a look at how to set data validity in Excel 2013. Let’s find out with the editor of Huajun.

​​Select a column of data as the data source, do not select the title of the first row

Excel2013 data validity

Find [Data Validation] under the data tab

Excel2013 data validity

​​Select [Sequence] under the settings option

Excel2013 data validity

​​Set the source to the area you just set, click OK

Excel2013 data validity

Related articles更多>>

• How to cancel compatibility check in Excel 2013 on Win8 system
• How to cancel compatibility check in Excel 2013 on Win8 system
• How to fix table header in excel2013? How to fix header in excel table
• Operation process of adding drop-down list in Excel 2013
• Steps to set password in Excel 2013
• How to set the print area in Excel 2013
• Detailed steps for inserting blank rows based on the number of shoe sizes in an Excel table
• Steps to use to display famous quotes and aphorisms according to time patterns in Excel cells
• Detailed steps to quickly enter the ohm symbol in Excel
• How to set up safe decompression of files in 360 Secure Browser? -How to set up safe decompression of files in 360 Secure Browser

Popular recommendations

• 

  OfficeAI assistant

  Version: 0.3.09Size: 32MB

  ...

• 

  Wendi official document and file management system

  Version: 8.7.9 official versionSize: 7895KB

  The Wendi official document and archives management system is based on the needs of official document management and is based on the "Archives Law of the People's Republic of China" and the "Official Document Processing Work of Party and Government Agencies"...

• 

  Reno warehouse engineering management software

  Version: 7.00 Engineering EditionSize: 4.62MB

  ...

• 

  Ultrasound report generation software

  Version: 1.0Size: 8.3MB

                                                                                                                                                                                                                                                     An ultrasound report generation tool for Windows systems. No installation is required, but it can be used after decompression. The user checks and fills in the data, and then clicks "...

• 

  Zhuanzhuan Master data recovery software

  Version: 2.2.0.8 official versionSize: 4.7 MB

  ​​ Zhuanzhuan Data Recovery Master is a data recovery software with powerful functions. At the same time, Zhuanzhuan Data Recovery Master software is small in size and easy to operate...