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.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
An If function within an if function in Excel is called what?
A nested if.
Does java supports friend function?
I don't believe that Excel has such a function; you'll have to write one yourself.
What the meaning of cell pointers in Microsoft Excel?
A cell pointer in excel is just the cell where you point the cursor in which its row and column can be seen is called a cell pointer.
The advantages and disadvantages of using Microsoft Excel Cube Function to extract data from a database?
None
How to resize the row and column in Microsoft Excel?
Highlight the row or column you want to resize by clicking on the top or left column, then click on format either row or column, then click on either heighth or width. A task box will appear, just enter the highth or width you want. Another option is to autofit.
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.
When you select a row and ask Excel to insert a row where is the new row inserted?
It is inserted above it.
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.
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
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 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 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 the bottom number on Microsoft Excel?
The last row number for Excel 2007 is 1048576.
What is the first row of the excel database that contains field names called?
heading row
