Go To cells not visible

[Lynn]

Using the Go To --> Special command, I can select only the
visible cells within a range. Is it possible to select
only the cells NOT visible within a range? (Eg. I want to
delete the contents of the invisible cells only)

 

[Lynn]

Thanks for your suggestion...I will try it out.

-----Original Message-----
No, it isn't.

If you don't need to preserve the empty cells after

clearing them, you could just copy the

visible cells to another area.

If you DO need to preserve the blank cells, you one way would be:

- set up a helper column, say K
- with the filter applied, insert "X" column K
type X in top cell and copy down -- it will go into only the visible cells
- remove the filter
- apply a new filter that selects blanks in column K
- select all of the visible cells and press the Del key to clear them
- remove the filter and delete the helper column.