Sunday, February 17, 2013

How to Make a Alphabetized Mailing List in Microsoft Excel


1. Launch Microsoft Excel 2010.
2. Type 'First Name' in the top cell in the first column (Cell 'A1') and press 'Tab' on the keyboard to save the contents of the cell and move to the top cell in the second column (Cell 'B1').
3. Type 'Last Name' in the top cell in the second column and press 'Tab' to save the contents of the cell and move to the top cell in the third column. Continue this pattern for 'Address 1,' 'Address 2,' 'City,' 'State' and 'Zip.' Add other fields as needed and add their title to the top row.
4. Right-click on the letter at the top of the column which contains the zip code. Click 'Format Cells' from the context menu. Click 'Special' in the 'Category' column and click 'Zip Code' or 'Zip Code 4' in 'Type.' Change the locale if necessary and press 'OK' to save the changes.
5. Click or navigate to the second cell in the first column (Cell 'A2') and type in the first name of the first person or business on the mailing list. Press 'Tab' to move across the columns and fill in all of the available information. Press 'Tab' twice to leave a cell blank if necessary.
6. Fill in all of the addresses and click 'File' and 'Save As' to name and save the file.
7. Click the letter 'A' above the first column and hold down the mouse button. Drag the mouse across the top letter of each column that contains data to select them.
8. Click 'Data' from the ribbon at the top of the program and click 'Sort' from the 'Sort Filter' group.
9. Click the arrow in the 'Sort By' and change the selection to reflect the column which is to be sorted by, such as 'Last Name' or 'Zip Code.'
10. Click the arrow in the 'Order' group and choose whether to sort in ascending or descending mode. Click 'OK' to sort all selected cells as a group.

Blogger news