How to Embed Excel Files into Word

1. Open Microsoft Word. You can either open a blank document or an existing document.
2. Click on the location in your document where you wish to embed your spreadsheet.
3. Click the 'Insert' tab and select 'Object.'
4. Click the 'Create from File' to browse for an existing Excel file. Navigate to and select the Excel spreadsheet. Choose to display the spreadsheet as an icon or link as well as the full object.
5. Click 'OK' to embed your object. If you didn’t choose to display the spreadsheet as an icon or link, you will see the first sheet of the workbook in your Word document. Click the spreadsheet object to view any other sheets and also to change data.

Read more ►

How to Disable Hyperlink Warning Messages in Office 2007

1. Creating a system restore point is recommended (See Resources).
2. Click the 'Start' button.
3. Type 'regedit' in the search box. Press 'Enter.'
4. Click 'Continue' if you get a 'User Account Control' window.
5. Press 'F3' on the keyboard to open the 'Find' window.
6. Type 'HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Common' and click 'Find Next.' If this text is not found, press 'ok,' then F3 again. Type 'HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common' and click 'Find Next.'
7. Look for a sub-key named 'Security'. If this exists, click on it. If not, create it by clicking 'Edit', 'New' and then 'Key.' Type 'Security' and press enter.
8. Click 'Edit,' 'New,' and then 'DWORD' value. Type 'DisableHyperlinkWarning' and click 'Modify'.
9. Select 'Decimal' and type '1' for the value. Click 'OK.'
10. Close the registry editor and reboot the computer.

Read more ►

How to View Excel 2007 Files on Excel 2003

1. Click to download the 'Microsoft Office Compatibility Pack' from the Resources section below. Choose a directory on your local hard drive to save the file and click the 'Save' button.
2. Double-click the downloaded executable to run it. Read the license terms, then click to place a check in the box next to 'Click Here To Accept The Microsoft Software License Terms.' Click the 'Continue' button.
3. Click the 'OK' button when the Compatibility Pack has completed the installation process.
4. Launch the Microsoft Excel 2003 program by clicking the 'Start' menu button. Click 'All Programs', then 'Microsoft Office', and click on 'Microsoft Office Excel 2003' program shortcut.
5. Click the 'File' menu and choose the 'Open' menu option. Click on the Excel 2007 spreadsheet file to select it in the 'Open' dialog box, then click the 'Open' button to open the file.

Read more ►

How to Protect a Single Cell in Excel 2007

1. Click any cell in Excel, hold the 'Ctrl' key and press 'A' to select all cells. Alternatively, click the triangle at the top left of the worksheet, located just above the row numbers and to the left of the column letters.
2. Right-click any selected cell, and click 'Format Cells.'
3. Click the 'Protection' tab, uncheck 'Locked' and click 'OK.'
4. Click any cell to deselect all the other cells.
5. Right-click the single cell you wish to protect, and click 'Format Cells.'
6. Click the 'Protection' tab, check 'Locked' and click 'OK.'
7. Click the top 'Review' tab, and click 'Protect Sheet' in the 'Changes' group.
8. Enter a password in the 'Password to Unprotect Sheet' field of the 'Protect Sheet' dialog window, and click 'OK.'
9. Re-enter the password in the confirmation box and click 'OK.' That single cell is now protected. To unprotect it, click 'Unprotect Sheet' in the 'Changes' group of the 'Review' tab, enter the password and click 'OK.'

Read more ►

How to Put a Signature on Microsoft Excel

Manual Signature
1. Open Microsoft Excel. Click the 'File' tab and select 'Open,' then browse to the spreadsheet and double click the file.
2. Click the 'Insert' tab. Click 'Shapes' in the 'Illustrations' section.
3. Click the squiggly line 'Scribble' tool in the 'Line' section. The cursor changes to a pencil.
4. Position the cursor on the spreadsheet, then click and hold down the left mouse button and draw a signature of your first name with the Scribble tool. Release the left mouse button when finished. Repeat the process of clicking the 'Shapes' button, selecting 'Scribble' and clicking the cursor to draw your last name next to the first name box.
5. Change the signature color -- depending on your settings Excel's default may be light blue -- by clicking the new orange 'Drawing Tools' tab at the top of the work area. Click the 'Shape Outline' button. Click a small colored square, such as black or dark blue, to instantly change the color. Repeat for the last name and any further designations.
Import Signature
6. Open Microsoft Excel. Click the 'File' tab, select 'Open,' browse to the spreadsheet and double click.
7. Click the 'Insert' tab at the top of the work area. Click the 'Picture' button in the 'Illustrations' section.
8. Browse to the previously-created graphic file containing your signature. Double click the file name to add the signature image to your Excel spreadsheet.

Read more ►

How to Copy Workbooks in VBA

