How to Make Labels Through Microsoft Excel

1. Open a blank worksheet in Microsoft Excel.
2. Begin by entering column headers for each field of data in your list of addresses. Click in cell A1 and type 'First Name.' Press 'Tab' to go to the next column. Enter 'Last Name.' Continue tabbing over and entering the column headers for street address 1, street address 2, city, state and ZIP code.
3. Click cell A2. Enter the first name of the first person in your address list. Tab over to add the rest of their address information in the corresponding column. Each row will be one individual address record.
4. Press 'Enter' to move to the next row down. Continue adding address information in each cell until you have completed the address list.
5. Save the document. Give it a file name and location you will remember, as you'll need to use the document later.
6. Open a blank document in Microsoft Word.
7. Click the 'Mailings' tab. Click 'Start Mail Merge,' then 'Labels.'
8. Choose the type of printer you'll be using to print the labels. Select the vendor for the label sheets you're going to use. Select the product number listed on the packaging of the label sheets. Click 'OK.' The labels will be set up as a table in your Word document.
9. Click 'Select Recipients' on the 'Mailings' tab. Click 'Use Existing List.' Select the Excel file you just saved to connect to it.
10. Click 'Edit Recipient List' on the 'Mailings' tab if you only want to create labels for some of the addresses in your list. In the dialog box, choose individual records by checking the ones you want to include. Uncheck the ones you don't want to include.
11. Set up the mail merge fields, which serve as placeholders on the labels. Each label will connect to an address record in your address list, including all of the address elements you need. Click 'Match Fields' in the 'Write Insert Fields' group on the 'Mailings' tab. This will bring up a new dialog box, showing elements of an address on the left and the column headers from your address list on the right side.
12. Click a drop-down menu on the right to properly match the correct address field you want to use for each element. Only select the elements you want to include on your labels. For instance, don't match 'Courtesy Title' if you don't have a column for title in your address list.
13. Click the first label on the Word document. If you want to include any content that you want to display on each label, insert it now. For example, you could add a company logo to each label. To do so, click the 'Insert' tab and choose 'Picture' to insert the image file.
14. Click the same label where you want to insert the placeholder mail merge field. Click 'Address Block' in the 'Write Insert Fields' group. Select the address elements you want to include and click 'OK.'
15. Click 'Update Labels' in the 'Write Insert Fields' group. This will apply the content of the first label to all the labels on the page.
16. Preview the mail merge after you've finished setting up the first label. This will allow to see the results of the mail merge before completing it. Click 'Preview Results' in the 'Preview Results' group.
17. Connect your printer to the computer and feed it with the sheets of labels before finishing the merge.
18. Click 'Finish Merge' in the 'Finish' group on the 'Mailings' tab. Click 'Print Documents' to print the labels.

Read more ►

How to Make a Pipe Delimited File in Excel

1. Click the Windows 'Start' button in the computer's taskbar, and then click 'Control Panel' in the resulting menu. This opens a window.
2. Click 'Region and Language' in the window that appears. The Region and Language window opens.
3. Click the 'Additional Settings' button in the Region and Language window. The Customize Format window appears.
4. Highlight the comma in the 'List separator' field. Press the 'Shift' key and the backslash key simultaneously on your keyboard. This will create a pipe (|).
5. Press the 'Apply' button, then 'OK' to close the Customize Format window. Press 'OK' to close the Region and Language window.
6. Double-click the Excel spreadsheet file you want to change to pipe delimited. This will open the file in Excel.
7. Click the 'File' tab and then click 'Save As' if you're using Word 2010. Click the 'Office' button and then click 'Save As' if you're using Word 2007. Click 'File' and then 'Save As' in the resulting window if you're using Word 2003. This opens the Save As window.
8. Type a name for your file in the 'File name' field, and then select 'CSV (comma delimited)' in the 'Save as type' drop-down menu. Click the 'Save' button when done. Since you set the machine's default to a pipe, it will save the delimited file with pipes instead of commas.

Read more ►

How to Add Borders to Cells in Microsoft Excel

1. Launch Excel by double clicking the icon on the Desktop or by finding the application under the 'Start' menu.
2. Choose the file you wish to work with and open it.
3. Highlight the cells in the spreadsheet that you want to have a border. Place the mouse in the cell you wish the border to start, press and hold down the left mouse button and drag the mouse over the cells you wish to change. Release the left button. The area you want to manipulate should be shaded.
4. Right click in the shaded area. A window of options appears, select 'Format Cells.' Choose the 'Border' tab. There are several options on this new window.
5. Change the color of your borders by selecting the color you want from the 'Color' drop down menu.
6. Choose the border design by clicking the line type you like in the 'Style' box. Play with the 'Border' buttons to see what suits your needs. Different borders can be placed in different areas of the spreadsheet. To keep information uniform among worksheets, try to use the same color for the same data.

