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