how do I delete hidden rows or columns without doing it manually?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eastman22 - 18 Jun 2007 16:33 GMT

I have already hidden rows (from the subtotal function) and I would like to
delete the hidden ones (ex. level 2 in subtotals). How do I do this without
going line by line?

Reply to this Message

bj - 18 Jun 2007 16:52 GMT

select a blank column
enter 1 in the top cell
copy that cell
select the column
edit-goto-specal-visible cells
paste
select all format-cells-unhide
select the same column as before
filter-autofilter
select blanks
format-delete rows

> I have already hidden rows (from the subtotal function) and I would like to
> delete the hidden ones (ex. level 2 in subtotals). How do I do this without
> going line by line?

Reply to this Message