From Hdwiki

Microsoft Excel

Microsoft Excel is a spreadsheet program within the Microsoft Office suite.

FAQ

A great tool in Microsoft Excel is Microsoft Excel Help. This icon can be found in the Standard toolbar at the top of the page. The icon is a blue circle with a question mark inside it. If you click on this icon, it will open Excel Help on the right side of your screen. Here, you can search for almost any topic within Excel. For example, if you wanted to know how to add a formula, you could type in "add a formula." It will then pull up numerous topics related to this, one of which would be "Enter a 'formula." If you click on this, it will open another box with instructions of how to do this. The Excel Help box is a great tool for questions you may have about using your Excel.

Creating a Distribution List from an Excel Spreadsheet

Create the list of information in Excel

1. Create an excel spreadsheet.
2. Open or create the file in Excel.
3. Select File, Save As and save the file as a .csv file.
4. Save it in a location where it will be easy to find later (like your desktop).
5. Close the file.

Bringing the information into Outlook

1. Open Outlook and click on Contacts in the Outlook Shortcuts Bar.
2. On the File menu, select New and then Folder.
3. Enter a name for your new folder and click OK. (You don’t need to add a shortcut to the Outlook Bar.)
4. Click on your new folder to open it.
5. Click on File, then Import and Export.
6. Click on Import from another program or file. Then click Next.
7. Select Comma Separated Values (Windows), then Next.

• Note: If you receive the message ‘Microsoft Outlook cannot start the Import/Export engine. This feature is not currently installed. Would you like to install it now?’ then click on ‘Yes’.

1. Browse to select your .cvs filename that you created with Excel and then click Next.
2. Select the folder you created in Outlook for the new contacts; Click Next.
3. Select the Import list (it will be highlighted when selected) and check the check box beside it.
4. Click on the Map Custom Fields button. Match up the fields in your .cvs file with the fields in the Outlook New Contact List. Follow the directions at the top of the window to map (match up) the fields. Click the + beside the field Name on the Microsoft Outlook side to see the parts of the name.
5. Once you have mapped your fields to the Microsoft Outlook fields, click OK.
6. Click Finish. Outlook should create a contact for each row in the spreadsheet.

Creating the distribution List

1. If Contacts isn’t already open, select Contacts in the Outlook Shortcuts list.
2. Click on the folder that contains the contacts you want to use to create the distribution list.
3. Below the main menu, select the down arrow beside New, Select Distribution List.

1. Enter the name for your list
2. Click on Select Members.
3. Click the down arrow beside Show names from the: dialog box to see the folder with the contact names.

1. Select the contacts folder where you imported the list of contacts.
2. Select the first contact name in the list, hold down the Shift key and click on the last name. All

the names in the list should be selected.

1. Click on Members ->.
2. Click OK
3. Click on Save and Close. All of the selected names should be a part of the distribution list.

• If you want to use some of the names on the contact list but not all of them, select the first

contact name in the list, hold down the Ctrl key, click on each additional contact you want to include on the list. Each one you click on will be selected (highlighted). Click Members. Click OK. Click on Save and Close.

Using your Distribution List

To send email to the new distribution list, right click on the list in the contacts folder where you created it. From the drop down menu, select New Message to Contact. Create your email message and click Send.

Notes

When you add new folders under the Contacts folder, you may need to change their properties so that they appear in the list of Contacts folders when you try to use them. Right click on the new folder you have created. Select Properties Click on the Outlook Address Book tab. Check the box Show this folder as an e-mail Address Book if it is not checked. Click OK.

Other Excel Needs

Highlight Every Other Row or Column

1. Select the range of cell that you want to format.
2. Got to the Formatting Rule options (Home Tab > Conditional Formatting > Highlight Cells > More Rules) and choose the format you want to apply to every second row by clicking the Format button.
3. Select “Equal to” in the second box, and Enter the formula: =MOD(ROW( ),2) into the third box of the “Format only cells with” section. The same formula is used for columns, only replacing "ROW" with "COLUMN"
4. The format you specified should be applied to every second row in the range you selected at the beginning.

• This page was last modified 16:34, 20 August 2008.
• This page has been accessed 4,051 times.