If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...
Microsoft Excel can use the contents of a cell range to populate adjacent cells. If a range of cells contains a progressive series of numbers, Excel inserts the series's further numbers into nearby ...