1. Open Microsoft Excel. Create a workbook, and name it 'Book1.xls.' Populate the cells with information, and save it to your local disk C: drive.
2. Create another workbook, and name it 'Book2.xls.' Leave it blank, and save it to your local disk C: drive. Close Excel.
3. Open Microsoft Word. Go to 'Tools,' 'Macro' and then Click 'Visual Basic.' This will open the Visual Basic programming environment.
4. Go up to 'Insert' and choose 'Userform.' This will create a Userform.
5. Double-click on the Userform, and paste the following code: FileCopy Source:='C:\Book1.xls', Destination:='C:\Book2.xls'Here is an example of what your code should look like:Private Sub UserForm_Click()FileCopy Source:='C:\Book1.xls', Destination:='C:\Book2.xls'End Sub
6. Press the 'F5' key on your keyboard to run the program. The information in workbook 'Book1.xls' should now be copied to 'Book2.xls' on your local C: drive.

Read more ►

How to Add a Trendline With Excel 2007

1. Select the chart to which you want to add the trendline. Click once on the data series for which you want the trendline to appear.
2. Click the 'Add Trendline' option on the 'Chart' menu. This action will open a separate pop up window.
3. Click the 'Type' tab. Select the type of trendline that you want to add from the list of available options. Click the 'OK' button to add the trendline to the chart.

Read more ►

How to Center Worksheets Both Horizontally Vertically in Windows Excel

1. Open your worksheet in Microsoft Excel by clicking the 'Office' button in the upper left corner and selecting 'Open.' Navigate to where your workbook is located and click 'Open' to display the worksheet.
2. Click the 'Page Layout' tab and click 'Margins' in the 'Page Setup' group
3. Click 'Custom Margins' to display the 'Page Setup' settings.
4. Check the boxes located next to 'Horizontally' and 'Vertically' under 'Center on Page' to center your worksheet. Click 'OK' to close the 'Page Setup' box.

Read more ►

How to Do a Cumulative Total on Excel

1. Open the Excel 2010 file in which you want to create a cumulative total.
2. Enter, or move, the numbers you are going to sum into a single column. Ensure that this column has an empty column to the right of it.
3. Select the cell at the top of the empty column to the right of the values. Place an equal sign (=) into the cell to start a formula, then click on the cell at the top of the column with the values to place that cell reference into the formula. Press 'Enter' to complete the formula, and the cell will display the exact same value as the top cell of the original columns.
4. Click the cell directly below the cell where you entered the formula. Press the '=' button to start a new formula. Click the cell at the top of this column to place its coordinates into the formula. Then press the plus sign ( ) sign and click the cell to the left of the cell you are entering a formula in. Press 'Enter' to complete the formula.
5. Move your mouse to the bottom-right corner of the cell you just placed your formula in. When your mouse changes to a plus sign, click and hold the mouse button. Drag your mouse down the column to the last cell where you want to create the cumulative total. Release the mouse button, and the entire column will change to show the cumulative sum for the first column.

Read more ►

How to Merge Documents in Excel 2007

1. Create an Excel document and then click on the 'Review' tab in the 'Changes' group. Click the option 'Share Workbook.' Click the 'Editing' tab and check the box next to the option to 'Allow changes by more than one user at the same time.'
2. Create a folder on your PC's desktop by right-clicking on your desktop. Save the original Excel document to this new folder by clicking 'Save As' and then selecting the new folder on your desktop as the destination for the Excel document. Save the copy of the Excel document you want to merge into the original document in the same folder on your PC's desktop. Make sure the two files have different file names.
3. Open the original Excel document. Click 'Tools' from the Excel window's toolbar. Select 'Compare and Merge Workbooks.' A dialog box will open and ask you to 'select the files to merge into current workbook.' Select the document you would like to merge into the original Excel document. Click 'Ok.'

Read more ►

How to Make a Crossword Puzzle in Excel

