Clearing out blank rows/columns
 

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.

Clearing out blank rows/columns
 

Try using 'Edit', 'Clear', 'All'

"SteveDB1" wrote:

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.

Clearing out blank rows/columns
 

try saving and re opening the file after you delete. Excel remembers things
whle it is open, even when you don't want it to.

"SteveDB1" wrote:

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.

Clearing out blank rows/columns
 

Hi.
I'd actually done that, and it still went to the end of the worksheet
showing there was something in the specific cell.
However, about 20 minutes after I'd initially posted, the "prescribed fix"
took, and I could once again insert rows.
Is this just one of those "quirky Excel things?"
Thanks-- both Forest, and BJ.


"bj" wrote:

try saving and re opening the file after you delete. Excel remembers things
whle it is open, even when you don't want it to.

"SteveDB1" wrote:

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.