I am interesting if somebody can suggest in Excel 2016, I have columns and want to write mine values instead this it chooses only automatic range for example from 1 to 40. I want type for example the names instead numbers (in vertical line) what should I do?