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.

"Melissa M" wrote:

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

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,
--
Farhad Hodjat


"bj" wrote:

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.

"Melissa M" wrote:

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