How to Turn Excel Cells Into Mailing Labels

1. Open Excel 2010 and click the 'File' tab. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook will open.
2. Review the workbook and make sure the data that will be used in the mailing labels contains column headers. Click the 'Save' icon on the Quick Access Toolbar.
3. Open Word 2010 and click the 'Mailings' tab. Click the 'Start Mail Merge' button. A drop down list appears. Select 'Labels.' The Labels Option dialog box appears. Select the 'Label Vendor' drop down list and select the type of labels you are creating. Select the label product number in the 'Product Number' scroll list. Click 'Ok.'
4. Click the 'Select Recipients' button on the ribbon. Select 'Use Existing List.' The Select Data Source dialog box appears. Browse the files and locate the Excel workbook containing the data for the mail merge. Click the workbook then click the 'Open' button.
5. Add fields to the label by clicking the 'Insert Merge Field' button. Select one of the options in the drop down list. It will appear on the first label. If necessary, add formatting, spacing, or press the enter key. Add another field by clicking the 'Insert Merge Field' button. If necessary, add formatting, spacing, or press 'Enter.'
6. Press the 'Preview Results' button to see a preview of the labels. Click 'Finish And Merge' to finalize the mail merge. Select 'Edit Print Documents.' Click 'All' in the Merge To New Document dialog box. Select 'Ok' to see the labels prior to printing.

Read more ►

How to Move a Chart in Excel to Another Page

1. Launch Microsoft Excel 2010.
2. Click the 'File' tab at the top-left corner of the window, and then click 'Open.'
3. Browse to the file containing the chart that you want to move, and then double-click the file to open it.
4. Click the chart to select it. This will add three tabs to the top of the window in a new 'Chart Tools' section.
5. Click the 'Design' tab in the 'Chart Tools' section.
6. Click the 'Move Chart' button in the 'Location' section of the ribbon at the top of the window.
7. Check the 'New Sheet' option, and then click 'OK.' The chart will be moved to a new tab called 'Chart1,' and will be accessible by clicking the tab at the bottom of the window.

Read more ►

How to Create an XML Map

1. Click the 'developer' tab in Microsoft Excel or if it is not available click the Microsoft Office button. Next click on Excel options.
2. Locate the 'popular' category in Excel. Now you will click the 'show developer tab.'
3. Click 'source' on the developer tab in the group labeled XML.
4. Locate XML maps and click on it. Now click 'add.'
5. Find the 'lookin' list and click on the drive, list and folders that you want to open. Now click 'open' for whatever you want.
6. Click 'OK' and the XML map is created.

Read more ►

How to Make a Histogram in Excel 2010

1. Download the Excel 2010 Analysis ToolPak. Click 'File,' and then 'Options.' From the Add-Ins category, select 'Excel Add-Ins,' which display in the Manage box. Click 'Go.' Check the 'Analysis ToolPak' box from the list of add-ins and click 'OK.'
2. Choose an appropriate bin size for your data set. The bin size refers to the range of values that fall into a specific class. For example, if your data set is ages of people in the United States, set your bin size to 10 years. This makes the bins correspond to ages 0-10, 11-20, 21-30 and so on, with a maximum bin of 101-110. Select a bin width that creates five to 20 groups of data.
3. Type the bin widths in column A of a blank worksheet, beginning with the lowest number. For the age range example, type 0, 10, 20, 30 and so on.
4. Type the data points in column B of the worksheet. Keep the data points as raw numbers, rather than converting them to frequencies. List the entire set of numbers in any order.
5. Look in the Analysis section of the Data tab. Click 'Data Analysis' and highlight the 'Histogram' tool from the Analysis Tools box. Click 'OK.'
6. Enter the Input Range in the box provided, and highlight the contents of column B. In the Bin Range field, highlight the contents of column A. This tells the software what data to use to make the histogram.
7. Select 'Chart Output' in the output options section to generate a histogram graph. Click 'OK.'
8. Modify your histogram to include custom labels. Double-click on the x- and y-axis labels to change the text. Use the 'Chart Tools' section to modify the design, layout and format of your histogram.

Read more ►

How to Convert an Excel 2007 File to Excel 2003

1. Open the Microsoft Excel 2007 file you want to convert; you can do this by clicking the Microsoft Office button in the upper left-hand corner (it looks like a circle with the Microsoft Office logo on the inside) and then 'Open.' From the pop-up window, select the location of your Excel 2007 file. You can recognize 2007 files because they have a file extension of XLSX.
2. Click on the Microsoft Office button again; this time, select the right-facing arrow next to the 'Save As' option. A list of possible formats will appear; from this list, choose 'Excel 97-2003.'
3. Verify that the name of the file is correct; if you wish to change it, simply highlight the title, press 'Delete' on your keyboard and then type in the new name. Also make sure that file extension now reads XLS. Click 'Save.' The file should now be stored on your hard drive as a Microsoft Excel 2003 file.

