How to Print Labels from Google Sheets

Evelyn Jul 09, 2026

Ever found yourself in a situation where you need to print labels directly from Google Sheets? Whether you're a small business owner, an event planner, or simply someone who needs to create and print labels for personal use, Google Sheets can streamline this process. Here's a step-by-step guide on how to print labels from Google Sheets, ensuring your labels are perfectly formatted and ready to use.

How to Print Labels from Google Sheets
How to Print Labels from Google Sheets

Before we dive into the process, make sure your labels are designed in a way that fits your printer's capabilities. You can use Google Drawings or other design tools to create your label templates, then import them into Google Sheets. Once your labels are set up, let's get started.

Free: Create Avery Address Labels in Google Docs
Free: Create Avery Address Labels in Google Docs

Preparing Your Google Sheets

To begin, open your Google Sheets document containing the data you want to print on your labels. Ensure that your data is organized in columns, with each row representing a single label. This will make it easier to select and format your data for printing.

How to Make Labels in Google Docs
How to Make Labels in Google Docs

For instance, if you're printing address labels, your columns might include fields like Name, Street, City, State, and Zip Code. Make sure each column header is clearly labeled for easy reference.

Formatting Your Data

How to make printable labels for FREE (using Canva)
How to make printable labels for FREE (using Canva)

Before printing, it's crucial to format your data correctly. This includes adjusting column widths, merging cells if necessary, and ensuring that text wraps correctly within each label. To adjust column widths, hover your cursor over the line between two column headers until the double-sided arrow appears, then click and drag to resize.

To merge cells, select the cells you want to merge, then click on "Format" in the menu, followed by "Merge cells." If your text doesn't wrap correctly, you can adjust this by clicking on "Wrap text" in the toolbar that appears when you select a cell.

Adding Borders and Background Colors

How to Create Mailing Labels in Google Docs
How to Create Mailing Labels in Google Docs

To make your labels stand out and look more professional, you can add borders and background colors to your data. To add a border, select the cells you want to border, then click on "Borders" in the toolbar. Choose the style you prefer and click "Apply."

To add a background color, select the cells you want to color, then click on "Fill color" in the toolbar. Choose the color you want and click "Apply." Remember to apply these formatting changes to the entire column or range of cells, not just the header row.

Printing Your Labels

Google Sheets Checklists
Google Sheets Checklists

Once your data is formatted correctly, it's time to print your labels. Before you begin, make sure your printer is connected and has enough ink or toner. Also, ensure that your label paper is loaded correctly, with the adhesive side facing down.

To print, select the range of cells you want to print, then click on "File" in the menu, followed by "Print." A print preview window will open. Here, you can adjust the print settings to ensure your labels are printed correctly.

Create Custom Color Swatches for Google Drive
Create Custom Color Swatches for Google Drive
Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
15+ Ways for Teachers to Use Google Sheets in the Classroom - SULS0187
15+ Ways for Teachers to Use Google Sheets in the Classroom - SULS0187
How to Make an Address Book with Google Sheets
How to Make an Address Book with Google Sheets
Free Blank Label Templates Online
Free Blank Label Templates Online
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier
How to Create Barcode on Google Sheets, Generate Barcode for Free, Infographic
How to Create Barcode on Google Sheets, Generate Barcode for Free, Infographic
a screenshot of a spreadsheet with multiple columns and numbers on the screen
a screenshot of a spreadsheet with multiple columns and numbers on the screen
Google Sheets Customization Tips ✨ Make Your Spreadsheets Beautiful & Functional
Google Sheets Customization Tips ✨ Make Your Spreadsheets Beautiful & Functional
LabelCanvas V1.0 Google Sheets Label Maker - Barcode, Custom Templates (Digital Download)
LabelCanvas V1.0 Google Sheets Label Maker - Barcode, Custom Templates (Digital Download)
How to use an Excel spreadsheet in Google Sheets (access from any device, anytime) or Numbers for Ma
How to use an Excel spreadsheet in Google Sheets (access from any device, anytime) or Numbers for Ma
How to make a monthly calendar printable using Google Sheets (online tool similar to Excel)
How to make a monthly calendar printable using Google Sheets (online tool similar to Excel)
Pinned Notes, Labels, and Checklists with Google Keep
Pinned Notes, Labels, and Checklists with Google Keep
Use Excel's Power to Print Labels in No Time
Use Excel's Power to Print Labels in No Time
How to Create Barcodes in Google Sheets
How to Create Barcodes in Google Sheets
How to make a weekly planner using Google Sheets (free online tool)
How to make a weekly planner using Google Sheets (free online tool)
Google Docs Free Checklist Template
Google Docs Free Checklist Template
The Ultimate Organization Hack: Google Sheets Checklists for Teachers - Learning Lattes and Literacy
The Ultimate Organization Hack: Google Sheets Checklists for Teachers - Learning Lattes and Literacy
How to Auto Sort in Google Sheets
How to Auto Sort in Google Sheets
How to Add a Drop-Down List in Google Sheets and Excel - Make Tech Easier
How to Add a Drop-Down List in Google Sheets and Excel - Make Tech Easier

Adjusting Print Settings

In the print preview window, look for the "Scale" option. This allows you to adjust the size of your labels to fit the paper. Most label printers use standard label sizes, so you can usually leave this at 100%. However, if your labels are not printing correctly, try adjusting this setting.

You can also adjust the "Margins" setting to ensure that your labels are printed correctly. Most label printers require a specific margin to ensure that the labels are printed in the correct position. Check your printer's manual for the recommended margins.

Printing and Previewing

Once you've adjusted the print settings, click on "Print" to begin printing your labels. If you want to preview your labels before printing, click on "Print preview" instead. This will show you a preview of how your labels will look when printed.

If you're satisfied with the preview, click "Print" to begin printing your labels. Make sure to print in draft mode if you're only printing a small number of labels to save ink. Once your labels are printed, you can peel them off the sheet and use them as needed.

Printing labels from Google Sheets can save you time and effort, especially if you need to print multiple labels with the same design. By following these steps, you can create and print professional-looking labels directly from your Google Sheets document. Happy printing!