0
You can delete the actual row by selecting it and using the Delete rows option. That will also delete the data. If you just want to get rid of the actual banding and keep the data, you can select the rows and change the formatting, and set it to be the same as the other rows.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is the effect called in Excel that displays alternate rows with color?
They are banded rows.
What is another name for rows that alternate shading on the rows in Excel 2013?
They can be called banded rows.
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.
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.
How many rows and columns are there in Microsoft Excel 2000?
There are 256 Columns and 65,536 Rows in Excel 2000.
Number of rows in Excel 2007 and the name of the last row?
The last rows of excel 2007 is 1,048,576
Are the rows and columns in Excel infinite?
No. In versions up to Excel 2003 there are 256 columns and 65,536 rows. From 2007 on, there are 16,384 columns and 1,048,576 rows.
