If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter customization tools to limit the number of rows included in your filter results.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

Array: An array, an array formula, or a reference to range of cells to which you want the number of rows. How to use the ROW function in Microsoft Excel Launch Microsoft Excel. Type into the cell ...

How to Include All Rows for Filters in Excel. Microsoft Excel helps you sort your data for analysis by providing a Filter command. For example, when you want to sort number values from low to high ...

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.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.