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

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 ...

Master Excel’s FILTER function to simplify data filtering, save time, and tackle complex datasets with ease. Learn advanced techniques now!

We show you how to put data in alphabetical order in Excel, sorting columns, rows, and using handy shortcuts.

=SORT(FILTER(A2:C10, C2:C10="In Stock"), 2, TRUE) Excel spreadsheet showing how to use the FILTER function with SORT This formula will return a filtered table with only the products currently in stock ...

To fix an Excel spreadsheet not filtering correctly, ungroup its sheets, apply the filter to its entire spreadsheet column, and unmerge cells.

How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide. Then, right-click on ...

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.

How to Make Columns Wider in Excel. When you add text to a cell in your business spreadsheet, that cell will not widen automatically to accommodate your text unless you change a few settings. This ...

Hiding and then unhiding columns in Excel only takes a few clicks. In this guide, we'll show you how to hide columns and bring them back in no time at all.

Sometimes when you’re using Excel, you might have data inputted across multiple columns, and you may wish to combine columns. One of the major perks of using spreadsheet software like Excel is that ...