Follow the steps below to easily make labels on Google Sheets.
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.
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.
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.
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.
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.
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.
