how to print address labels from excel worksheet

To make the column widths match their data do Ctrl+A (select ALL) and go to Home> Cells> Format> AutoFit Column Width. Choosing a smaller, narrower font also helps. This can help make all columns fit on a page. If you want to print your Excel spreadsheet/database, it's usually best to do it 'sideways' by going to Page Layout> Orientation> Landscape.( If you don't see extensions on any of your file names - such as. By default, it will be saved in your My Documents folder. Name the document something like Holiday Address List. Click on the Office Button and choose Save As> Excel Workbook. A simple database is a table of rows and columns, which are called 'Records' and 'Fields.' A row above the fields in our databese will contain 'Headers' (such as FirstName, LastName, StreetAddr, City, State, and Zip).We'll start by creating a 'database' of names and addresses using an Excel-2007 spreadsheet.

Therefore, this tutorial is a simple and straightforward set of instructions for placing the names and addresses in an Excel-2007 file, followed by formatting the actual print-outs of the labels with Word-2007. The type of mailing list I receive the most questions about is a collection of friends and family to whom a person wants to send holiday greeting cards.

This tutorial is intended for Microsoft Office 2007 users who have a list of names and addresses for which they would like to print adhesive mailing labels.

How to print address labels from excel worksheet