Read more ►

How to Download Data From the Web to Excel

Download Data from the Web to Excel 2003
1. Open Microsoft Excel 2003.
2. Select the 'Data' option from the toolbar at the top of the screen, select 'Import External Data,' and then select 'New Web Query.'
3. Type the URL of your desired Web page into the text field next to 'Address' at the top of the window, then click the 'Go' button.
4. Click the yellow arrow(s) located next to the information that you wish to download into Excel.
5. Select the 'Import' button at the bottom of the window once all your required data has been downloaded.
6. Select the location on your worksheet into which the data will be downloaded, then click the 'OK' button.
Download Data from the Web to Excel 2007
7. Open Microsoft Excel 2007.
8. Click the 'Data' tab at the top of the screen, then select the 'From Web' button in the 'External Data' section.
9. Type the URL of your desired Web page into the text field next to 'Address' at the top of the window, then click the 'Go' button.
10. Click the yellow arrow(s) located next to the information that you wish to download into Excel, then select the 'Import' button at the bottom of the window once all your required data has been downloaded.
11. Select the location on your worksheet into which the data will be downloaded, then click the 'OK' button.

Read more ►

How to Insert an Attachment Into an Excel Spreadsheet

1. Open your Excel spreadsheet. Choose the cell where you want to insert your attachment. Click inside this cell. Select 'Insert' from the menu bar, then click 'Object.'
2. Select 'Create New' if you will create a new file to attach to the spreadsheet. Select 'Create from File' if you will attach a file that you have already saved on your computer.
3. If you will create a new file to insert, select the type of file you will make. Check the 'Display as icon' box if you want to display the attachment as a representative icon rather than a full file display. Click 'OK.' Create the new file. The appropriate program will open in a new window.If you want to attach a file you have already created, browse for the file on your computer. Check the 'Link to file' box to include a link to your source document in the spreadsheet. Check the 'Display as icon' box if appropriate. Click 'Insert.' Click 'OK' to auto inject the file.
4. Save the Excel spreadsheet as normal.

Read more ►

How to Make a Line Chart in Excel 2007

1. Enter data that will be charted into the spreadsheet. Line charts allow you the flexibility to present the information in rows or columns. Include text headers to identify what data is in the row or column.
2. Highlight the information that you want to chart. Click the first cell in the series that you want to highlight. While holding down the mouse button, drag the cursor highlighting all the data that will be inserted in chart.
3. Choose the type of chart you want to create. Click the Line button. This button is located under the Insert tab on the top ribbon. Choose the first option labeled 2D line.
4. Format the chart by adding a chart title, axis titles and legend. These labels assist the reader with identifying the data being represented. These options can be found under the Layout tab. The Design tab contains an option to switch the data on the X and Y axes and to select additional data cells. Another way to accomplish this is by right-clicking on the chart and selecting change data.
5. Enhance the visual appearance of your chart by using the Design and Format tabs. The Design tab has chart layouts for quick customization. You can also manually personalize your chart. The line color can be changed under the Design tab. The Format tab has options to apply text effects, shape effects and colored borders.
6. Move the chart to a separate worksheet. The chart will be embedded in the worksheet that contains the data upon creation. Select the chart and click on the Design tab. Click the last button named Move Chart. You will then have the option of moving the selected chart to a new worksheet.

Read more ►

How to Work With Pivot Tables in PPT Excel 2003

1. Launch Excel 2003 and open a blank spreadsheet. Enter the source data that you want to use for the pivot table. The list should be organized in to columns or rows with original headers that correspond with the data that follows. For example, headers for a list of families who live on specific streets would be stored in the spreadsheet using the street names as column headers and the family surnames in the corresponding cells in the appropriate columns.
2. Click the “Data” menu and select the “PivotTable and PivotChart Wizard” option, which will open a separate window. Click the “Microsoft Excel” and “Pivot Table” options and click the “Next” button.
3. Select the data that you entered by clicking the header in the first column and dragging to the last cell in the last column while holding down the mouse button. Click the “Next” button.
4. Click the “New worksheet” option to display the pivot table results in a new worksheet within the Excel workbook. Click the “Existing worksheet” option to display the results in the worksheet that contains the source data. Click the “Finish” button.
5. Select the data that you want to appear in the PPT file. Click the “Copy” button. Launch PowerPoint 2003 and open a blank slide show or a presentation to which you want to add the pivot table information. Click the “Paste” button in PowerPoint to paste the data into the slide.

