Guide to ROWS Function in Excel. Here we explain how to use ROWS formula, difference from ROW (), with examples & downloadable excel template. Row and Column Basics MS Excel is in tabular format consisting of rows and columns. Row runs horizontally while Column runs vertically. Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet. Connect and analyze data, build forms and dashboards, automate and share them. Eliminate manual work that slows you down. Rows bridges the gap between basic spreadsheets and complex data tools. While Excel requires manual data entry, Rows automatically syncs information from your favorite apps.