Increase # of rows displayed in a drop down list in excel?

How do I increase, to more than 8, the number of rows displayed in a drop down list in Excel?

1 Answer

The answer to this question can be found at . The answer given there by Sous2817 is:

"The 8 visible rows is a limitation of data validation. You can use a combo box to achieve the results you want. Check here for the "how to": "

The link listed in the answer is still functional.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy