SELECTING LAST ROW

[da]

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

 

[Bob Phillips]

Rows(80).Resize(Cells(Rows.Count,"A").End(xlUp).Row-79).Delete

 

[da]

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

 

[Dave Peterson]

Manually?

Hit F5
type:
80:65536

rightclick on the selected area and choose delete

 

[da]

Thank you, it worked.

Manually?

Hit F5
type:
80:65536

rightclick on the selected area and choose delete

 

[smartgal]

You can also click on row 80, (F8) (F8 is a marking tool) and then ctrl+down
arrow. This should take you straight to the bottom. You can then delete
rows.

If you're trying to clear the area, once you delete, do a save and then do a
ctrl-end to be sure that the last "active" cell is in row 80. Good luck!

 

[Gord Dibben]

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

Select row 80 then SHIFT + End + DownArrow.

Edit>Delete


Gord Dibben MS Excel MVP

 

[Dave Peterson]

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

 

[Dave Peterson]

Depends on how the data is laid out and if there are any gaps.

 

[Gord Dibben]

Faulty assumer in action again.

Row 80 to 65536 must be blank


Gord

 

[Dave Peterson]

Or a perfect assumption--depends on what the OP really has!