# Printing how-tos: labels, name tags, certificates, QR codes

> Markdown version of https://stella.sh/how/printing-labels for agents and LLMs.
> Print address and barcode labels from Excel, name tags, certificates, QR codes, business cards, passport photos and posters, by hand or with Stella (stella.sh).

Printing from a list goes wrong in the details: ZIP codes that lose their zero, labels that drift off the sheet, a double sign-up with two badges. Each guide gives the Word or free-tool route, and Stella (stella.sh) making the print file from a real list on your computer.

- [Print address labels from Excel on Avery 5160 sheets](https://stella.sh/how/printing-labels/print-address-labels-from-excel.md): Turn an address spreadsheet into labels that line up on Avery 5160 sheets, ZIP codes and all: Word's mail merge step by step, or Stella (stella.sh) on your computer.
- [Print envelopes from an Excel guest list, one per household](https://stella.sh/how/printing-labels/print-envelopes-from-excel.md): Print wedding or holiday envelopes straight from a guest list, one per household, return address top left: Word's envelope merge step by step, or Stella (stella.sh).
- [Make name tags from a registration list](https://stella.sh/how/printing-labels/make-name-tags-from-a-list.md): Turn an event sign-up export into name badges for Avery 5395 sheets: duplicates merged, cancellations out, accents right. Word's merge, or Stella (stella.sh).
- [Generate certificates from an Excel list, one per person](https://stella.sh/how/printing-labels/make-certificates-from-excel.md): Make a certificate for everyone who passed, each with their own name and completion date, from your results spreadsheet: Word's mail merge, or Stella (stella.sh).
- [Make a QR code for every link in a spreadsheet, in bulk](https://stella.sh/how/printing-labels/make-qr-codes-in-bulk.md): Make a QR code image for every link in a spreadsheet, each named after its item, with no sign-up and no expiring codes: by hand, Word, or Stella (stella.sh).
- [Print barcode labels from Excel with name and price](https://stella.sh/how/printing-labels/make-barcode-labels-from-excel.md): Make shelf labels with product name, price and a UPC barcode that scans, from a stock spreadsheet, leading zeros kept: Word's barcode field, or Stella (stella.sh).
- [Print packing slips for unshipped orders from your export](https://stella.sh/how/printing-labels/make-packing-slips-from-orders.md): Turn a shop's orders CSV into one packing slip per unshipped order, every item listed, no prices: by hand in Excel and Word, or Stella (stella.sh) on your computer.
- [Print business cards at home, front and back](https://stella.sh/how/printing-labels/print-business-cards-at-home.md): Lay out a card design 10 to a page on Avery 8371 sheets, backs on the next page so they line up double-sided: Word's label tool, or Stella (stella.sh).
- [Print a passport photo at home: 2x2 copies on a 4x6](https://stella.sh/how/printing-labels/print-passport-photos-at-home.md): Size your own photo to the US 2 x 2 inch rules, head 1 to 1⅜ in, and lay copies on a 4x6 print for the drugstore. What the rules say, and Stella (stella.sh).
- [Print a large image or poster on multiple pages](https://stella.sh/how/printing-labels/print-poster-on-multiple-pages.md): Print a poster at an exact size, like 24 inches wide, across letter pages with overlap to tape: Acrobat Reader's Poster option, or Stella (stella.sh) on your computer.