Read more ►

How to Program Excel Interfaces

1. Start Microsoft Excel, then open any worksheet or workbook.
2. Click on the 'Developer' tab. If you don't have this tab, click on the 'Microsoft Office' tab, then click on 'Excel Options.' Click on 'Popular' in the categories pane, and then select 'Show Developer tab in the Ribbon.' Click on 'OK' to close the dialog box. The 'Developer' tab will now be added to the toolbar.
3. Click on the 'Visual Basic' button. This will open the Visual Basic Editor (VBE).
4. Click on the 'Insert' tab and then click on 'New Module.' This opens a blank window where you can write your VBA code.
5. Write a short piece of VBA code to perform a task. For example, VBA code to bold characters is:Sub boldletter()' boldletter MacroSelection.Font.bold = TrueEnd SubThe macro should start with Sub (for subroutine) or Function, and end with End Sub or End Function. The first line of the code also contains the name of the subroutine followed by an open and closed parentheses, which is in this case is 'boldletter.' An apostrophe at the beginning of a line means that it is a comment.
6. Press the 'F5' key to run the macro.
7. Save the code by saving the workbook. Exit the VBE by pressing the 'alt' and 'F11' keys together. Click on the 'Microsoft Office' button and then click on 'Save.'

Read more ►

How to Use Microsoft Excel to Make a Bar Graph

Make a Bar Graph in Excel 2003
1. Enter the data you want to use into columns or rows in the Excel worksheet with a column or row of labels and a column or row of data.
2. Select the cells containing the data you entered. Click and hold the left mouse button and drag over the cells, or press and hold the 'Ctrl' key and click on each cell you want to select.
3. Click the 'Chart Wizard' button on the standard toolbar. Select 'Bar' under 'Chart Type.' Select a bar graph subtype in the 'Chart Subtype' box. Click 'Next.'
4. Select any other settings desired. Click 'Finish' to complete the wizard and add the bar graph to your Excel worksheet.
Make a Bar Graph in Excel 2007
5. Enter the data you want to use into columns or rows in the Excel worksheet with a column or row of labels and a column or row of data.
6. Select the cells containing the data you entered. Click and hold the left mouse button and drag over the cells or press and hold the 'Ctrl' key and click on each cell you want to select.
7. Go to the 'Insert' tab. Click 'Bar' in the 'Charts' group. Select a bar graph subtype to add the chart to the current worksheet.
8. Click on the chart to select it. Go to the 'Design' tab under 'Chart Tools' to select a different layout or move the chart to another sheet.
9. Go to the 'Format' tab under 'Chart Tools' to make formatting changes, such as shape styles and colors. Save the worksheet before closing it.

Read more ►

How to Learn Macros in Excel 2007

1. Click on the 'Developer' tab to bring up the ribbon.
2. Click the 'Record Macro' button in the Code frame of the Developer ribbon.
3. Type your desired macro name into the 'Macro Name' text box, then type the shortcut key you want to use to access your macro in the 'Shortcut Key' text box. Click 'OK.' For example, you might name your macro 'AddEmphasis' and set the shortcut key to 'E.'
4. Format your spreadsheet in whatever way you want. Whatever you do now will be repeated when you run the macro in the future. For example, you might italicize the text in a cell and change the background to yellow.
5. Click the 'Stop Recording' button in the Code section of the Developer ribbon.
6. Press 'Ctrl' and the shortcut key you chose in Step 3 at the same time. For the example, if you press 'Ctrl' and 'E' at the same time, the active cell will become italic and the background will turn yellow. You now have a working macro.

Read more ►

How to Exit From a Sub in VBA

1. Open the VBA editor. Double-click on one of the Microsoft Office programs that you want work with. Click on the 'Developer' tab and then click on 'Visual Basic.' If you don't see the 'Developer' tab, click on the 'File' tab and then 'Options.' Click on the 'Customize Ribbon' tab in the 'Options' dialog box. Click on 'Main tabs,' and then click on the 'Developer' check box. Click 'OK' to close the 'Options' dialog box.
2. Navigate to the sub procedure that you want to work with in the Visual Basic Editor. Double-click on the page in the right pane to open it. To work on a new procedure, click on 'Insert' and then 'Sub Procedure.'
3. Add the 'Exit Sub' command in the sub procedure where you want to exit a certain block of code. This will be between the Sub and End Sub commands. Usually, the Exit Sub command is added right after the code handler. Here is an example of a code block with an Exit Sub command:'Sub message ()MsgBox 'Hello World!'On Error GoTo Error_Handler:Worksheets('Welcome Message').ActivateExit SubError_Handler:If Err.Number = 9 ThenWorksheets.Add.Name = 'Welcome Message'ResumeEnd IfEnd Sub'The sub procedure shows a message box that says 'Hello World.' If for some reason the program can't display the message, it is directed to the 'Error_Handler' block. To stop the code from continuing to cycle through the same bits of code, the 'Exit Sub' command is given.

