Faulty assumer in action again.

Row 80 to 65536 must be blank


Gord

On Fri, 01 Aug 2008 15:36:03 -0500, Dave Peterson
wrote:

That might not go all the way to the bottom of the data (or the bottom of the
worksheet).

Select A80
then ctrl-shift-end
will select A80 through the last used cell on the sheet (also not usually the
last row in the worksheet).

Then Edit|delete|entire row

Gord Dibben wrote:

I find Dave's method best but there is a keystroke method.

Select row 80 then SHIFT + End + DownArrow.

EditDelete

Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 09:38:14 -0700, da wrote:

Sorry, but I don't understand what you wrote.
Is there any keys I can use to select all the rows from row 80 to row 65556,
which is last row? There is some format and lines which I want to delete.
Thanks

"da" wrote:

How do I select and delete row 80 to the last row which is 65,000?