Unable to insert a row in Excel
Solved
Dartagnan
-
Dartagnan -
Dartagnan -
Hello,
I just consulted several forums on this topic, but I can’t find anything, and I feel like I’m facing a mystery.
I’m trying to insert a row in Excel, but it doesn’t work on the grounds that it can’t move rows outside the table.
I delete all the last rows, formats, formatting, etc... it works once but not twice.
On the last row (65536), I still see that the first 4 cells (columns A to D) have the same color pattern as the header row (row 1).
I check what’s happening by unfreezing panes:
Deleting row 65536 => OK, it turns white again
Deleting a row before 65536 => the 4 colored cells come back!
Deleting 10 rows: the last 10 rows up to 65536 always take this color!
Mystery and nonsense!
These colors seem to come from nowhere, except from a phantom row 65537...
I’ve checked everything, conditional formatting, event macros, none of that.
I changed the format of the first row: nothing, those 4 colors always come back.
Who has an idea?
I just consulted several forums on this topic, but I can’t find anything, and I feel like I’m facing a mystery.
I’m trying to insert a row in Excel, but it doesn’t work on the grounds that it can’t move rows outside the table.
I delete all the last rows, formats, formatting, etc... it works once but not twice.
On the last row (65536), I still see that the first 4 cells (columns A to D) have the same color pattern as the header row (row 1).
I check what’s happening by unfreezing panes:
Deleting row 65536 => OK, it turns white again
Deleting a row before 65536 => the 4 colored cells come back!
Deleting 10 rows: the last 10 rows up to 65536 always take this color!
Mystery and nonsense!
These colors seem to come from nowhere, except from a phantom row 65537...
I’ve checked everything, conditional formatting, event macros, none of that.
I changed the format of the first row: nothing, those 4 colors always come back.
Who has an idea?
2 réponses
Hello,
Start by confirming your version of Excel, probably 2000 or 2003
A common problem is that the user applies a format or coloring to the entire sheet when it should be applied to a specific range.
To provide an accurate answer, I would need your file, but if it's what I think it is, it must be very large (right-click the file icon/properties and let us know its size)
--
See you
Mike-31
A period of failure is an ideal time to sow the seeds of knowledge.
Start by confirming your version of Excel, probably 2000 or 2003
A common problem is that the user applies a format or coloring to the entire sheet when it should be applied to a specific range.
To provide an accurate answer, I would need your file, but if it's what I think it is, it must be very large (right-click the file icon/properties and let us know its size)
--
See you
Mike-31
A period of failure is an ideal time to sow the seeds of knowledge.
Otherwise, to get out of it, you need to reselect all the colored areas and choose "no fill," and fortunately, the absence of color is not considered as white!
And that's it, we're back on track!
The incident is closed...