Read more ►

How to Create a Venn Diagram in Excel or Word

1. Open a document in Microsoft Word or Excel.
2. Click the 'Insert' tab. In the 'Illustrations' group, click 'SmartArt.' Click the 'Relationship' tab. Scroll down and select the icon for 'Basic Venn.' Click 'OK' to insert the Venn diagram.
3. Click 'Text' in the Text pane on the left. Type the text you want to place inside the first circle, which should be the name of the thing you are comparing. Click the next item down to enter text for the next circle. You also can click a circle in the graphic and type the text there.
4. Add or remove circles from the Venn diagram if you have more or less than 3 circles you want to compare. To add a circle, select the circle nearest to where you want to add one. Click the 'Design' tab. In the 'Create Graphic' group, click 'Add Shape.' Click either 'Add Shape After' or 'Add Shape Before,' and a circle will be added to overlap the selected circle. If you need to delete a circle, select it and then press 'Delete.'
5. Edit the circles in your diagram by manually moving them around. Click a circle you want to move, then drag it to the proper location. This will change the location and size of the overlapping areas of the circles.
6. Format the diagram by clicking the graphic, then clicking the 'Design' tab. To change the color combination, click 'Change Colors' in the 'SmartArt Styles' group and select a theme. Apply a SmartArt Style to change the look of it. Scroll through the styles in the 'SmartArt Styles' group and click the one you want. To change the look of a particular circle, right-click the border of the circle. Select 'Format Shape.' Here you can edit the line color, line style and fill color.
7. Click the 'File' tab or 'Microsoft Office Button,' then 'Save as' to save your Venn diagram.

Read more ►

How to Fit an Excel Sheet on One Page

1. Open the Excel spreadsheet that you want to print. Click on 'File' in the Excel toolbar, or use the keyboard shortcut 'Alt' and 'F.'
2. From the 'File' menu, select 'Page Setup.'
3. In the 'Page Setup' dialog box, click the 'Page' tab.
4. Under 'Scaling,' click the radio button to the left of 'Fit To.'
5. Enter your desired number of pages in the 'Pages Wide' and 'Pages Tall' drop-down menus. For example, you may want to change only the width of your page so that the last columns do not print onto a separate page. In this case, you would enter '1' into 'Pages Wide' and delete the number in the 'Pages Tall' menu.
6. Click OK. Your Excel spreadsheet will now fit the way you want it to.

Read more ►

How to Modify a Worksheet in Excel 2007

1. Determine what you need to modify. You have just received correspondence from some of your friends that have changed their address. You now need to update their information in your workbook.
2. Open your worksheet and find the information that needs to be modified.
3. Click on 'Edit' and 'Find and Replace'. When the box appears type in the first or last name of the person you need to locate in the 'Find' box and click ok.
4. Let Excel find and take you to the information.
5. Select the columns that need to be updated. Fill in the new street, city, state and zip code with the new information.
6. Decide if you need to add more information. If your friends have included their phone number in the new information that they sent you, but you haven't put in a column for phone numbers, you can add this column now.
7. Add the new column. Go to the title row and type in a heading such as phone. You can then go back to the row you were in and add the phone number that you have just received.
8. Continue to add new information, by adding new columns or rows to the information that is already there. This is all it takes to modify your worksheet.

Read more ►

How to Print on One Page in Excel 2003

1. Click 'Start' from the bottom-left of the screen. Click 'All Programs' and then click 'Microsoft Excel 2003.'
2. Click 'File' and then 'Open.' Click the Excel file of choice and click 'Open.'
3. Click and drag the mouse over the group of cells of the worksheet you wish to print. If you do not choose the group of cells when you print, Excel will print both cells with data as well as cells that are blank.
4. Click 'File,' then click 'Print Area' and then 'Set Print Area.'
5. Click 'File' and then click 'Page Setup.'
6. Click the option 'Fit to' in the 'Page' tab. Enter the value of '1' page wide by '1' tall.
7. Click the 'Margins' tab. Check the box next to 'Horizontally' under 'Center on page' and click 'OK.' This ensures the worksheet prints in the center of the page for the standard portrait paper layout.
8. Click 'File' and then 'Print.' The Print window launches. Click 'OK' to print your worksheet.

Read more ►