Your data should now be sorted alphabetically.ĭownload your data as a. Select 'sort by COMPANY' and be sure that 'A -> Z' is selected. In the 'Data' menu, select 'Sort range.'. To sort your label data, click the rectangle in the upper left corner of your spreadsheet (this will select the entire spreadsheet). Your changes will be saved automatically. Login with your gmail login if you're not already logged in.Ĭlick the 'WORK' folder, then click 'ADDRESS LABELS FOR INVOICES' file (green icon). In Chrome browser (ideally - use Firefox if you don't have Chrome) go to. csv file into the Avery label maker site (not using Excel)

Edit and sort your labels file in Google Docs (not in Excel).

Load your labels into your printer, and then save and print your document.NOTE: DO AVERY LABEL IMPORT STUFF IN FIREFOX - I DON'T THINK THE AVERY SITE IS COMPATIBLE WITH CHROME Select your whole document by clicking the 'Edit' menu option at the top of the Pages window and choosing 'Select All.' Click the 'Cell Borders' drop-down box in the Table Inspector and select 'None.' Readjust your table's height and width as needed.

Uncheck the 'Automatically resize to fit contents' box in the Table Inspector so Pages does not automatically resize your tables if you type too much text.Ĭlick the 'Cell Background' drop-down box and select 'None.'Ĭlick on each table and fill out your labels.

Adjust the Row Height in the Table Inspector to match the label height listed on your labels. Repeat for the amount of columns on your labels.Īdjust the Column Width in the Table Inspector to match the label width on your labels. Adjust the amount of Body Rows to match the amount of your label's rows. Copy the top, bottom and side margins into the Document Margins fields in the Document Inspector.Ĭlick the 'Insert' menu option in the Pages window and select 'Table Menu.'Ĭlick the 'Headers & Footer' drop-down box in the Table Inspector and set it to zero. Locate your Avery labels' measurements on the back of their sheet. Uncheck the 'Header' and 'Footer' boxes in the Document window to disable header and footer options.

(The inspector windows contain your table and document settings). Set the table inspector window next to the document inspector window. Click the 'View' menu option in the Pages window and select 'New Inspector.' Click the 'Table' button to display the table inspector window.

How to print address labels from pages