Assalamu’alaikum,
Praise and gratitude we always pour out to the creator of the universe "Allah SWT” who always gives health, time, and the opportunity to the author to finish this article entitled “How to Make Data Validation in Cells in the Microsoft Excel Application“, so that this article can be in the center of the reader.
Get to know ACKNOWLEDGMENT AND APPROVAL “Microsoft Excel application” for calculations and also processing data basic or just knowing method just use it, it can be said that just knowing the outer skin of application Excel the.
If studied further, application excel has many features that can used to process data up to results proportional ending.
“Learning Excel is hard, said who?” There are still many people who think that learning Excel is difficult.
Such an assumption only applies to those who are lazy to learn and explore their potential. Why is that? Because, There are already many facilities that can be used to learn Excel, both free and paid.
Especially now Microsoft Office Excel, better known as Microsoft Excel already have the latest version included in the Office package 15. The Office package issued by the Microsoft company supports adding and changing features that make it easier for users to process data.
To process data regularly optimal understanding is required in operating the Excel application.
To achieve that, make sure you have the articles on website we (suspended.net) this to the end.
Because, in the website of this article there is a complete guide, tricks and tips, excel formulation and how to use the Excel application that you should know to then apply to your daily work.
How to Provide Data Validation in Excel
Salah satu penggunaan validasi data adalah untuk make daftar menurun. The use of data validation also aims to limit the types of values or data that users enter into cells. Nah, sekarang bagaimana cara showing jendela pop-up ketika data yang diinputkan ke dalam sel tidak memenuhi kriteria yang telah ditentukan? To display a pop-up window when the entered data does not meet the specified criteria, can be done as follows:
- Open workbook, then make an example of the data as follows.
2. Now select cell C2, then from tab Data pilih drop down pada perintah Data Validation to display the Data Validation dialog.
3. In the Data Validation dialog box select the tab Settingand in the Arrow choose Whole Number and input the value Minimal 4 and value Maximum 6 in the available field.
4. Next, the tab Error Alert in the Style, tentukan bentuk pesan yang akan ditampilkan “Information” and in the Title“Versi Adobe” isikan dengan judul pesan, while in Error Message “Inputkan numbers antara 4-6” isikan dengan pesan yang akan ditampilkan.
5. Simpan pengaturan dengan memilih OK dan lakukan pengujian dengan menginputkan angka antara angka 4-6, maka pesan yang dibuat tadi akan ditampilkan karena tidak memenuhi kriteria yang diberikan pada pengaturan setting.
Demikianlah kami paparkan tentang bagaimana Cara Membuat Validasi Data di Excel. Hopefully the readers can understand this method properly and correctly.
Thank you
Wassalam.
Similar Posts:
- How to Create Data Validation Error Messages – Microsoft Excel
- How to Add Pop-Up Window to Cell – Microsoft Excel
- How to Import Data from Microsoft Access Into Excel – Microsoft Excel
- How to Customize Ribbon in Microsoft Excel – Microsoft Excel
- How to Make Subtotals in Excel – Microsoft Excel
- How to make a decimal number with two digits after a comma – Microsoft Excel
- Ribbon – Show and Hide – Microsoft Excel
- How to Display Data With Accounting Format – Microsoft Excel
- How to Display Currency Symbols in Excel – Blog / items Microsoft Excel
- How to Manage Commands on the Ribbon – Microsoft Excel
