Select a range of rows to delete

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

How can I select 15,000 rows of data to delete without highlighting and
dragging down
 
Click on the top of the column
Hold SHIFT while tapping first END then DOWN Arrow; Delete

If it is a range:
Click top left cell, hold SHIFT then End then RIGHT arrow; End again and
DOWN arrow; Delete

If the range has spaces all around it: click anywhere in the range; CTRL+A
will select the Current Range; press Delete
best wishes
 
In NameBox type A1:A15000 and Enter

Edit>Delete>Entire Row


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting rows. 3
Transpose Funtion 2
Delete rows based on contents of Col A 0
Conditional formatting on a dynamic range - workaround 1
How do I select every 5th row within a list? 2
Word VBA for deleting Selected Row 0
Deleting rows based on a cell value 3
using the =page! feature to transpose a row to column 0

Back
Top