G
Guest
I used Advanced Filter (show unique records only) on a list of ~2700 records
of which about 20 were unique. I had copied the data to a new sheet then
filtered it (I did not chose "Filter in new location"), resulting, as
expected, in several "hidden" rows. I then realized that this was the wrong
set of data, so I deleted the column holding the data. Now, for whatever
reason, I cannot "unhide" the rows that were hidden when I executed the
filter. I have tried Data->Filter->Show All; highlighting the rows and
selecting "Unhide"; highlighting rows and changing row height. Nothing is
working.
The only thing that does work is individually changing the row height by
dragging the cursor from the bottom of the hidden rows.
Any ideas?
of which about 20 were unique. I had copied the data to a new sheet then
filtered it (I did not chose "Filter in new location"), resulting, as
expected, in several "hidden" rows. I then realized that this was the wrong
set of data, so I deleted the column holding the data. Now, for whatever
reason, I cannot "unhide" the rows that were hidden when I executed the
filter. I have tried Data->Filter->Show All; highlighting the rows and
selecting "Unhide"; highlighting rows and changing row height. Nothing is
working.
The only thing that does work is individually changing the row height by
dragging the cursor from the bottom of the hidden rows.
Any ideas?