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

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

Using Built-In Excel Functions Another way to split data into multiple columns is to use some of Microsoft Excel's functions.

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.