In this article:

How to Make Labels on Google Sheets (Easiest Way in 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.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started