View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sebastienm sebastienm is offline
external usenet poster
 
Posts: 694
Default 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 ?