Read more ►

How Do I Use Dragon SpeakingNaturally 10 With Microsoft Excel?

1. Open Microsoft Excel.
2. Click the 'Office' button in Microsoft Excel. It is in the left, top corner of the program.
3. Click 'Excel Options' from the drop-down menu.
4. Click 'Add-Ins' from the menu along the left navigation pane in 'Excel Options' dialog box.
5. Click the drop-down menu next to 'Manage' and select 'Disabled Items.'
6. Locate and click on 'dgnexcel.dll' from the list of disabled items.
7. Click 'Close' and 'OK.'

Read more ►

How to Search a Cell Range for a Match in Excel VBA

1. Open the Visual Basic Editor (VBE). Click the 'Developer' tab in Excel and then click 'Visual Basic.'
2. Click 'Insert' and then click 'Module.'
3. Cut and paste the following code into the blank window:Sub Find_First()Dim FindString As StringDim Rng As RangeFindString = InputBox('Enter a Search value')If Trim(FindString)
'' ThenWith Sheets('Sheet1').Range('A1:A20')Set Rng = .Find(What:=FindString, _After:=.Cells(.Cells.Count), _LookIn:=xlValues, _LookAt:=xlWhole, _SearchOrder:=xlByRows, _SearchDirection:=xlNext, _MatchCase:=False)If Not Rng Is Nothing ThenApplication.Goto Rng, TrueElseMsgBox 'Nothing found'End IfEnd WithEnd IfEnd Sub
4. Change the range to suit your needs. The range in the code is specified as A1 through A20 (Range('A1:A20')). For example, if you want the range to be B1 through B100, change the range to 'Range('B1:B100').'
5. Press 'F5' to run the macro. A pop-up window will appear on the worksheet. Type the number or phrase you want to search for into the box and then press 'Enter.'

Read more ►

How to Move Rows in Excel

1. Select the row heading (A, B, C and so forth) that you wish to move and highlight it. You can also select several rows by holding down your left mouse button and sliding it across the rows which you would like to select, if you want to move more than one row at a time.
2. Keep your mouse placed on the highlighted row(s) and right click your mouse button. This will bring up a pop up menu with several options to choose from.
3. Choose 'Cut' from the menu that pops up. This will make the row you want to move disappear, but your computer will store it in its temporary memory. As long as you don't cut anything else or close the program, your information will not be lost.
4. Pick the row that is directly below where you want your selected row to be placed, so that it is highlighted. This is how you let your computer know where you want to place the row that you are moving.
5. Locate the Insert menu and click on the 'Cut Cells' option. The row(s) that you chose to cut will be pasted into your selected area.

Read more ►

How to Put a Combo Box in an XLS Cell

1. Open the Excel document to which you want to add a combo box.
2. Click on 'File' in the top-left corner of the Excel window. Choose 'Options' from the list that appears.
3. Select 'Customize Ribbon' on the left side of the new window. Place a check mark next to 'Developer' on the list located to the far right side of the window. Click 'OK.'
4. Click the 'Developer' tab at the top of the screen. Select 'Insert' and choose 'Combo Box (Form Control),' which will be the second option from the left in the top row. Select a cell where you want to enter the combo box.
5. Right-click the combo box and choose 'Format Control' from the drop-down menu. Click the 'Control' tab at the top of the new window. Type in a range of cells into the 'Input Range' field. These cells will contain the data that the user can choose from. Type in a single cell into the 'Cell Link' field. This is the cell where the user's choice will appear. Click 'OK' when you are finished.
6. Click 'Design Mode' at the top of the screen to exit the mode. This will make the combo box unable to be moved or edited. If you need to change the location or data for the box, click 'Design Mode' again, and you will be able to make the changes.

Read more ►

How to Insert Hyperlinks in Microsoft Excel

1. Select the cell where you want your hyperlink to be placed. You can either insert a hyperlink into a blank cell or into a cell already filled with information. If the cell is blank, the hyperlink is displayed by its file or Internet location unless you specify different text later. If the cell is already filled, the text will be the link.
2. Choose 'Hyperlink' from the 'Insert' menu. A hyperlink wizard pops up.
3. Note the 4 icons on the left side of the wizard. These icons represent the 4 types of hyperlinks you may insert into Excel. The 'Existing File or Web Page' option is probably the one you used most often. Click it and insert the file location of a file on your hard drive or website address. Change the linked text with the form field at the top if you wish.
4. Pick 'E-mail Address' to create a link to an email address. Enter the email address and the subject any email sent via the link should have. When users click on this link, an email to the linked email address opens in their default mail program.
5. Click 'Place in Document' to link to another sheet in the document.
6. Use the 'Create New Document' option to allow the Excel user to open a new Microsoft Office document with a link. The document can be from any Microsoft Office software you've installed.
7. Hit the 'OK' button to insert your hyperlink into your Excel document.

