How to Use the Option Buttons in Excel

1. Open Excel. Click 'File' and 'New' in the menu bar. Select 'Blank Workbook' from the pane on the right side of the Excel window.
2. Turn on the Forms toolbar. Right-click in the gray area of any toolbar. Select 'Forms' from the displayed list.
3. Add a group box. Select 'Group Box' from the 'Forms' toolbar. Click and drag in the spreadsheet with the mouse to create a group box of the desired size.
4. Rename Group Box 1 by highlighting the text and typing an appropriate name.
5. Create the option button. Click on 'Option Button' in the 'Forms' toolbar. Click in the desired area of the group box to paste the option button.
6. Customize text for the option button. Right-click the option button. Select 'Edit Text' from the displayed menu. Type the new name.
7. Change the appearance of the option button, if desired. Right-click the option button. Select 'Format Control'. Add color and select line style and weight.
8. Create more option buttons by repeating Steps 5, 6 and 7. Use the arrow keys on the keyboard to align or reposition the option buttons.
9. Save the file. Click 'File' and 'Save' in the menu bar. Name the file. Click the 'Save' button. Click on 'File' and 'Close' in the menu bar to close the file.

Read more ►

How to Export OpenOffice Calc to XML

1. Open your Calc spreadsheet in OpenOffice.org's Calc program.
2. Click 'File' in the top menu and select 'Save As'. Alternatively, hold the 'Ctrl' and 'Shift' keys down and press 'S'.
3. Click the drop-down menu next to 'Save as type' and select 'Microsoft Excel 2003 XML (xml)'.
4. Enter a new name for your spreadsheet if one is not automatically chosen. If you previously saved this document the original file name is filled in. You can use this file name without overwriting the original file, since the extension will be different.
5. Click 'Save' to export your Calc spreadsheet in XML format.

Read more ►

How to Make a Thermometer Chart in Microsoft Excel

1. Open a blank worksheet in Excel. Enter headings for two columns of data, such as 'Month' and 'Total Clients' in cells A1 and B1. Enter the appropriate data into the column cells. The data should be building toward a goal.
2. Enter the goal number at the bottom of the column and enter the actual number reached in the cell beneath the goal amount, which will be the number in the last cell.
3. Skip a cell below the totals, and enter a formula to determine the percentage reached in the next cell. In the Formula Bar, use the formula total amount/goal amount. For example, the formula could be '=B17/B16.' Right-click the cell, select 'Format Cells,' select the 'Number' tab and choose 'Percentage.'
4. Select the cell with the percentage amount. Click the 'Chart Wizard' button in Excel 2003 or earlier and select a clustered column chart. In later versions of Excel, select the 'Insert' menu and choose a clustered column. In step 3 of the chart setup, go to the 'Axes' tab and clear 'Category (x).' On the 'Legend' tab, clear 'Show Legend,' and on the 'Data Labels' tab select 'Value.' Click 'Finish.'
5. Double-click the column of the chart. The Format Data Series dialog will open. Click the 'Options' tab and change the 'Gap Width' to '0.' Go to the 'Patterns' tab and click on 'Fill Effects.' On the 'Gradient' tab, select two colors, such as black and red, and select 'Horizontal' in the shading styles. Click 'OK' twice to apply changes and close the dialog.
6. Drag the left side of the chart toward the right, making the graph thinner. Right-click the chart and select 'Format Chart Area.' On the 'Patterns' tab, select 'None' for both Border and Area. Click 'OK' to apply the changes.
7. Add a circle auto shape at the bottom of the chart by selecting the autoshape from the drawing toolbar in Excel 2000 to 2003, or from the 'Insert' tab in later versions of Excel. Right-click the circle and select 'Format Shape.' Fill the circle with the same gradient colors used in the chart.

Read more ►

How to Break Hours Minutes Down into Increments for Excel

