Remove infinite blank rows in Excel 2007
Solved
jafran
Posted messages
126
Registration date
Status
Membre
Last intervention
-
jafran Posted messages 126 Registration date Status Membre Last intervention -
jafran Posted messages 126 Registration date Status Membre Last intervention -
Hello,
On Windows 7, with Excel 2007, I have a small table of about fifty rows. Probably due to a false maneuver, I find myself with formatted (bordered) cells in the sixth column over an infinite number of rows.
The cursor for the table is ridiculously small as if my table had an infinite number of rows. I would like to remove all this formatting.
I have read numerous messages explaining that the removal is done by selecting the rows, then clicking "Delete Rows" in the "Home" tab, and especially not forgetting to save, close, and then reopen the file.
If this allows for a more appropriate cursor size relative to the table, it does not remove the formatting, and my cells in column 6 are still bordered infinitely.
Note:
- When I press CTR + End, it is clear that I do not go all the way to the last formatted row: it places the cursor on row 3569, but if I scroll down, I find even more rows where column 6 is bordered.
Thank you in advance for your insights.
Configuration: Windows 7 / Firefox 7.0.1
On Windows 7, with Excel 2007, I have a small table of about fifty rows. Probably due to a false maneuver, I find myself with formatted (bordered) cells in the sixth column over an infinite number of rows.
The cursor for the table is ridiculously small as if my table had an infinite number of rows. I would like to remove all this formatting.
I have read numerous messages explaining that the removal is done by selecting the rows, then clicking "Delete Rows" in the "Home" tab, and especially not forgetting to save, close, and then reopen the file.
If this allows for a more appropriate cursor size relative to the table, it does not remove the formatting, and my cells in column 6 are still bordered infinitely.
Note:
- When I press CTR + End, it is clear that I do not go all the way to the last formatted row: it places the cursor on row 3569, but if I scroll down, I find even more rows where column 6 is bordered.
Thank you in advance for your insights.
Configuration: Windows 7 / Firefox 7.0.1
