How To Print Labels On Google Sheets With Pictures

If you already have an address list in Sheets, follow along with this method to make sure the format is correct.

For example, if you want your labels to contain a United States resident’s name, address, city, state, and zip code, you may call A1 NAME, B1 STREET, C1 city, D1 state, and E1 zip.

The options all begin with a 4-digit number that corresponds to an Avery product—if you’re printing to genuine Avery address stickers, refer to the packaging to find the correct sheet number. If you’re using a different brand of label sheets, find the option that best matches what you have.

Make sure each column header name is on its own row or else the address will print as a single line.