excel drop down list column header

How to Make Sortable Headings in Excel

Microsofts Excel spreadsheet program contains many features that enable you to create comprehensive and detailed documents. You may use tools to perform tasks similar to other Office productivity programs, such as editing text, images and other objects. Pre-formatted formulas, such as AUTOSUM and AVERAGE, may be used to perform simple or complicated calculations. Another feature that may be used is the filter function that allows you to sort ranges of data using column headings.

1

Launch Excel and open the spreadsheet that contains the data that you want to sort. Make certain the columns of data that you want sort. If they do not, select the top row. Click the Home tab and locate the Cells group. Click the Insert button and select the Insert Sheet Rows option. Type a header name in the top cell of each column, for example Name, Address and Phone Number.

2

Highlight the row that contains the headings that you want to be able to sort. You may also select the range of cells that contain the headers, instead of the whole row.

3

Click the Data tab and locate the Sort & Filter section. Click the Filter button. 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.

Related Articles