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 ►

How to Mix Chart Types in Excel

1. Open the Excel worksheet.
2. Click and drag to select the categories and data values for the charts.
3. Click the “Insert” tab on the command ribbon.
4. Click one preferred chart type in the “Charts” group. The data converts to one chart type. The “Chart Tools” ribbon appears.
5. Right-click one data series in the plot area. This selected series will display a different chart type. A list of options appears.
6. Click “Change Series Chart Type” in the list. The “Change Chart Type” dialog window opens with a gallery of chart thumbnails.
7. Click the preferred chart type.
8. Click “OK.” The data series converts to a new chart type.

Read more ►

How to Unhide Columns in MS Excel 2007

Using the Ribbon
1. Highlight at least one cell on each side of the column you want to redisplay. For example, if you are trying to unhide column E, highlight a cell in both column D and F.
2. Select the 'Home' tab from the Office Ribbon near the top of the window and then locate the 'Cells' section of the Ribbon.
3. Click the 'Format' button, select 'Hide Unhide' and then click the 'Unhide Columns' option.
Using the Right-click Menu
4. Look to the column ID row at the very top of your spreadsheet.
5. Hold your cursor over the left edge of the column ID located immediately to the right of the hidden column you want to reveal. For example, if you are trying to unhide column A, hold your cursor over the left edge of column B in the column ID row. A double-sided arrow will appear when your cursor is in the proper position.
6. Right-click and select the 'Unhide' option.

Read more ►

How to Make a Project Milestones Chart

Making a Chart in Microsoft Project
1. In the Microsoft Project software program, open a new document that shows two window panes--one for tasks and one for the chart.
2. In the task column, enter each of the tasks for the project and the duration to complete each of the tasks in the duration column.
3. For the first task, enter the date that you would like to start the task.
4. For each of the tasks, identify which of the other tasks are predecessors or must be completed before the start of the next task. The number associated with the task that must be completed first should be entered into the predecessor column.
5. The system will then automatically schedule an end date based upon the start date and the duration of each task, and the system will generate a Gantt chart displaying the duration for each task.
Making a Chart in Microsoft Excel
6. Open a new Excel worksheet.
7. Enter the name of each task in the first column. In the second column, enter the expected start date. Enter the number of days completed for the task in the third column and enter the number of days remaining to complete the task in the fourth column.
8. Select the spreadsheet area you want to graph and open the chart wizard. Select the 'Stacked Bar Graph' as the type of graph you want to generate and select 'finish.'
9. Select the start date column. Go to Patterns and select Format Data Series. Once the box has opened, choose to have 'none' for both the area and border tabs. Select the y-axis of the chart and select the scale tab. Enter a value of 60 for the major unit, which represents approximately two months, and a minor unit of 1, which represents a day. The minimum and maximum values should correspond to the dates you want to capture with your chart. Be sure the box for 'Category axis crosses at maximum value' is checked.

Read more ►

How to Create an Anchor Formula in Excel

1.
Decide which cells in your formula need to be anchored and which do not. Single cells that are used by every iteration of the formula need to be anchored. Cell references that are different for each iteration of the formula do not need to be anchored.
Example: A1 B1 should update to A1 B2. A1 will be the cell reference that will be anchored.
2.
Insert a '$' sign before the letter and the number of the cell reference to be anchored. Example: Replace 'A1' with '$A$1'.
3.
Select the cell with the formula in it. Drag the black square in the lower-right corner of the cell over the cells for the formula to be copied to.
4.
Verify that each cell has the intended formula and result.

Read more ►

How to Use AutoComplete in Word

1. Start Microsoft Word and open an existing file or start a new blank document.
2. Type within your Word document, being sure to watch the screen for a yellow box that will appear above your typing. AutoComplete will try to finish any common words, including your name, the current date, day, month, year and any other AutoText entries that you have established.
3. Spot the yellow box that appears while you are in the middle of typing a word. Press the 'Enter' key on your keyboard to enter the word that is suggested by the Word AutoComplete tool. If Word suggests a word that you are not typing, then simply ignore the suggestion. It will go away after you have finished typing the word.
4. Repeat this process to enter any other additional AutoComplete selections into your document.