1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'A1' and type in the time that you want to break down. Enter the time as 'hh:mm.'
2. Click on cell 'B1' and enter the following formula into the cell:=ROUND(A1*(1440/x),0)/(1440/x)Change each 'x' to be a number equal to the number of minutes in your desired time increments. If your increments are in seconds, change both instances of '1440' to '86400' and enter the number of seconds in each increment for 'x.' Press 'Enter' to complete the formula and a small number will appear in the cell.
3. Right-click cell 'B1 and choose 'Format Cells' from the drop-down menu. Click on 'Time' on the left side of the window that appears. Then choose the '37:30:55' option on the right side of the window. This format will allow you to view amounts over 24 hours correctly. Click 'OK' and the small number in cell 'B1' will be changed into your rounded time.
4. Click on cell 'C1' and enter the following formula:=B1/(0.00069444*x)Change 'x' to be the number of minutes in your increments. If your increments are in seconds, change the formula to read:=B1/(0.000011574*x)Change 'x' to be the number of seconds in your increments. Press 'Enter' to complete the formula and cell 'C1' will break your hours and minutes in cell 'A1' down into a number of increments.

Read more ►

How to Restore One Deleted Excel Worksheet

1. Click the 'Office Button' and select 'Save As' from the drop-down menu. Select Excel Workbook from the 'Save As' menu and type a new name for your workbook in the 'File Name' field. Press 'Save.' You will now have two workbooks---your original workbook before you made any changes with the 'deleted' worksheet intact, and the newly saved workbook with all of your changes. Only your newly created workbook will remain open.
2. Open your original workbook. You should now have both workbooks open.
3. Right click on the name tab of the 'deleted' worksheet in your original workbook and click 'Move or Copy...' when the menu appears. Under the 'To book' option, select your new workbook and choose where you would like the worksheet to appear in the 'Before sheet' option. Click 'OK.' Note that Excel takes you to your new workbook and the 'deleted' worksheet is displayed.
4. Check to make sure that links between worksheets, formulas and macros are functioning as expected. The next step will eliminate your original workbook, so be absolutely certain that your new workbook is correct before moving forward. If everything is in order, go back to your original workbook and close it.
5. Save your new workbook, renaming it with the original workbook name. The workbook with the 'deleted' worksheet will be overwritten with your now correct workbook.

Read more ►

How to Learn Excel 2003

1. Learn Excel directly from the maker using the resources available at Microsoft Office Online. This website offers courses ranging from 30 to 50 minutes that walk you through the basics of how to use Excel, so you can be on your way in just a couple of hours.
2. Check the website of your local community or technical college for introductory classes on Excel. These classes may be free or discounted compared to private university tuition. If you are a senior citizen you may be eligible for a discount on tuition. Most classes will focus on newer versions of Excel, but you can ask the instructor which functions are compatible with the 2003 version, and the basic operation of the software remains the same.
3. Teach yourself using the Help files that are included with Microsoft Excel. Simply open up Excel and press 'F1' on your keyboard to launch the Help panel. Browse to 'Training' and click on 'Get to know Excel 2003.' This will walk you through the basics of Excel.

Read more ►

How to Use Microsoft Excel 2003 as a Normal User

1. Open Microsoft Excel 2003. A blank spreadsheet appears. At the top, the toolbar lists the functions available to you. Use the arrow keys on your keyboard to move one cell at a time throughout your spreadsheet. You can also click into any cell.
2. Enter information by typing it and pressing the 'Enter' key. For example, to keep track of grades for three students, enter the first name in cell A2. Enter the second name in cell A3. Enter the third name in cell A3. Enter 'Test 1' in cell B1. Enter 'Test 2' in cell C1. Then, enter the grades for the students.
3. Format cells to make your spreadsheet easier to read. Click your mouse in cell B1 to add some formatting. Press the 'CTRL/B' keys to add bolding to the cell. Click your mouse in cell C1 to do the same thing. Press the 'CTRL/B' keys to add bolding to the cell. Notice that the numbers automatically align to the right of the cell. Text aligns to the left.
4. Add formula to perform calculations. For example, add a formula to cell D2 that calculates the average grade for the student in that row. Enter the formula below that adds the two numbers in cells B2 and C2 (the grades for the first student) and then divides them by the number of grades (in this case, 2).=(B2 C2)/2
5. Use Microsoft Excel 2003 functions to make your work easier. For example, replicate the formula you just entered by selecting cell D2. Press the 'CTRL/C' key to copy it. Click into cell E2 and press the 'CTRL/V' keys to paste the formula into the cell. To replicate a formula across a range of cells, select the cell that contains the formula and click the bottom right corner. Drag it down several rows and the formula copies into each cell, changing to reflect the current row.
6. Insert a new row by placing your cursor directly below where you want to put the new information. From the 'Insert' menu, select the 'Rows' option. To insert another column, select the 'Columns' option from the 'Insert' menu.
7. Sort information to order and organize it. Excel retains the relationships within the information for you. For example, to arrange student grades in descending order, click the 'Sort' option from the 'Data' menu. Set the sorting to 'Descending' to organize the information in this manner.

