TITLE | DESCRIPTION | |
Date Validations | In this post, you will learn about date validations in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/date-validation-in-microsoft-excel/’,’_blank’)”] |
Restrict to Number/Decimal | In this post, you will learn to restrict to Number/Decimal in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/restrict-data-to-number-or-decimal-in-microsoft-excel/’,’_blank’)”] |
Remove Data Validations | In this post, you will learn to delete Remove Data Validations in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/remove-data-validation-from-microsoft-excel/’,’_blank’)”] |
Simple Drop Down List | In this post, you will learn to create simple drop-down list in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-create-a-simple-drop-down-list-in-microsoft-excel-2013/’,’_blank’)”] |
Auto Populate on Drop Down Selection | In this post, you will learn to auto populate on drop down selection. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/auto-populate-cell-value-on-selecting-value-in-excel-drop-down-list/’,’_blank’)”] |
Drop Down List with Other Worksheet Data | In this post, you will learn to create a drop down list with other worksheet data in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-create-a-drop-down-list-in-microsoft-excel-2013-to-use-data-from-different-worksheet/’,’_blank’)”] |
Color Coded Drop Down List | In this post, you will learn to create a color coded drop down list in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/inserting-the-color-coded-drop-down-list-in-microsoft-excel/’,’_blank’)”] |
Find Cells with Data Validations | In this post, you will learn to find cells with data validations in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/find-cells-with-data-validation-in-microsoft-excel/’,’_blank’)”] |
Find Invalid Data | In this post, you will learn to find invalid data in Excel workbook. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/find-invalid-data-in-a-sheet-in-microsoft-excel/’,’_blank’)”] |
Named Range | In this post, you will learn about the named range feature in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/named-range-in-microsoft-excel/’,’_blank’)”] |
Dynamic Named Range | In this post, you will learn about the dynamic named range in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/dynamic-named-range-in-microsoft-excel/’,’_blank’)”] |
Copy Cell Validation Rule | In this post, you will learn about the Copy Cell Validation Rule feature in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/copy-data-validation-rule-to-other-cells-in-microsoft-excel/’,’_blank’)”] |