Can not delete rows (tried everything?)

[Dart180]

Hello!


One of my sheets contain over 700,000 rows that can not be deleted. This makes it impossible to navigate the 2500 rows with text.


I have tried:


- CRTL+Shift + Down Arrow/Left Arrow --> Right Click ---> Delete.
- CRTL+Shift + Down Arrow/Left Arrow --> Right Click ---> Clear Contents.
- Editing - Clear - Clear All
- Above methods + save the workbook and restart Excel.
- Delete all macros.
- Copy the 2500 rows with text to a new workbook (!!!)


Nothing has worked.


Does anyone have a solution?

 

[Beyond_avarice]

Do you get a prompt that indicates that the workbook is protected? Can you filter for what you want?

 

[mole999]

any code on the worksheet module

can you go to the last row and delete one complete row?

 

[Dart180]

Do you get a prompt that indicates that the workbook is protected? Can you filter for what you want?

Nope.

Yes, I can filter for what I want.

 

[Dart180]

any code on the worksheet module

can you go to the last row and delete one complete row?

- You mean Modules listed in the top left corner under Visual Basics ? I just deleted all modules listed there, still no change.
- I can go to the last row (1048576) and try to delete it, but it reappear immediately.

 

[harley090]

I have tired many times， but the problem is not solved.

 

[Teeroy]

It sounds like you are trying to remove blank rows so that only data remains. You can't. Worksheets are a fixed size.

What you can do however is hide all the rows that you don't want to see (select rows, right click, Hide).

 

[Dart180]

It sounds like you are trying to remove blank rows so that only data remains. You can't. Worksheets are a fixed size.

What you can do however is hide all the rows that you don't want to see (select rows, right click, Hide).

The problem is that the scroll bar reflects all the cells, so it way too large to be able to use at all. When I try to hide the empty rows, it says "Can't push objects off the sheet"

 

[FormR]

When I try to hide the empty rows, it says "Can't push objects off the sheet"

Hi, it sounds like you have a shape or some other type of object situated way down in your worksheet somewhere.

Try pressing F5; choosing "Special" and checking "Objects" and click "OK" to see if you can locate and delete it.

 

[mole999]

I've had cell comments cause layout problems, any of those in the sheet