How to use the data validation function in Excel 2010?
Time: 2022-04-28Source: Huajun InformationAuthor: blue thin mushroom
① It’s still the old rule. Start Excel2010 first and enter basic data. This time we will use the data validation function to enter the name of the Evergrande boss. If you enter other names, an error will appear.
Excel2010
②Click cell A11, click menu bar--data--validity.
Excel2010
③ Now the setting tab will allow it to be set to sequence, and then enter the name of Evergrande boss Xu Jiayin in the source below.
Excel2010
④Switch to the error warning label, select Warning as the style, and fill in the title and error message.
Excel2010
⑤OK, after the settings are completed, you can see a small triangle appearing behind cell A11. Click it to quickly enter Xu Jiayin.
Excel2010
The above is the tutorial shared by the editor on using the data validity function of Excel 2010. I hope it will be helpful to everyone! For more exciting tutorials, please pay more attention to Huajun Software Park!
Popular recommendations
-
ZenTao Project Management Software Enterprise Edition
Version: v8.8 latest versionSize: 264.3MB
Based on the functions of ZenTao Professional Edition, ZenTao Enterprise Edition adds operation and maintenance management,
OA office management, feedback management and document version management, online preview...
-
Word 2020
Version: v4.3.5.2 official versionSize: 11MB
Word2020 official version is a very excellent document editing and processing software in the Microsoftoffice2020 office software collection. Word2020 official version...
-
Word 2016
Version: v4.3.5.10 free latest versionSize: 4.6MB
6WordWord2016 reading WordWord2016 installation package will be downloaded through Microsoft's official authorized product assistant (software size: 4.62MB), please feel free to use it...
-
Microsoft Office Word2021
Version: 4.3.5.10Size: 5.69MB
Microsoft Office Word 2021 official version is a fully functional document editing tool. MicrosoftOffice
The latest version of Word2021 supports w...
-
Kingsoft Document
Version: v3.9.9 latest versionSize: 75.84MB
Kingsoft Docs official version is an office software. The latest version of Kingsoft Docs is perfectly compatible with various document formats. You can upload files to the cloud and print them on different devices...
