How do I delete hidden records/rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a file in which random records were hidden. Trying to do a mail
merge document - but don't want these hidden records showing up. How do we
delete them, without having to go through the entire spreadsheet manually?
Thank you.

Melissa
 
I think I lost my reply
if it is rows which were hidden
use a helper column
enter "1" at the top of the column and copy
select the column
<edit><go to><special> select visible cells only
paste
select all
<format><rows> <unhide>
select the helper column
<filter><autofilter>
in the arrow box in the top cell of the column select "blanks"
delet all but the top row
remove the auto filter
delete the helper column.

if it was other than rows you hid, let us know what and how you hid. there
is probably a method which will work.
 
Hi,

you don't need helper column just select all cells you wat to copy and then:
<edit><go to><special> select visible cells only

and copy then go to another sheet and paste

Thanks,
 
Back
Top