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

D

Denise

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 ?
 
S

sebastienm

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
 
Top