There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

The filter arrows in an Excel table’s column headings look downright ugly when those headings are right-justified. The arrows cover the rightmost characters in the headings, and there is no ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

When you want to filter all of the rows, the Select All option will apply the filter to your entire Excel table. Examples of filters for sorting text entries include Sort A to Z and Sort by Color.

In this story, we’ll get you up and running with tables in Excel, from creating and formatting them to performing calculations on their data.

By default worksheet data is not filtered automatically unless you format the data as a table. To do this, select the data, click the Home tab, select Format as Table and choose a table format. When ...