How to Change a Chart Axis in MS Word

1. Open the Word document that contains the chart you want to modify.
2. Click the chart axis you want to change. The axis will be outlined in black; right click over the axis to view options for editing the chart.
3. Select 'Format Axis' from the menu that pops up. The 'Format Axis' dialog window will open.
4. Select 'Axis Options' from the list of formatting options.
5. Select the axis scale minimum or maximum by checking 'Fixed' next to 'Minimum' or 'Maximum.' Type the minimum or maximum number you want to use for the scale.
6. Change the spacing in the tick marks on the axis by checking 'Fixed' next to 'Major unit. Enter the spacing you want for the axis tick marks. For example, if you want the tick marks to be spaced closer, enter a smaller number, such as '1.' If you want the tick marks to be spaced further apart, enter a large number, such as '5.' This is useful depending on the range of numbers on your axis.
7. Select how you want units on the axis displayed by clicking in the box next to 'Display Units' and selecting a measurement, such as hundreds or millions.
8. Click 'Close' after you finish making changes to your chart axis. The changes you selected will show up on your chart.

Read more ►

How to Find Links in Microsoft Excel

Links in Hyperlink
1. Open the Excel workbook containing the links you want to find.
2. Place your cursor in an empty cell and create a dummy hyperlink (so you can use its format to find other hyperlinks). To create the hyperlink, select the 'Insert' tab and click 'Hyperlink' in the 'Links' group. Select 'Existing File or Web Page' under 'Link to' in the 'Insert Hyperlink' dialog box. Type a website address (ex., 'http://some-address-123.com') into the 'Address' text field and click 'OK.'
3. Select the 'Home' tab and go to the 'Editing' group. Click 'Find Select' and 'Find.' The 'Find and Replace' dialog box appears. Click the 'Options' button to expand the dialog box.
4. Leave the 'Find what' text field blank. Click the arrow beside the 'Format' button and select 'Choose Format From Cell.' The dialog box minimizes and you are directed to your spreadsheet.
5. Click on the cell containing the dummy hyperlink you created in Step 2. The 'Find and Replace' dialog box reopens.
6. Select 'Workbook' from 'Within.' Select 'Values' under 'Look in.' Choose 'Find All.' All matching entries are displayed at the bottom of the dialog box.
7. Delete the dummy hyperlink from your spreadsheet.
Links in Cells
8. Repeat Step 3 of the previous section.
9. Type an open bracket '[' in the 'Find what' text field, representing the format of links in the formula bar.
10. Click 'Workbook' from 'Within' and 'Formulas' from 'Look In.' Press the 'Find All' button to display the matching links.
Links in Objects, Chart Titles or Data Series
11. Go to the text box, chart title, object or data series containing the link you want to find. To find it quickly, select the 'Home' tab and go to the 'Editing' group. Click 'Find' and 'Go To Special.'
12. Check 'Objects' in the 'Go To Special' dialog box and press 'OK.'
13. Press the 'Tab' key and check the formula bar for references to links.
Links in Names
14. Click the 'Formulas' tab in the ribbon and go to the 'Defined Names' group.
15. Click the 'Name Manager' button to display the 'Name Manager' dialog box.
16. Check the 'Refers To' tab for the link you want to find. Its cell address is displayed in the dialog box.

Read more ►

How to Make the Top Line Stay Visible in Excel

1. Open your spreadsheet in Microsoft Excel.
2. Click the 'View' tab in the ribbon.
3. Click 'Freeze Panes' in the 'Windows' group and click 'Freeze Top Row' to make the top line stay visible.

Read more ►

How to Convert Excel 2003 to the 2007 Format

1. Open the file to be converted using Excel 2007. Click 'File' in the menu bar and select 'Open.' Navigate to the file you wish to open and convert. This will open the file in Compatibility Mode.
2. Click the 'Microsoft Office Button' located in the menu bar then click 'Convert' in the pop up window. When asked if you are sure you wish to convert this workbook to the new file format, click 'OK' to confirm. If you do not want this warning message to appear again, select the option for 'Do not ask me again about converting workbooks.'
3. Click 'Yes' in the window that appears asking if you want to work on the file in the Excel 2007 file format. This will close the file, convert it to the new file format and reopen it for you to work on. After you have finished working with the file, click 'Save' in the File menu bar to save the file in the new format.

Read more ►

How to View Excel Spreadsheets Without Microsoft Office

1. Download and install the free Excel Viewer on your computer. You can find a link to the download in the resources section of this article.
2. Open the Excel Viewer. Click 'File' from the Excel Viewer window toolbar and then select 'Open.'
3. Select the Excel file you want to view and then click 'Open.' The Excel Viewer will automatically display the Excel spreadsheet you have selected.

Read more ►

How to Cross Out on Excel

