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

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.

Learn how to create Excel dynamic total rows that adjust automatically with your data. Save time and simplify data management with these ...

How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

To cross-reference between spreadsheets, you must identify cells using extended addresses. These extended references specify the cell's sheet as well as its column and row.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.

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.