Data Validation Default Position

[chef]

Hello all,

I have a named range called band in column O in a sheet called Look and rows 2-38

I am using data validation drop lown list and enter =band as source

when user clicks on drop down it defaults to row 38 and they constantly have to scroll up to the start

is there a way that I can have the data validation drop down default to row2 and display that as first choice?

its not major problem but just a minor niggle and annoyance to user when completing

any suggestions would be greatly approciated as in genral it would be helpful to know how to default data validation lists to first choice rather than last

 

[Peter_SSs]

Sounds like you have some blank cells at the bottom of 'band'. Are you able to remove them?

 

[chef]

Many thanks Peter for your quick response

Thats extactly what it was and once removed, defaults to first choice
didn't realsise was that simple to sort and well appreciated
have a great weekend
regards
ian

 

[Peter_SSs]

Glad it was sorted easily.