1. Launch Microsoft Excel 2010 to begin working in a new workbook, or double-click an existing Excel spreadsheet to edit.
2. Click on the cell containing the text that you want to cross out. If you want to select multiple cells, hold down the 'Ctrl' key on your keyboard, and then click each desired cell with your mouse.
3. Click the 'Home' tab at the top of the window.
4. Click the 'Format Cells: Fonts' button at the bottom right-corner of the 'Font' section of the ribbon. The button is a small square with an arrow in it.
5. Check the box to the left of 'Strikethrough' in the 'Effects' section of the window, and then click 'OK.'

Read more ►

How to Make a Flowchart in Excel

1.
Make the 'Drawing' toolbar available in Excel 2003 by going to the 'View' menu and pointing to 'Toolbars.' Click on 'Drawing'; the 'Drawing' toolbar will appear at the bottom of the window. In Excel 2007, go to the 'Insert' tab of the ribbon and find the 'Illustrations' section.
2.
Click on 'AutoShapes' in Excel 2003 and point to 'Flowchart.' Click on the first shape you want to use and click onto the worksheet to place it in the appropriate area. In Excel 2007, click the 'Shapes' button and choose the shape you want to use first from the 'Flowchart' gallery. Click onto the worksheet and place the shape there. For the best results, begin your flowchart near the top of the worksheet, but leave a few rows in case you decide to add text above it.
3.
Add more shapes to your flowchart in the same manner. You need to have one shape for each step in the process. The position of the shape will depend on when the step takes place, as well as how you determine whether to take the step. For instance, if Step One is a yes or no question, you might put 'Yes' in a shape that is down and to the right of the first shape and 'No' down and to the left. Right-click each shape and click on 'Add Text' to add the information needed.
4.
Add connectors between the shapes. In Excel 2003, click the 'AutoShapes' button and click on 'Connectors.' Choose a connector and click on the first shape. Drag into place, linking the two shapes. In Excel 2007, choose a connector from the 'Shapes' drop-down menu. Connect all of the appropriate shapes.
5.
Format the shapes for more interest and effect. Right-click a shape and choose 'Format Shape' (or 'Format AutoShape'). On the 'Font' tab, you can choose a different font, change the font size or color or add effects. On the 'Alignment' tab, you can center your text. On the 'Colors and Lines' tab, you can fill the shape with a color or other fill effect. When you are finished making changes, clck 'OK.'
6.
Save your worksheet. You can use the keyboard shotcut 'Ctrl S.' Print it out if desired.

Read more ►

How to Paste Special in Microsoft Excel 2003

1. Select the cells, rows, or columns that you want to manipulate and go to the Edit menu and select 'Copy' (or press Ctrl-C) to copy the data.
2. Click the cursor on the cell or cells where you want the manipulated data to be placed.
3. Go back to the Edit menu and select 'Paste Special.' This will open up a window where you will choose how to manipulate the selected data.
4. The first section, labeled 'Paste,' is where you tell Microsoft Excel what parts of the data you want to paste. 'All' will paste all of the copied data, 'Formulas' will paste just the formulas connected to the copied data, 'Values' will paste just the outcome of the copied data and not the formulas and 'Formats' will paste just the style of the copied data.
5. The second section, labeled 'Operation,' allows you to manipulate the copied data. You can select one of the four basic arithmetic operations--Add, Subtract, Multiply, or Divide. Click the cursor on the cell or cells that you want to combine with the copied data, and Microsoft Excel will perform the operation between the two sets of values.
6. When you have chosen the 'Paste' and 'Operation' options you want, click 'OK' and Microsoft Excel will paste the data appropriately.

Read more ►

How to Find a Confidence Interval for the True Mean Using Excel 2007

1. Enter the alpha value in cell A1. The alpha value represents '1,' minus the probability the true mean lies within the confidence interval. For example, if you want a 95 percent probability that the true mean lies within the confidence interval, your alpha value equals 0.05.
2. Enter the standard deviation of the data in cell A2. The wider the distribution of data, the greater the standard deviation.
3. Enter the sample size in cell A3. The larger the sample size, the smaller the confidence interval will be.
4. Enter '=CONFIDENCE(A1,A2,A3)' into cell A4. Excel will display the confidence interval. For example, if you have an alpha value of 0.05, a standard deviation of 3 and a sample size of 160, the confidence interval would be 0.464846274.

Read more ►

How to Balance a Checkbook With Excel 2003

