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.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

Functions are an important part of Excel and assist in calculating many data for many users. Column functions and Columns functions are Lookup and Reference functions in Microsoft Excel.

Select all existing data cells in the column in question. In this case, that’s B3:B6. Click the Data tab, and choose Data Validation from the Data Validation dropdown (in the Data Tools group).

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.