Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

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.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

Learn how to dynamically insert blank rows in Excel to improve data readability, organization, and clarity with advanced techniques.

Total Row: Checking this option adds an extra row to the bottom of your table where you can add column totals (more on this soon). Banded Rows: Enable this option to make it easier to read across ...