For best results, your data needs to be in the proper format.If you need to flip the cells in a row or column, it can take a long time to do it manually—instead of re-entering all of your data, use these strategies to flip rows, turn columns into rows, and flip rows.Not all your dreams can come true in Excel, but this tip might fulfill a few of them.Instead of using data validation, you can use a combo box on an Excel worksheet to show a drop down list.At the left, in the screen shot below, is a combo box, and you can compare it to the data validation drop down list on the right.Unlike data validation, the combo box can be formatted and fine tuned.Because Excel doesn’t support sorting rows, you’ll need to first turn the row into a column by using the instructions for transposing above.
To see the steps for creating an Excel combo box with a drop down list, and changing its formatting, watch this short excel video tutorial.
I've spent the last two days working on this problem. Activate With Application '//execute the controls to lock the project\ .
Most of the content I've found on this topic doesn't address the issue I'm having, so I'm hopeful that someone here can help me.
Would you prefer a bigger font size for items in a data validation drop down list?
Would you save typing time if the words were completed automatically, as you started typing them?