In this article:

How to Make Labels on Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Make Labels on Google Sheets

Follow the steps below to easily make labels on Google Sheets. 

1. Input Label Information into Google Sheets Columns

Input your label details into Google Sheets. For this example, we will use the following information: First Name, Last Name, Address Line 1, City, State, Zip Code for the columns.

labels on sheets

2. Insert a Table in Google Docs to Match Label Layout

Open Google Docs and start a new document for your labels. Decide on the label size and how many labels you want per page. Then, insert a table that matches your label layout. For standard address labels, a table with 2 columns and 4-5 rows often works well, but adjust based on your label size and sheet.

how to make labels on google sheets

3. Transfer Label Data from Google Sheets to Google Docs Table

Go back to your Google Sheets, copy the data you want on your labels, and paste it into the table cells in Google Docs. You might need to adjust the text formatting and cell sizes to fit your labels properly.

labels on google sheets

4. Customize Table Dimensions in Google Docs for Your Labels

Right-click on the table in Google Docs and select "Table properties."

Here, you can adjust cell padding to zero and change the column width and row height to match your label dimensions. This step requires knowing the dimensions of your labels.

5. Apply Text Formatting Within Table Cells for Readability

Highlight the text in each cell and format it according to your preferences (font size, type, alignment). This ensures that the text fits well within each label.

6. Conduct a Test Print on Regular Paper to Check Alignment

Once your labels look good in Google Docs, load your printer with label sheets. Then, print a test page on regular paper first to ensure the alignment matches your label sheets. Adjust as necessary. After confirming the test page aligns well with your label sheets, print your labels on the actual label sheets.

We hope that you now have a better understanding of how to make labels on Google Sheets. If you enjoyed this article, you might also like our article on how to use the LAMBDA function Google Sheets or our article on how to copy only visible cells in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->