answersLogoWhite

0

Use ROWS

=ROWS(A1:A20) will return 20. Add details if you need more help or if this is not what you are trying to do

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What are identified with numbers in Excel?

Rows are identified by numbers in Excel.


Are rows identified using numbers in Excel 2010?

Yes. Rows are identified with numbers. Columns are identified with letters.


Do you have a table without rows?

You can have a table without rows. It would be an empty table with no data. select (*)count from TABLENAME; 0 rows returned.


What are rows identified as in Excel?

Rows are a horizontal arrangement of cells. All rows are numbered. The amount of rows depend on the version of Excel you have. Versions of Excel from 2007 have 1,048,576 rows. Before that, there was 65,536 rows.


Number of rows in Microsoft Excel 2003?

There are 256 Columns and 65536 Rows in Excel 2003.


How many rows and columns in Excel 2000?

In Excel 97 there were 256 columns and 65536 rows.


How can I increase to more than 65536 rows in Excel 2007?

Excel 2007 has 1,048,576 rows, so it has more than 65,536 rows. Excel 2003 had 65,536 rows and it was not possible to increase that.


What will help you organize information into columns and rows?

A graph/table, or Microsoft Excel, or Apple Numbers.


Do rows run left to right and are labeled with letters on Excel?

No. They run left to right and are labelled with numbers.


How many rows and columns in Excel 2010?

There are 1,048,576 rows and 16,384 columns in Excel 2010


How can be more rows inserted after 65536 rows?

If the version of Excel you are using only has 65536 rows, which was the case up to Excel 2003, then you can't add any more rows. From Excel 2007 onwards there are 1048576 rows, so that is what you would need to use.


How do you collapse rows in Excel?

There is no function to collapse rows in Excel, but you can hide rows you do not want to display. Highlight the rows you would like to hide and select Format | Hide and Unhide | Hide Rows.