creating labels from excel spreadsheet

  • Thread starter Thread starter SHARON
  • Start date Start date
S

SHARON

i have a spreadsheet with 5 columns of data that contain address information.

Ex. column A = name, column B = Company, column c = Street etc.
How do i get those columns to come together and be able to print them onto
Avery mailihng labels?
 
If you want them combined in one line use the & symbol: Example

=A1&" "&B1

The " " is to insert a space.

This will give you the contents of cell A1 then a space then the contents of
B1

However, it would probably be easier to use the mailmerge in Word, you can
use the contents of an Excel spreadsheet for the data.

To try and print labels in Excel is difficult as the cell sizes change when
information is entered.

To avoid this, set your cell format under alignment tab to shrink to fit,
once you have created your template.
 
Back
Top