Hi

I have just tried this with XL2007 and I get inconsistent results.
Sometimes it does behave exactly like XL2003 and only clears the
contents of the visible cells, and sometimes it clears everything
between the first and last visible rows.

Having applied the Autofilter, selected the rows required, if I right
click and choose Clear Contents it "seems" to behave correctly. If I
press the Delete button, it usually clears the lot.

So far, I have not been able to determine exactly what conditions cause
it to work consistently.

--
Regards

Roger Govier


"Merv" wrote in message
...
This one puzzles me. In Excel 2003, using the filter command, I could
select
a range of visible cells and delete or clear the contents of those
cells
without deleting or clearing the contents of the hidden cells which
had been
filtered out of view. I find that the same action now in Excel 2007,
causes
both visible and hidden cell data to be deleted/cleared. Question: is
there
a setting to correct this?