How do I remove a blank space on a set of address labels when u.
 

I am trying to print labels from an excel mailing list. When the label
formats for printing there is an extra space :

Name
Address

City State zip
how can I delete that space and apply it to all the labels ?

How do I remove a blank space on a set of address labels when u.
 

Hi Denise,
Assuming each piece of data is on a separate row and no blank between 2
labels:
Eg:
A1: Name
A2: Address
A3: <blank
A4: City State zip
A5: Name <---- no blank cell between A4 and A5
A6: Address
A7: <blank
A8: City State zip

-Select the column of data
-menu Edit Goto, click the Special button and choose Blank.
Now, all the blank cells in the column are selected
-menu Edit Delete, choose Entire Row.

Regards,
Sebastien

"Denise" wrote:

I am trying to print labels from an excel mailing list. When the label
formats for printing there is an extra space :

Name
Address

City State zip
how can I delete that space and apply it to all the labels ?