How to add a filter & sort button in cell?

excel excel-2013 dropdown
Skyler Cheah picture Skyler Cheah · Oct 8, 2015 · Viewed 32.4k times · Source

How can I insert the filter and sort button in the cell as in the picture?

Image

Answer

George picture George · Oct 8, 2015

or better, click on a cell that is filled in, and then "Home">>"Format as Table". It gives you a lot of options regarding filtering, sorting and formula copy plus some interesting design.

Format as Table screenshot

Related questions

If two cells match, return value from third

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address associated with an order number Column C: List of 100 specific order numbers that I need the email address for So, …

Read More
Excel: Searching for multiple terms in a cell

I use this handy equation to search for a term inside of a cell in excel. =IF(ISNUMBER(SEARCH("*Gingrich*",C1)),"1","") This equation searches for the presence of Gingrich in C1, if it exists, it displays a 1. All I'd like …

Read More
Clear contents and formatting of an Excel cell with a single command

If you want to clear the contents of a cell or range in Microsoft Excel, you can use .ClearContents. If you also want to clear the formatting, you can use .ClearFormats. Sheets("Test").Range("A1:C3").ClearContents Sheets("Test").Range("…

Read More