Thread: Select a range of rows to delete
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default Select a range of rows to delete
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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Donna" <Donna @discussions.microsoft.com wrote in message
...
How can I select 15,000 rows of data to delete without highlighting and
dragging down

Reply With QuoteReply With Quote