0
To number your rows in Excel, put a '1' in the first row, for instance in cell a1, the formula '=a1+1' in the second row, and then copy that formula to each additional row you want to number. Be careful, though, as inserting and deleting rows will mess the sequence up, and you will need to fix it as needed.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Can someone give you a formula to use on Excel to generate 6 number combinations using the numbers 1 to 49?
No. There are nearly 14 million combinations of 49 things taken 6 at a time. Excel does not have that many rows or columns to support that.
If in the drama club picture the students must line up in rows with the same number of students describe the arrangements for the least number of people needed to be able to line up in rows of 5 or 6?
If they can stand in rows of 5 the total number must be a multiple of 5. Also, if they can stand in rows of 6 the total number must be a multiple of 6. The smallest such number is the least common multiple of 5 and 6, which is 30. So there can by 6 rows of 5-in-a-row or 5 rows of 6-in-a-row.
How does the trig function ACOS work in Excel?
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
How many ways can 180 books be arranged in rows containing an equal number of books?
1 row of 180 - 2 rows of 90 - 3 rows of 60 - 4 rows of 45 - 5 rows of 36 - 6 rows of 30 - 9 rows of 20 - 10 rows of 18 - 12 rows of 15 - 15 rows of 12 - 18 rows of 10 - 20 rows of 9 - 30 rows of 6 - 36 rows of 5 - 45 rows of 4 - 60 rows of 3 - 90 rows of 2 - 180 rows of 1 - total of 18 ways within the limits of the question
How do you measure a building in stories?
the number of rows of windows
Number of rows in Excel 2007 and the name of the last row?
The last rows of excel 2007 is 1,048,576
Number of rows in Microsoft Excel 2003?
There are 256 Columns and 65536 Rows in Excel 2003.
What is the total number of rows in Microsoft Excel 2010?
In Excel 2010 the number of rows per worksheet is 1,048,576 and the number of columns is 16,384 which is column XFD. That makes 17,179,869,184 cells.
What is the last number of rows in Microsoft Excel 2007?
1048576
What is the maximum number of rows and columns you can use in Microsoft Excel 2007?
Colums : 16384 Rows : 1048576
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.
Total number of row and column of m.s.excel?
That depends on the version. In Excel 2000 and Excel 2003, the maximum is 256 columns and 65,536 rows. For Excel 2007, the limit is 16,384 columns and 1,048,576 rows.
How many rows and columns in Excel 2000?
In Excel 97 there were 256 columns and 65536 rows.
How many rows can you have in an Excel pivot table?
as many as number of rows in the version that is used less one row for col labl. is the max no of 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.
Total number of column in Microsoft Excel?
The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.
How many rows and columns in Excel 2010?
There are 1,048,576 rows and 16,384 columns in Excel 2010
