To create a drop-down list, select cell where you want it to be (in this case, cell I2), and in the Data tab on the ribbon, click "Data Validation" in the drop-down option with the same name.

Note that each header will have a small drop down arrow to the right of the cell. Click the top of a column that you want to sort and use the appropriate "Sort" buttons from the Sort & Filter section.

How to Use Column Headings in Excel. For many small business owners, Microsoft Excel 2010 is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare ...

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

This article will teach you how to create drop-down lists in Microsoft Excel using a feature called Data Validation. When applied, the Data Validation function serves to restrict data that can be ...

Learn how to ensure accurate data entry in Excel by creating drop-down lists for consistency in your spreadsheets with the help of this guide ...

Excel intuitively selects the list range, which usually consists of multiple columns. Click OK, and Excel will create the list shown in Figure B by adding drop-down controls to each header cell.

Can Excel show column headers on every screen? Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple.

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.