How To Use Excel Rows Function Leave a Comment / Formulas / Row, Rows The excel ROWS function is used to get the rows number of the specified array, continuous cell range, or a formula that returns an array. This article will tell you how to use the excel ROWS function with examples.