Manual Method
1. Open a blank Excel 2003 spreadsheet.
2. Type the following headings in the first row: 'Check #,' 'Date,' 'Description,' 'Debit,' 'Credit' and 'Balance.' These mimic your checkbook register. Format the headings however you like. Recommended formatting is to bold, center and underline headings.
3. Type 'Initial Balance' or 'Initial Deposit' in the first empty cell under 'Description.' Type your current or starting balance in the first empty cell under 'Balance.'
4. Type the following formula in the next empty cell under 'Balance': '=F2-D3 E3. This assumes Debit is in column D, Credit is in column E and Balance is in column F. If the column letters differ, adjust the formula accordingly.
5. Enter data into each row of the checkbook spreadsheet.
6. Find the current balance after each entry by clicking the balance cell above your entry. This will not apply to your first entry. Drag the cell, or copy and paste the cell, to the cell directly below it. For instance, if your previous balance is in cell F3, highlight F3 and copy the formula into F4.
Template Method
7. Open a blank Excel 2003 spreadsheet.
8. Go to 'Help' and select 'Microsoft Excel Help.'
9. Type 'check register' in the search box and press 'Search.'
10. Click 'Check Register.' This will be your first result. Press 'Download' to download and use the template.
11. Follow the instructions in the box that appears to begin using the template.

Read more ►

How to Edit Cells With Multiple Users in Excel 2007

1. Format the document prior to sharing it across a network. Once an Excel 2007 file is shared, many common formatting procedures are no longer available until the sharing is deactivated. These include conditional formatting, charts, pictures, links, outlines and PivotTables. It is best to prepare the file for mass data entry with the features everyone will need during editing.
2. Click on the 'Share Workbook' button. This will open up the features dialog for network sharing of the Excel 2007 document with multiple users. The button is found on the Review tab of the Excel 2007 toolbar, in the Changes group.
3. Save or copy the file to a shared network folder that all users can access.
4. Inform all users of the location of the shared Excel 2007 document. Each user will see changes by other users every time they press the 'Save' button. The overlapping changes in the document will occur seamlessly with the exception of multiple edits to the same data cell. In this case, saving the file will launch a conflict resolution window to choose between your changes and those input by another user.

Read more ►

How to Change the Order of the Legend in an Excel Graph

1. Locate the chart data in the Excel spreadsheet. To locate the applicable data, click on the graph: the data will be surrounded on the worksheet by a blue box.
2. Copy the data, then paste it to a clear area on your workbook. Alternatively, paste it into a new worksheet.
3. Change the data into the order you want it to appear on the graph then copy and paste the columns.
4. Copy and paste the new data order back into the original spot on the workbook.

Read more ►

How to Remove Leading Zeroes in Excel

1. Open the spreadsheet that you want to edit in the Microsoft Excel program.
2. Highlight the cells that contain decimal information for which you'd like to remove the leading zero.
3. Right-click the highlighted cells and choose 'Format Cells.' This will open a cell-formatting options window.
4. Click the 'Number' tab and select 'Custom' from the category list.
5. Click the text box underneath the 'Type' heading and press the 'Backspace' key multiple times to clear the contents of the field.
6. Type a decimal point and then type the number of zeroes that correspond to the number of decimal places that you want to display in the cells. For instance, to display three decimal places with no leading zero, you would input: .000.
7. Click the 'OK' button to save your changes. The decimal information in the formatted cells will now be displayed without a leading zero.

Read more ►

How to Create an Alphanumeric Custom List in Excel 2007

Create the List
1. Open Excel and click on the Office button, which is located in the top left-hand corner of the window.
2. Click the 'Excel Options' item from the menu that drops down.
3. Click on the category labeled 'Popular.' Locate the section called 'Top options for working with Excel.' Click the 'Edit Custom Lists' item in this section.
4. Click the 'New List' option located in the 'Custom Lists' box.
5. Type the first item of the custom list. Choose any combination of alphanumeric text characters. Enter the item into the 'List entries' box. Press the Enter key on the keyboard.
6. Type the rest of the list items, pressing Enter after each list item.
7. Press the 'Add' button when the list is complete. The new list displays in the 'Custom lists' box.
8. Press the 'OK' button, and then press it again to close out the open windows. The custom list is now created in Microsoft Excel 2007.
Use the Custom List
9. Type the first custom list item into a cell in the Excel 2007 window.
10. Type the second list item in an adjacent cell to the first item. This may be entered in a cell on any of the four sides of the first list item.
11. Select the two cells by clicking on one and dragging with the mouse to the other. The two cells will appear with a dark, translucent overlay.
12. Hover the mouse over the lower right corner of either cell. The mouse cursor will change to a small black ' ' sign.
13. Drag the mouse in the desired direction for the completed list. Drag for as many cells as you desire. Release the mouse, and the custom list is filled into all the cells.

Read more ►

How to Insert the Time Date in an Excel Spreadsheet

1. Navigate to the cell to which you want to add the date and time. Click on the cell to highlight.
2. Move your mouse up to the 'Fx' bar above the spreadsheet. This is the bar where you enter formulas for specific cells.
3. Type '=Now()' without the quotation marks. This enters the current date and time into the Excel spreadsheet in the selected cell.

Read more ►