Read more ►

How to Have Multiple Users Use One Sheet in Excel

Sharing in Excel 97/2000/XP/2003
1. Create or open the workbook you would like to share.
2. Under the Tools menu, select 'Share Workbook.'
3. The 'Share Workbook' window will appear. The 'Editing' tab shows all users who currently have the workbook open (you should see your name in the list). Click the box to allow other users to access the workbook simultaneously.
4. The 'Advanced' tab allows you to adjust the options for sharing, such as how long changes are tracked, how often they are updated and what happens when information conflicts. Select the options you wish to implement and click 'OK.'
5. A message box will appear confirming you would like to save the workbook. Click 'OK.' The word 'Shared' should now follow the file name at the top of the window.
Sharing in Excel Office 2007
6. Create or open the workbook you would like to share.
7. Under the 'Review' tab at the top of the page, click on the 'Share Workbook' icon in the 'Changes' group.
8. As with previous Excel versions, the 'Share Workbook' window will appear. The Editing tab shows all users who currently have the workbook open (you should see your name in the list). Click the box to allow other users to access the workbook simultaneously.
9. Click on the 'Advanced' tab to adjust the options. Select the options you would like to implement and click 'OK.'
10. If it is a new workbook, the program will prompt you to save it. Enter the file name you wish to use and click 'Save.' If the workbook has already been saved, a message box will appear confirming you would like to save the workbook. Click 'OK.' The word 'Shared' should now follow the file name at the top of the window.

Read more ►

How to Select Cells as the Print Area in Excel 2003

1. Click on the first upper-left cell you want to print.
2. Press 'Shift' and the arrow keys until you cover the entire area you want to print.
3. Click 'File' followed by 'Print,' 'Selection' and 'Print' again.

Read more ►

How to Add Comments to a Worksheet in Excel 2003

1. Open your Excel worksheet.
2. Select the cell to which you wish to add a comment. Click on the cell with your mouse's left button.
3. Select 'Insert' from the top menu bar and in the dropdown menu choose 'Comment.'
4. A text box will appear right after you click 'Comment.'
5. Type your comment into the text box.
6. When you've finished typing, click anywhere outside of the text box. This will save your changes.

Read more ►

How to Convert Lotus to Excel 2003

1. Click 'Start,' then 'All Programs,' then 'Microsoft Office,' then 'Microsoft Excel 2003.'
2. Click 'File,' then 'Open.' Click the file type drop-down menu and select 'All Files and Folders.'
3. Locate your Lotus 1-2-3 file, then select it and click 'Open.'
4. Click 'File,' then 'Save As.'
5. Click the file type drop-down menu and select 'Microsoft Excel Workbook.' Choose a name for your converted file and click 'Save.' You have now converted Lotus to Excel 2003.

Read more ►

How to Align a Worksheet Horizontally Vertically in Excel 2003

1. Open the Excel file that contains the worksheet that you want to align horizontally and vertically. Click the appropriate worksheet.
2. Click the 'File' menu and select the 'Page Setup' option, which opens a separate window. Click the 'Margins' tab on the Page Setup window.
3. Click the 'Horizontally' and 'Vertically' check boxes under the Center on Page section.

Read more ►

How to Create a Line Graph in MS Excel

