✦Template Printable Ideas Insights

How to Print Avery 5160 Labels in Excel

By

Looking to print Avery 5160 labels directly from Excel? You're in the right place. Avery 5160 labels are a versatile 2 x 4 inches rectangular label perfect for various purposes such as address, shipping, or file labels. Let's walk you through the simple process of printing these labels using Microsoft Excel.

Before we begin, ensure you have a compatible printer and Avery 5160 label sheets. These labels are pre-cut, so they fit perfectly in most standard and laser printers. Now, let's dive into the step-by-step guide.

Preparing Your Excel Worksheet

Preparing your Excel workbook correctly is crucial for accurate label printing. Here's how:

an image of a computer screen with the names and numbers on it in microsoft's office window
an image of a computer screen with the names and numbers on it in microsoft's office window
Microsoft Word Label Templates Avery 5160
Microsoft Word Label Templates Avery 5160
Use Excel's Power to Print Labels in No Time
Use Excel's Power to Print Labels in No Time

1. **Label Size and Orientation**: Set your page size to 'Custom' and dimensions to 8.5" x 11" (standard Letter/A4 size). Under 'Orientation', select 'Portrait'.

Creating a Label Template

Create a table in your worksheet for the label data. For Avery 5160, you'll have 20 labels per sheet, organized in 4 columns and 5 rows.

Creating Labels from a list in Excel
Creating Labels from a list in Excel
Avery.com Templates 5160 Free Avery Label Template 5160 Word | williamson-ga.us
Avery.com Templates 5160 Free Avery Label Template 5160 Word | williamson-ga.us
Avery Template 5163 Shipping Labels 2
Avery Template 5163 Shipping Labels 2

1. **Column Width**: Set your column widths to fit your label content. For instance, 'A' can be 1.5" for first-line content, 'B' can be 0.75" for line two, etc.

2. **Row Height**: Set row heights to 1.5" for ample space between labels.

Entering Your Label Data

Now, input your data into the cells. You can manually enter each label's information or use spreadsheet formulas to pull data from other workbooks or databases.

How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)
How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)
How to Use Mail Merge with Avery Products
How to Use Mail Merge with Avery Products
Avery Template 5160 Address Labels 1
Avery Template 5160 Address Labels 1
Free Blank Label Templates Online
Free Blank Label Templates Online
Avery 5160 Address Labels from Google Sheets
Avery 5160 Address Labels from Google Sheets
the printable labels dialogle is highlighted in the text box below, which indicates that each label has been changed
the printable labels dialogle is highlighted in the text box below, which indicates that each label has been changed

Tip: Use the 'Sort' and 'Filter' features to organize your data before printing.

Printing Avery 5160 Labels

Ready to print? Here's how to configure your printer settings:

1. **Click 'File' > 'Print'.**

How to Make Address Labels Using an Excel Spreadsheet | Techwalla
How to Make Address Labels Using an Excel Spreadsheet | Techwalla
Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
How To Create Blank Avery 5160 Free Template
How To Create Blank Avery 5160 Free Template

Setting Printer Properties

Under 'Printer', select your label printer. Click on 'Properties' or 'Printer Properties' to open the dialog box.

1. **Media Type**: Select 'Labels'.

2. **Header/P Footer**: Ensure it's set to 'blank' to avoid printing Excel headers and footers.

3. **Click 'OK' to return to the print screen.

Final Print Configuration

1. **Paper Size**: Ensure it's set to 'Custom, 8.5 x 11 inches'.

2. **Margins**: Set all margins to 'None'.

3. **Scaling**: Select 'Fit to page width' to ensure the correct number of labels per sheet.

4. **Click 'Print Preview' to check your settings, then click 'Print'.

And there you have it! Your Avery 5160 labels are now printing in a breeze.