How to Convert Quattro Pro to Text Delimited

1. Click 'Start' on the desktop and click 'Settings,' 'Control Panel' and 'Add/Remove Programs.'
2. Click 'Microsoft Excel 2003' and click 'Add/Remove.' Click 'Add or Remove Features' and click 'Quattro Pro 5.0 Converter.'
3. Click 'Run From My Computer' and click 'Update Now.' Launch Microsoft Excel, and click the File menu at the top of the Excel window.
4. Click 'Open' and locate the Quattro Pro file with the WB1 file extension. Double-click the file to open it in Excel.
5. Click the File menu and click 'Save As.' Click the 'Save as Type' drop-down menu, and click '*.txt.'
6. Click 'Save' to convert the WB1 file to the TXT format.

Read more ►

How to Multiply Cells in Excel

Multiply with Cell References
1. Click on cell A1. Type the number 12 into cell A1. Type the number 6 into cell B1.
2. Click on cell C1. Type the equal sign (=) at the beginning of your equation.
3. Click on cell A1. This action places A1 in cell C1 on the right side of the equal sign.
4. Type an asterisk (*) sign into cell C1.
5. Click on cell B1. This action places B1 into cell C1, after the asterisk.
6. Press the 'Enter' button on the keyboard or click on the check mark on the tool bar to display a result. The number 72 should appear in cell C1.
Multiply Numbers in a Cell
7. Click on a blank cell. Type in the first number you want to multiply, for instance, 6.
8. Type in an asterisk (*).
9. Type the second number, for instance, 3.
10. Press the 'Enter' key or click on the check mark button on the toolbar. The result should appear in the cell.
Multiply a Group of Numbers by One Number
11. Enter the numbers you would like to multiply in a group of cells. For instance, enter the numbers 5, 4 and 8 into cells B1, B2 and B3.
12. Type the number 7 into cell A1.
13. Select cell A1. Open the 'Edit' menu and click on 'Copy.'
14. Select cells B1, B2 and B3.
15. Open the 'Edit' menu and select 'Paste Special.' In the 'Operations' section of the 'Paste Special' box, click on 'Multiply.'
16. Click 'OK' to perform the calculation. The numbers in cells B1, B2 and B3 should now be 35, 28 and 56, respectively.
17. Delete the number in A1.
Multiply Numbers in Different Cells with the PRODUCT Function
18. Enter the numbers you want to multiply. Type 4, 8 and 10 into cells A1, A2 and A3 respectively. Type the number 2 into cell B1.
19. Click on cell A4. Type =PRODUCT(A1:A3).
20. Press the 'Enter' key to perform the calculation. The PRODUCT function will multiply all the numbers in the range. Cell A4 should display 320.
21. Use the PRODUCT function to multiply a group of numbers in a range by a number. To multiply the numbers in cells A1, A2 and A3 by 2, click on cell A4. Type =PRODUCT(A1:A3,2).
22. Press the 'Enter' key to display the result. Cell A4 should show 640.

Read more ►

How to Protect a Worksheet in Excel

1. Open the Excel workbook in which you want to convert and replace the date data with day-of-week data. If this workbook is not available, open up a new file for practice. If using a practice workbook, enter some sample data.
2. Select 'Tools' from the main menu.
3. Select 'Protection' from the drop-down list.
4. Select 'Protect Sheet' from the drop-down menu.
5. Left-click with your mouse in the box labeled 'Protect worksheet and contents of locked cells.'
6. Enter a password to unprotect the sheet in the 'Password to unprotect sheet' field. If you do not enter a password, any user will be able to unprotect the sheet and make changes to the data or formulas.

Read more ►

How to Do a Budget Spreadsheet With Excel 2003

1. Press the “Windows” and “R” keys on your keyboard simultaneously, type in “Microsoft Excel,” and then click “Run” to open Excel 2003.
2. Click on the first square at the top left of the spreadsheet (A1) and then type in “Expense.”
3. Press the “Tab” key on your keyboard, this will put you on the square directly to the right of A1 (B1) and then type in “Sub Total.”
4. Press “Tab” to move to C1 and then type in “Actual Money Spent.”
5. Click on A2 and then type in “Savings.”
6. Press the “Enter” key on your computer keyboard, this will take you to the square directly below A2 (A3) and then type in “Savings Account.” Repeat this step for every type of savings or savings account you have including IRA, CD and Money Market accounts.
7. Type in every type of expenditure you have in all consequent squares within the A column until you have no more expenditures. Examples include groceries, gasoline, clothing, medical insurance, taxes, car repairs, credit card bills and utilities.
8. On the squares next to the expenditures and below “Sub Totals,” all the squares in the B column, type in the amount of money you estimate you will spend on those items for the month. For example, if you think you’ll spend $100 a week on groceries, type in “400” next to groceries.
9. Type in the actual amount of money that you spent on a certain item at the end of the month within the squares under the C column. For example, you actually only spent $370 on groceries so you would type “370” next to the 400 you estimated for groceries.

Read more ►

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 ►