1. Draft your crossword puzzle with paper and pencil. Determine what size grid you will need, where you want to place your clues, and how clues will cross on the grid.
2. Start a new, blank document in Microsoft Excel.
3. Select a number of rows equal to one more than the vertical size of your planned grid (for example, if you need a grid 20 spaces high, select 21 rows).
4. Right-click in cell A1, click 'Row Height,' and then enter '20' in the option box that appears. Click 'OK.'
5. Select a number of columns equal to one more than the horizontal size of your planned grid (for example, if you need a grid 20 spaces wide, select 21 rows).
6. Right-click in cell A1, click 'Column Width,' and then enter '2.5' in the option box that appears. Click 'OK.'
7. Starting in cell B2, select your grid area, then click on the 'Borders' button in the Font box on the Home ribbon. Select 'All Borders' from the pull-down menu.
8. Key in your answers, one letter per cell (don't worry--you will delete them later). Make sure that all answers are spelled correctly and that words cross at the appropriate letter.
9. Select the empty cells (hold down the 'Control' key and click each empty cell). In the Font box on the Home ribbon, click on the 'Fill Color' button, then choose 'Black, Text 1' as your color (first row, second column).
10. Select your crossword grid and delete all the answers. Type a small (font size 6) corresponding clue number in the first cell of each answer's space.
11. Type your numbered clues, one clue per cell, in separate cells to the right of the crossword grid.

Read more ►

How to Make a Perceptual Map in Excel

Excel 2007
1. Highlight your data by left-clicking on the top-left cell, and dragging your mouse to the bottom right.
2. Click the “Insert” ribbon.
3. Click “Other Charts” in the 'Charts' section of the 'Insert' ribbon.
4. Click “Bubble” to display your perceptual map on your worksheet.
Excel 2003
5. Highlight your data by left-clicking on the top left cell, and dragging your mouse to the bottom right.
6. Click on 'Chart' from the 'Insert' menu.
7. Click on 'Bubble' in the Chart type box.
8. Click the chart sub-type you want to use, then click 'Next' twice.

Read more ►

How to Make a Mailing List on Excel

How to Create a Mailing List with Excel
1. Open a blank Excel spreadsheet.
2.
Enter the labels you want to include in your mailing list on the top row. Shown in the sample are labels for first name, last name, address, city, state, country and zip code (see sample in Image 1).
3.
Immediately below the labels, type the first entries of your mailing list (Image 2).
4.
Format your mailing list as a table by clicking the 'Format as Table' button (located in the 'Styles' tab on the 'Home' menu) and choose the table format you want. The 'Format as Table' dialog box will pop out. Click the check box beside 'My table has headers,' then click 'OK' (Image 3).
5.
You can now complete the mailing list by typing the next entries. Press 'Tab' as you move to the next cell. Excel will automatically format the next cells and rows on your table as you click on the Tab key (Image 4).
6. After typing all the entries in your mailing list, save and close your Excel sheet.
7. Open the Word document that contains the text template for the letter or file that you want to use with the mailing list.
8.
Click Mailings > Start Mail Merge > Step by step Mail Merge Wizard. This will show the Mail Merge wizard on the right-hand side of your document (Image 5).
9.
Select the 'Document Type' you want to use then click 'Next' at the bottom. In the example, 'E-mail messages' is the document type (Image 6).
10. Select 'Use the current document,' then 'Next' at the bottom to select recipients (Image 7).
11. Select Use an existing list > Browse > Open > Select Sheet/Table. Click 'OK' on the mail merge recipients dialog box (Image 8).
12. Click 'Greeting Line,' format the salutation and click 'OK.' It will automatically insert a greeting line on your template (Image 9).
13. Repeat Step 12 for the address block list (Image 10). Preview your custom template. If everything looks fine, click 'Complete the merge.'
14. The final step is to print the file or edit them individually, whichever you prefer to use for your mailing list (Image 11).
15.
16.
17.
18.
19.

Read more ►

How to Insert an Object as an Icon That Is Not Appearing in MS Word

Inserting a New Object with an Icon You Select
1. Open your Word document. Click 'Insert' at the top of the Word screen.
2. On the 'Text' segment of the menu, click on 'Object.'
3. Select the 'Object type' from the box.
4. Click 'Display as Icon.' The default icon for the application you selected will appear.
5. Click 'Change Icon' to bring up the 'Change Icon' dialog box.
6. Click 'Browse.'
7. Navigate to the location of the exe, dll or ico file containing the icon you want to use. Click the icon and choose 'Open.'
8. Click 'OK' on the next two windows to complete the object insertion.
Modifying an Existing Object With an Icon You Select
9. Right-click on the object and choose 'Convert.'
10. Select the option that says 'Change Icon.'
11. Navigate to the location of the icon you wish to use. Click it and choose 'Open.'
12. Click 'OK' to complete the changes.

Read more ►

How to Insert Identical Information Into Several Excel Worksheets

Setting Up the Workbook
1. Create a new workbook by selecting 'New' from the 'File' menu or clicking the New button on the main toolbar.
2. Insert as many additional pages into the workbook as you need by selecting 'Worksheet' from the 'Insert' menu or right-clicking on a tab and selecting 'Insert' from the pop-up menu.
3. Rename each page to something more meaningful by double-clicking on the tab to highlight the name and typing in the new name or right-clicking and selecting 'Rename' from the pop-up menu.
4. Format each page with titles and column labels as necessary. Use the Copy feature to copy static information from one worksheet to another.
5. Enter the numeric data you need on each worksheet and set up any preliminary calculations for that worksheet.
Inserting the Information
6. Jot down the name of the worksheet and the cell address for each piece of dynamic information you wish to carry from one spreadsheet to another. (If you have only a few cells you wish to carry over, don't bother writing their addresses down first.)
7. Click on the cell in the new worksheet to which you wish to carry the information.
8. Refer to the cell whose contents you wish to copy by entering '=SheetName!An,' replacing 'SheetName' with the actual name of the worksheet you are copying from 'A' with the column letter and 'n' with the row number of its cell. (If the name of the reference worksheet includes spaces, you must enclose the worksheet name in parentheses.)
9. Repeat Step 3 for each cell whose contents you wish to copy into another worksheet. If you are copying the same cell's information into multiple worksheets, use the Copy feature to copy the reference formula into the other worksheets.

Read more ►