Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.
Creating a list box in Excel can save you the hassle of keying repetitive entries into your spreadsheets. This is especially true if your spreadsheet has hundreds of records. In this tutorial, we create a simple list box that will allow you to select from a list of data.
First, find a range to put the data that you want to appear in your list box. I usually create a new sheet to store my data sets.
Next, select cell(s) or a column where you would like the list box to appear. Click on the data tab then on the data validation drop-down arrow.
Next, click on 'data validation' from the drop-down menu.
Select 'List' from the 'Allow' drop-down menu.
Click in the source box. Now select the range where you inputted your data set. Select 'OK' when the range you selected appears in the source box.
Go back to the cell(s) that you selected before selecting the data tab. There should be a drop-down arrow to the right of the cell(s) that will allow you to select data from the data set you created.
- Create a Macro Button in MS Excel 2016 to Filter Data
The article will show you how to create a set of buttons allowing you to filter a table within a spreadsheet and revert to your original view quickly. A document template for the task will be provided.
- How to Add the Developer Tab in MS Excel 2016
This article shows you how to navigate through the MS Excel options menu to enable visibility of the developer tab within the Excel main menu.
- How to Concatenate Data in Microsoft Excel 2016
You may need to bring data from different cells together in Microsoft Excel. One way to do this is to use a formula. A concatenate formula can display data together with spacing that is editable.
To learn more about using functions in Excel I recommend purchasing Excel Formulas & Functions For Dummies.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2017 Joshua Crowder