View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Keyboard Navigation - selecting non-adjacent rows

Surely there is something in each row that would allow you to decide which rows
to select for deletion.

How do you decide by eyeball which to delete?

You should be able to filter to find these rows.


Gord Dibben MS Excel MVP

On Tue, 6 Nov 2007 09:23:01 -0800, Katie
wrote:

Good Afternoon -

I am looking to navigate with keyboard only to highlight multiple rows to be
able to delete these rows.

For instance, I need to manually go through and decide in a 2000 row sheet
and delete almost half of the rows, but in no consistent pattern.

Is there keyboard shortcuts to select a row (Control + spacebar) and then be
able to highlight to a new row and select that as well?