Read more ►

How to Sort Multiple Rows Columns in Excel

1. Highlight the rows and columns you wish to sort by clicking and dragging. Alternatively, place the cursor in one of the corners of the area of the spreadsheet you want to sort, hold down the 'Shift' key, and use the arrow keys to highlight the area to sort. The area must be contiguous and rectangular; you cannot sort areas that are not connected.
2. Click on the 'Data' command at the top of the window, then choose 'Sort.'
3. Click on the option you want at the bottom of the pop-up window labeled 'My list has.' If you choose 'Header row,' Excel will use the top row as the header and not sort it; if you choose 'No header row,' it will sort the top row with the other data.
4. Choose the column you wish to begin your sort with from the drop down menu under the 'Sort by' heading in the pop-up window. If you are using a header row, the drop down menu will show you the contents of the top cell of each column, if not, you will see 'Column A,' 'Column B,' etc.
5. Make further choices for the order you want the data sorted into by using the 'Then by' selections in the pop-up window. This allows you to sort, for instance, by last name followed by first name.
6. Click 'OK' at the bottom of the pop-up window to sort the data.

Read more ►

How to Auto Number in Excel 2007

Functions
1. Click the first cell in the row or column you want to number.
2. Type '=TEXT(ROW(A1), '000')' to number the rows beginning with '1' and with the format 001, 002, etc. Replace 'A1' with a different cell reference to begin at a different number; use 'A2' to begin with 002, for example. In this formula, the cell reference returns the row number of the cell. You can use any cell reference in the formula, not just the reference for the cell the formula is in. Replace '000' with '$0.00' for dollar format, '0%' for percent format or use your own format.Only type '=ROW(A1)' if you want numbers in standard format -- 1, 2 and so on.
3. Press 'Enter' on your keyboard and Excel will calculate the formula. Select the same cell again and hover your pointer over the bottom right corner of the cell until a black cross appears. Click and drag down to cover as many cells as you want to number.
Fill Handle
4. Click to select the cell where you want to begin numbering and type your first number.
5. Select the next cell in the row or column you are numbering and type the second number in your series. For standard numbering, type '1' in the first cell and '2' in the second. Use '2' and '4' to number by twos, '10' and '20' to number by tens, and so forth.
6. Click the first cell and hold the left mouse button down. Drag down or right to the second cell so both are selected at once.
7. Hover the pointer over the bottom right corner of the second cell until you see a black cross. Click and drag down to number rows or to the right to number columns. Let go of the mouse button when you reach the cell where you want the numbering to end.

Read more ►

How to Stop Word From Making a Black Line Across the Page

Turn Off the Automatic Border Setting
1. Double-click the Microsoft Word application or choose it from your Start menu to run it.
2. Type some text in the blank document window.
3. Press the 'Enter/Return' key to start a new paragraph and type either '***,' '###' or '---' and press the 'Enter/Return' key again to move to the next line. A border will appear on the page.
4. Click the 'File' button (Word 2010) or the 'Office' button (Word 2007) in the upper left corner of the screen and select 'Options' (Word 2010) or 'Word Options' (Word 2007).
5. Click the 'Proofing' category in the options window and then select 'AutoCorrect Options.'
6. Click the tab at the top of the AutoCorrect options window that says 'AutoFormat As You Type.'
7. Uncheck the box next to 'Border Lines' to stop Word from replacing the symbols ###, *** and --- with a border if you prefer the black line not to appear again automatically.
8. Click the 'OK' button to return to your document window.
Remove the Automatic Border Line
9. Click on the line above the border on the page, hold down the mouse button and drag to the line below the border line to highlight all the paragraphs near the border.
10. Click the 'Home' tab at the top of the screen, then click the 'Border' button on the 'Paragraph' panel. A drop-down menu will appear.
11. Choose 'No Border' from this menu and the border line on your page will disappear.

Read more ►