Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

How to Flip Column Headings As Row Headings on an Excel Spreadsheet. Sometimes, the layout and appearance of the data in your Excel spreadsheet is just as important as the result of the ...

You can sort data by dates in Microsoft Excel and Excel Online. Learn how to sort all the columns according to date column using this tutorial.

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.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

How to Have Excel Freeze Row and Column Data It's often useful to freeze header rows or columns in Excel while navigating through a spreadsheet.

If you are using Excel and would like to automatically transfer data from a master sheet to specified sub sheets when a certain condition is met, this article will explain how to use VBA (Visual Basic ...