Read more ►

How to Sort Information in Excel 2007

1. Access a worksheet with data that can be sorted. Open Excel 2007 and either open an existing worksheet or add information into an empty worksheet. Data should be in a table, preferably with assigned column headers to make selecting the sorting criteria easier. Make sure that all of the data in a given column is of the same format so that it is sorted consistently.
2. Choose the data to be sorted. Left-click and drag to select the data. Ensure that both the data and the headers are included.
3. Open the sort dialog. Select 'Data' on the Excel 2007 ribbon, and then click on the 'Sort' icon.
4. Configure the sort options and apply the sort. If you have created column headers, make sure 'My data has headers' is selected. Select the column to sort by in the 'Sort by' drop-down list. Select how to sort the data by selecting from the drop down list, typically by the cell values. You can also sort by cell color, font color or cell icon. Select whether to sort in ascending or descending order by selecting from the 'Order' drop down list. To sort on more than one column, choose 'Add Level' and repeat these selections. To make the sort case sensitive or to sort from bottom to top instead of top to bottom, select 'Options' and choose accordingly. Click 'OK.'

Read more ►

How to Set up a PivotTable

1. Open the Excel worksheet that contains the data you want to make a PivotTable out of.
2. Look through your data and make sure the top cell in every column is the column title. If any of the top cells are empty, add a title that will tell you what the data in that mean. If none of your columns has a titles, right-click on the '1' on the left side of your screen and choose 'Insert.' A new row will appear at the top of the page. Enter column titles into this row.
3. Click on the top-left cell in the range of data you want to use for the PivotTable. Scroll to the bottom-right cell in the field, then hold 'Shift' and click on the cell. The entire data field will now be highlighted.
4. Click on the 'Insert' tab at the top of the screen, and the click the 'PivotTable' button. Click 'OK' on the window that opens up, and a new worksheet will be created for your PivotTable. You will see a blank table on the left side of the screen and a field list on the right.
5. Place check marks next to the fields you want to compare in the PivotTable. Excel will automatically place the fields into one of the four PivotTable categories located to the right of the field list.
6. Drag and drop your chosen fields into the categories where you want them. Each category corresponds to a different area of the PivotTable where the data will show up. You can choose to make the field into a column on the table, a row on the table, the data that makes up the meat of the table or a top-level filter above the table.

Read more ►

How to Import Delimited ASCII127 in Excel

1. Run the Excel 2010 application.
2. Click the 'File' tab and click 'Open' to open a file browser window. Click the 'Files' drop-down list, and choose 'Text Files.'
3. Navigate the file browser to the delimited ASCII TXT file that you wish to import, then click 'Open.' Excel will initiate the Import Text Wizard.
4. Click the radio button next to 'Delimited,' and click the 'Next' button.
5. Click the radio button next to the character that the ASCII file uses for delimiting fields. If your delimiting character is not in the list, then click 'Other,' and type the character into the adjacent field.
6. Click 'Next' and 'OK' to complete the Text Import Wizard. Excel will import data from your delimited ASCII text file and will automatically assign cell formatting that it deems appropriate for the type of value that is contained in each field.

Read more ►

How to Remove an Unknown Password From a Protected Excel Spreadsheet

1. Download an Excel password recovery software, such as Free Word/Excel Password Recovery Software, Excel Password Remover 2008, or Password Recovery Engine for Excel (see resources). Save the file, then click 'Install' at the prompt.
2. Open the application. Click 'Open,' followed by 'Browse.' Select your protected Excel spreadsheet from the menu. Click 'Recover' and wait for the program to recover your password.
3. Open the Excel spreadsheet using the password. From the 'File' menu, select 'Save As.' Under 'Tools,' select 'General Options.'
4. Double-click the asterisks in both the 'Password to Open' and 'Password to Modify' boxes, then press the 'Delete' key. Click 'OK,' then 'Save.'

Read more ►

How to Convert Microsoft Project to Microsoft Excel

1. Double-click on your Microsoft Project file.
2. Click 'File' at the top of the screen (Project 2003 or earlier) or the Windows button in the top-left corner (Project 2007).
3. Choose the 'Save As' option (Project 2003 or earlier) or 'Save As,' and then 'Other file formats' (Project 2007).
4. Click the arrow for the drop-down menu next to 'Save file type as' and select the 'Microsoft Excel (.xls)' option.
5. Select the location for your saved file and change the name, if necessary.
Click the 'Save' button.

Read more ►