Saturday, July 30, 2011

yogi_Print Mailing Labels From A Spreadsheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

new.clogger21 said:
print mailing labels from a spreadsheet
Google spreadsheet does not have a built in feature to print mailing labels ... so
1) I can use a function such as the INDEX function to setup mailing labels in multiple lines from each row of spreadsheet
2) set up the labels in multiple columns
3) set up a number of labels in each column optionally with a blank row between each label to be printed
4) in using mailing label paper such as (AVERY, HP, etc.) one needs to try a draft print on plain paper first
5) make adjustments in row heights and/or blank rows, and column widths to make sure the labels print correctly
6) once everything is fine tuned the way one wants one can go for final printing on mailing label paper

in the following illustration I set up formulas for one 5 line label and then I copied the formulas in 2 columns of 10 labels per column. For a different setup, the formulas will need to be adjusted to suit