Hi all.
I want to inset 4 rows. In so doing, I get an error message telling me that
it cannot insert rows into non-blank cells. It also states that if the cells
are blank, I can reset the cells that Excel considers non-blank.
I.e., press ctrl+end and it takes me to the last non-blank cell on the
worksheet.
I then delete the entire region of cells that are blank, and click save-- as
stated.
I then press ctrl+end again, and it takes me to the same cell that I'd
previously deleted.
I've now done this numerous times, and get the same results-- yes, I know,
the definition of insanity.
All I want to do is to insert rows. I don't need anything fancy.
And yes, there are 64,475 blank rows beneath my data, as well as 168 columns.
So, this tells me that I should have plenty of room to insert of rows.
How can I clear out cells that are in fact blank, no data, no specific
formatting-- that I've performed, and no discernable information that would
tell me that the cells it's referencing are not blank.
Thanks.