In this article we will show you how to display multiple columns in a validation list in Excel. We will show you a method that can then be applied to your data. To create a validation list with ...

A Show Columns dialog box will open. Choose a column from the ‘Select available columns from list.’ In the ‘Show this column in this order list,’ choose a column, then click the Remove button.

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.