Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amiyaya
 
Posts: n/a
Default how do I create address labels from excell sheet?

I have several columns which arent needed which i have hidden, but i have
about 1000 addresses which I need to print in address label format. How do I
do it because it is taking hours to do each one by hand!
  #2   Report Post  
Posted to microsoft.public.excel.misc
BekkiM
 
Posts: n/a
Default how do I create address labels from excell sheet?

Use Mail Merge with Word. Just pick the label template you need (the wizard
will walk you through it) and use your Excel spreadsheet for your source data.

"Amiyaya" wrote:

I have several columns which arent needed which i have hidden, but i have
about 1000 addresses which I need to print in address label format. How do I
do it because it is taking hours to do each one by hand!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Address Labels in Excel Mandy Banks Excel Discussion (Misc queries) 4 December 30th 05 07:20 PM
How do I change spread sheet data into address labels? DS New Users to Excel 5 January 22nd 05 11:23 PM
How can I import addresses in Excel over to address labels in Wor. Eskielover Excel Discussion (Misc queries) 3 January 21st 05 02:09 AM
How do I insert a scroll bar into the excell sheet? Jason S Excel Worksheet Functions 2 December 1st 04 01:08 AM
HOW DO I ENTER TWO NAMES IN ONE ROW FOR ONE ADDRESS FOR LABELS sheilam Excel Discussion (Misc queries) 1 November 30th 04 03:12 PM


All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"