June 21, 2024

MoDCore

Welcome to the core

Named Ranges with Data Validation

This will show an example of using “Named Ranges” and the Data Validation

Firstly setup your named range.
Input data into A1 >A5
Highlight Cells A1:A5
and Enter the name of the range (without spaces)
In the “Data Validation” you can select List and enter the named range ” =Fruit”
Nice and simple Named Range with Data Validation
Copyright © All rights reserved. | Newsphere by AF themes.