In Excel, rows run horizontally across the spreadsheet and range from 1 to 1048576. Rows are identified by the numbers on the left side of the row. Row ranges are made up of rows, columns, and cells.

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.

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