how to create a Drop Down Sort Column in Excel for iMac

Question

Hello,

Could someone please help me with how to reproduce a Drop Down Sort Column like the one shown. 

I imported this spreadsheet but would like to reproduce the drop down sort columns as show for a new spreadsheet.

For example, if I click on the down arrow (carrot) for the Sector tab, I see this image.  How can I create the Sort Tab like "Sector" and then the filter shown here?

Answer 1

Hi Brian

I hope this helps you.

Answer 2

You can drag an image file directly into the editor.

Alternatively, click the Insert Image button on the toolbar at the top of the editor.

You can then either click the Upload button, or drag an image file from Finder to the "Drop files here to upload" area.

Finally click Insert.

Answer 3

Got it thanks.

I figured out how to import the image.

Now, how do I create the drop down sort function?

Answer 4

Click in any of the headers.

On the Home tab of the ribbon, in the Editing group, click Sort & Filter > Filter.

This should turn on the filter dropdown arrows.

Answer 5

Additional to what was suggested by HansV there are several other ways to invoke the feature:

• Click any cell in the range then go to Data> AutoFilter in the main menu, or
• Use the Filter button on the Data tab of the Ribbon, or
• Convert the list to an Excel Table by using Insert> Table or by using the Table tool on the Insert tab of the Ribbon.

The last option provides for significant additional benefit, not just sorting & filtering. Also, it easily can be converted back to a range at any time.

Another feature to consider is a Pivot Table. There is ample information in Excel Help if you search using that term.