Autofilter - Select Visible ROWS - Excel 2007

[elcentro3m]

I have several columns of data.

One column is autofiltered.

I exclude the one element I want to
keep and show the rest.

I know I can use either:

F5 / Special / Visible Cells

or

Alt-;

to select Visible Cells.

I need to select (and delete)
all visible rows (with data)
except the header row at the
top of each column.

Is there a way NOT using VBA or Macros
(since this is on behalf of a user who would like
to keep it as simple as possible) to accomplish
the same thing?

Thanx

 

[martindwilson]

auto filter then select the rows now shown with the exception of the header
right click delete row should do it

 

[taigovinda]

Yeah, what he said!

Alt+; is only needed if you have rows that are hidden *not* as the result of the autofilter.

The default behavior with rows that are autofiltered out is that they are not selected.

...Also, FYI if you didn't know, if you start to have a lot of data then it will be much faster to sort on the column in question, prior to doing the filter->delete. This is because Excel will then be deleting one (or a few) contiguous blocks instead of thousands of non-contiguous sets of rows.

 

[elcentro3m]

auto filter then select the rows now shown with the exception of the header
right click delete row should do it

Thanx all.

One last question.

This user has at least 100 visible rows if not more to select
after filtering for what she doesn't want. Is there a keyboard
shortcut simple way to select them all?