Create Graph
1. Open Excel and enter your information onto a worksheet. For a line graph, you can arrange the data in rows or columns. For example, if you are showing the monthly average temperatures for a location, you could head each column with the month and each row could represent a different year.
2. Click on the first cell you want included in your line graph and while holding down the mouse button, drag your mouse to highlight the rest of the data you want on your graph.
3. Click on the 'Insert' tab and select 'Line' from the 'Chart' options. The picture shows a line graph. Choose and click on the chart subtype you want from the pictures. If you move your mouse over each subtype, it gives you a description of the graph.
4. Move the chart to the desired location on your worksheet by clicking on it and dragging when you see the four-way arrow.
5. Adjust the size of the chart by moving each side, and the top and bottom in or out with your mouse.
6. Click on the chart so that your chart formatting tool options, 'Design,' 'Layout' and 'Format' appear in your ribbon choices at the top.
7. Select 'Layout' from your ribbon and set your format preferences. Click on the arrow by each heading such as 'Chart Title,' 'Axis Titles,' 'Axes,' 'Plot Area' and 'Gridlines' to see preformatted choices.
8. Look at the options and click on the choices you want for your layout.
9. Choose 'Design' from your ribbon options to adjust the chart layout or style. If you choose a layout you don't like, you can click another one and it will automatically change. You can switch the row and column information if Excel is laid it out differently than you wanted.
10. Go to 'Format' to change the format of any of the elements you added. Click the arrow in the 'Chart Elements' box and choose the element you want to format. You can change the color, size or appearance of that element now.
11. Double-click on the different elements in your chart and type in the information you want for your chart. For example, click twice on 'Chart Title' and highlight the words. Type in 'Average Temperatures' or your desired title. Do the same for the axis titles and any other elements you added.
Separate Chart
12. Click on the chart if you want to move it to a separate worksheet or have it appear on a new worksheet. It automatically appears as an embedded chart on the current worksheet.
13. Select the 'Design' tab and then choose 'Move Chart.'
14. Click 'New Sheet' or 'Object in' and choose the worksheet where you want the chart to appear.

Read more ►

How to Make a Gradebook in Excel

1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'A1' and enter in 'Name,' as this is the column where the student's names will go. Click on cell 'B1' and enter 'Points,' as this is where the student's points will be totaled. Click on cell 'C1' and enter 'Percentage,' as this is where the student's grade percentage will go.
2. Select cell 'D1,' and then progressing down the rest of the spreadsheet's top row, enter the names of the quizzes, homework assignments, tests, projects and anything else the students will be graded on. If you aren't sure how many of these you will have, just type in 'Assignment' as a placeholder, so that you have created enough assignment spaces to fill the entire quarter, semester or year.
3. Click on cell 'A2' and type in 'Points.' This row will be where you enter in the number of points each assignment will be worth. The number that you enter into this row will be for the assignment listed in that same column. Click on cell 'B2' and enter in '=sum(D2:Z2)' where 'Z' is the last column you have used for your assignments. This will give you a total number of points so the spreadsheet can make its calculations.
4. Click on cell 'A3' and type in the name of your first student. Continue to add names down the first column until you have added the entire class.
5. Click on cell 'B3' and enter the following formula: '=sum(D3:Z3)'. Then click on cell C3 and enter the following formula: '=sum(D3:Z3)/$B$2'.
6. Click and hold the mouse button on cell 'B3,' then drag the mouse over to cell 'C3' and release the button. Move your mouse over the fill handle in the lower right corner of 'C3,' then click and hold the mouse button. Drag the mouse down your spreadsheet to copy these formulas down the columns. When you reach the row where your last student is located, release the mouse button.
7. Click on the 'C' above the third column. Click the 'Home' tab at the top of the window. Then click the drop-down box in the Number area of the ribbon. Choose 'Percentage' from the list of choices and your grades will now display as percentages.

Read more ►

How to Create a List Box in Microsoft Excel

1. Double-click the Excel spreadsheet you want to alter. This loads the spreadsheet and the Excel software at the same time.
2. Click a cell in which you want the list box to display. Click the 'Data' menu item in the main toolbar. In Excel 2007, click the 'Data' ribbon tab.
3. Click the 'Validation' menu option. In Excel 2007, click the 'Validation' button and select 'Data Validation' again. This opens a new window where you set the list box settings.
4. Click 'List' in the first window. This sets the type of drop down box for the cell. When the drop down type is selected, a text box is enabled. Click the arrow next to the text box. This opens a new window where you select the cells that hold the values for the list box.
5. Highlight each Excel cell with the values for the list box. When you are finished, press the 'Enter' key. The cell selection window will close. Click the 'OK' button. This closes the configuration window and the list box is created in the spreadsheet.
6. Click the list box arrow to view the information. This shows you all the values and tests the list box functionality.

Read more ►