answersLogoWhite

0

It gives you the row part of a cell reference.

=ROW(D3)

This will give the value 3, as that is the row part of the cell reference.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What function in excel allows your columns to row or rows to columns?

You can use the Transpose facility in Paste Special or use the Tranpose function.


What is an Excel reference function that looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify?

hlookup


How do you change a row from a column in Excel?

You use the TRANSPOSE feature of the PASTE SPECIAL command, having just copied a row of data. You can also use the TRANSPOSE function.


How many intersection of row and column in ns Excel?

Each intersection of a row and column is a cell. So it will depend on which version of Excel you have There are 16,777,216 cells in Excel 2003 and earlier. There are 17,179,869,184 cells in Excel 2007 and after.


When you select a row and ask Excel to insert a row where is the new row inserted?

It is inserted above it.


Is there a way to swap column headings and row headings?

Data can be transposed in Excel, so that the data that was in a row will go into a column and data that was in a column will go into a row. There is a TRANSPOSE function or you can copy your data and then use Paste Special and pick the Transpose option.


What is the path to the sum arrow?

When you reduce the row height in excel the row is hidden


What three elements indicate an Excel table is created in a worksheet?

Header Row, Banded Row and Calculated Columns make up an Excel Table.


What is v - look up?

VLOOKUP is a function of Microsoft Excel. You can use VLOOKUP to find a value in a table or list on an Excel sheet. It looks at a value in a column and finds the corresponding value in another column in the same row.


What is the bottom number on Microsoft Excel?

The last row number for Excel 2007 is 1048576.


When does Excel assign the SUM function to cells next to numbers?

It you select the blank cell under a column of numbers or a blank cell at the end of a row of numbers and hit the Autosum button it will enter the SUM function and select the cells above in the column, or to the left in a row. Pressing Alt and the = key will also do the same thing. If you select the column or the row with the numbers and click the button or do Alt and the = key, then it will also do the same.


What is the first row of the excel database that contains field names called?

heading row