How to Add Headers and Footers to Documents in Excel 2003

1. Open your Excel worksheet after logging on to your computer. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Go to 'View'. From the displayed menu, select 'Header and Footer'. Choose your desired header or footer from the appearing options. Drag your mouse across the icons to view their descriptions. Click on 'Insert Auto Text' for more options.
3. Create a custom header or footer by selecting 'Custom Header' or 'Custom Footer'.
4. Choose either 'Left Section', 'Center Section' or 'Right Section'.
5. Select the buttons to insert the desired header or footer for that section.
6. Enter additional information if desired in the respective box (left, center, right), start a new line in respective section by pressing 'Enter' or delete a section of the header or footer by highlighting information in the section box and pressing backspace.

Read more ►

How to Calculate Median in Excel

1. Enter a list of numbers down a column that you would like to calculate the median for. Make sure the numbers are in ascending order.
2. Click on a cell where you would like the median to appear. This can be the cell after the last number or any other area in the spreadsheet where you want the median to appear.
3. Type =MEDIAN(range) in the cell, with the range specified as the range of cells containing the data. For example, if you have data in cells A1 through A6, the range would be A1:A6. Alternatively, in Microsoft Excel 2007, you can click on the 'Formulas' tab in the toolbar. Click on 'Insert Function,' type 'Median' and press 'OK.'

Read more ►

How to Open an Excel 2007 File in Excel 2003

1. Go to the download page for the Microsoft Office Compatibility pack using the link in the References section of this article.
2. Click the 'Download' button, and save the file to the location of your choice. The name of the download is 'FileFormatConverters.exe.'
3. Launch the program. You may have to click a 'Run' button to confirm that you want to run it. Read the license agreement for the software. If you agree, put a check in the box and click 'Continue.' The installation will proceed automatically. Click 'OK' when it is finished.
4. Restart your computer.
5. Double click the Excel 2007 file with an XLSX extension. You will see a window saying 'File conversion in progress.' After a few seconds, the file will open.

Read more ►

How to Merge Multiple Workbooks in Excel 2003

1. Open Excel on your computer. Make sure that each workbook to be merged has a unique name and is located in the same folder on your hard drive.
2. Open the workbook that you want to merge all changes into.
3. Go to the 'Tools' menu and select 'Compare and Merge Workbooks.'
4. Save the workbook, if prompted by Excel to do so.
5. Select the workbooks to be merged into the currently open workbook, by clicking on the name(s) in the 'Select Files to Merge into Current Workbook' dialog box. To select more than one file name, hold down the 'Control' key while clicking on multiple file names. Click 'OK.'

Read more ►

How to Add a Line to an Excel Stacked Chart

1. Right-click on your chart, and click the 'Select Data' option.
2. Click 'Add' in the 'Select Data Series' dialog box under 'Legend Entries.'
3. Enter the data range you want to use for the line graph in the 'Edit Series' dialog box under 'Series values.' Click 'OK,' and close out of the dialog boxes.
4. Click once on your new data series in the chart, regardless of the format the series defaulted to.
5. Right-click on your highlighted data series, and click 'Change Series Chart Type.'
6. Select the 'Line' option in the dialog box, and click 'OK.'

Read more ►

How to Use Excel 2007 for Student Grades

1. Type 'Student Name' in cell A1.
2. Type the names of each assignment in Row 1, starting with the first one in cell B1, directly to the right of the Student Name text.
3. Type 'Total' in Row 1, in the column directly to the right of the last assignment.
4. Type each student's name into column A, starting directly below the 'Student Name' text.
5. Type the number of points each student earned on a given assignment in the appropriate cell.
6. Type '=SUM(' in the first cell directly underneath the 'Total' text, then highlight each cell in the row that corresponds to an assignment going back to the first student. To highlight, click the first assignment cell and drag the mouse to the last assignment cell, making sure to select only one row of data. Press 'Enter.' This should display the total number of points this student received from all the assignments, in the Total column.
7. Highlight the 'Total' cell you just created, by clicking on it.
8. Copy the cell by pressing 'Ctrl' and 'C' at the same time.
9. Highlight the cells for each student in the Total column by clicking on the cell directly below the cell you just copied, and dragging the mouse to the very last row that contains a student name. Make sure you select cells only in the Total column.
10. Paste the Total formula by pressing 'Ctrl' and 'V' at the same time. You should see the totals for each student appear in the appropriate row in the Totals column.

Read more ►

How to Apply Text Attributes Cell Borders in Microsoft Excel

1. Click on the 'Home' tab to display the 'Home' ribbon. For Excel 2003, skip this step.
2. Select the cell or cells to which you want to apply your text attributes.
3. Click on the 'B' button located in the 'Font' section of the ribbon (Excel 2007) or in the formatting toolbar (Excel 2003). This will make your text bold. Click on the 'I' to italicize the text. Click on the 'U' to underline the text. To remove a text attribute, click on the same button you used to apply the attribute.
4. Click on the diagonal arrow in the bottom right corner of the 'Font' section to display the 'Format Cells' dialog box. For Excel 2003, click on 'Format' in the main menu. Then, select 'Cells.' Opening this dialog box gives your more options for formatting your text. Select the options you wish to apply and click the 'OK' button to close the dialog box.
5. Select the cell or cells to which you want to apply cell borders.
6. Click on the arrow next to the square (partitioned into four equal parts) graphic located next to the 'U' in the 'Font' section (Excel 2007) or formatting toolbar (Excel 2003). A drop-down will appear. This drop-down shows the various ways to apply borders to your selection. Select 'Bottom Border' to apply a bottom border to all of your selected cells. There are a variety of ways to apply borders: top, left, right, all, thick, and many more. Play around with the options to become more familiar. You can always select the 'No Border' option to remove all borders from a selection.

Read more ►

How to Allow Value Changes to Excel Protected Cells Using Macros

1. Select 'Edit' > 'Find' > 'Options' > 'Format' > 'Select Locked' > 'OK' > 'Find All.' This will identify which cells are actually locked. On an unmodified sheet, you can skip this step since all cells are marked as Locked by default.
2. Select 'Tools' > 'Visual Basic Editor' and type 'Sub unlockit.' Press 'Enter.' On the next line, type 'End Sub' (minus quotes). In between these two lines is where you will enter the macro.
3. Type in 'Range('A1..A20').Locked = False.' The range can be any range of data you want to unlock. This line can also be entered in an already existing macro where needed.
4.
Always save your work to avoid redoing it.
Select 'File' > 'Save.' You can either run the macro manually from 'Tools' > 'Macro' > 'Macros,' or use the Forms toolbar to create a button on your worksheet and assign the macro to it.

Read more ►

How to Create a Four Axis Chart in Excel 2007

Add a Secondary Vertical Axis
1. In a chart, select the data series you want to put on a second vertical axis. Either select the data series from the chart itself or select it from a list in 'Chart Tools.' To select it from a list, click the chart. In 'Chart Tools,' click the 'Format' tab. In the 'Current Selection' group, click the arrow in 'Chart Elements.' Select the data series to which you want to add a secondary vertical axis.
2. On the 'Format' tab, in the 'Current Selection' group, select 'Format Selection.' The 'Format Data Series' box will display.
3. On the 'Series Options' tab, under 'Plot Series On,' select 'Secondary Axis.' Click 'Close.' The new axis will display in the chart.
4. On the 'Layout' tab in 'Chart Tools,' in the 'Axes' group, click 'Axes.' Click 'Secondary Vertical Axis' to change the display options for the axis. To change the axis options, right click the secondary axis and select 'Format Axis.' Make options changes under 'Axis Options.'
5. Repeat these steps for each data series to which you want to add a secondary vertical axis.
Add a Secondary Horizontal Axis
6. Click the chart that displays a secondary vertical axis. You cannot display a secondary horizontal axis without a secondary vertical axis.
7. On the 'Layout' tab in 'Chart Tools,' in the 'Axes' group, select 'Axes.'
8. Click 'Secondary Horizontal Axis.' Make changes to the display options that you want.

Read more ►

How to Merge and Center Headers in Microsoft Excel 2007

1.
Select the cells you would like centered above the table in the worksheet.
2.
Click on the 'Merge and Center' icon located in the Home Tab on the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.
3.
Click on the 'Merge and Center' option from the drop-down menu.
4. Click on the 'Unmerge Cells' option to un-merge the cells.

Read more ►

How to Compute Annual Gross Pay in Excel

1. Open a new Microsoft Excel 2010 spreadsheet.
2. Click in cell 'A1.' Type in the name of the first company from which you received money for the year in question. Press 'Enter' to move to the cell directly beneath this cell.
3. Enter your yearly gross pay for this company, if you know it, or your bi-weekly gross pay if you don't. Ensure that you are entering your gross pay, which is the amount before any taxes are taken out, and not your net pay, which is what you actually take home. Press 'Enter' to move to the next cell underneath this one.
4. Enter the following formula, without quotes: '=(A2/14)*365' if you entered your bi-weekly gross pay in the previous cell. Change '365' to '366' if you are calculating for a leap year. If you entered your yearly pay into the cell, just enter in '=A2.'
5. Click in cell 'B1' and repeat the process for the next source of income. Continue until you have each source of income in its own column.
6. Click in cell 'A4.' Enter the following formula, without quotes: '=sum(3:3).' When you press 'Enter,' the number that appears will be your total gross pay for the year.

Read more ►

How to Format Equations in Multiple Cells in MS Excel

Simple Equations
1. Launch Microsoft Excel 2010.
2. Click 'File' and 'Save As.' Navigate to a saved document location if necessary and type a name for the new spreadsheet into the 'File Name' box. Click 'Save' to save the new spreadsheet.
3. Click in the cell that is going to contain the results of the equation.
4. Press the 'Equal' sign ('=') on the keyboard to begin creating the formula for the equation.
5. Click on the first cell that contains data for the equation. Press the 'Plus' key (' ') on the keyboard to begin an addition formula with the current cell as the first item to be added. Alternately use a different operator, such as the 'Minus' sign ('-'), 'Asterisk' key ('*') or the 'Slash' key ('/') to subtract, multiply or divide, respectively.
6. Click on the next cell in the equation and press 'Enter' if the equation ends with this cell or press another mathematical operator and click on an additional cell to continue the formula. Repeat as necessary until the formula is complete.
Complex Formulas
7. Launch Excel 2010 and open every workbook that contains information that will be used in the complex formula.
8. Click the cell where the answer to the complex formula will be displayed.
9. Click 'Insert Function' from the 'Formulas' tab on the toolbar.
10. Type the name of the function or operation into the 'Search for a Function' dialog box and click 'Go' or select a category of function from the pull-down menu to see a list of functions. Click on the function name and click 'OK' to launch the function wizard.
11. Click in the first box in the 'Function Arguments' box and then click once on the cell that contains the information requested by the dialog box. Repeat for each requested input and click 'OK' to create the formula. Click 'Help on This Function' for a more detailed explanation of the function and what is needed to complete it properly.

Read more ►

How to Do Standard Error Bars on Excel Charts

1. Open a new workbook in Microsoft Excel. Enter data points in cells down two columns. For example, if we want to plot the number of students that earned a certain average exam grade, we would list the number of students down column A and the average grade in column B.
2. Highlight the data in both columns. Go to the 'Insert' tab and choose a chart type. For example, we can choose a scatter chart to plot the data.
3. Click on a data point to select all of the data points in the chart, or click twice on a data point to only select that data point. You can have standard error bars for one data point or all of the data points.
4. Go to the 'Layout' tab under Chart Tools and click on 'Error Bars.' Select 'Error Bars with Standard Error.'
5. Click on the 'Error Bars' menu and select 'More Error Bar Options.' You can change the direction of the error bars, the end style, and the error amount. The line color, style and shadow can also be customized.

Read more ►

How to Create an Excel Spreadsheet Online to Share

1. Collect the email addresses of those individuals with whom you will share the information. You will be able to link them and notify them of any changes via their email address.
2. Create the Excel spreadsheet you intend to share if you have the information handy. Otherwise, you can create your spreadsheet in any one of the office suite programs.
3. Create an account, if necessary, to access any one of the above office suite programs. If you already have a Windows Live or Google account, then you will sign into either program using that account. With Zoho Sheet, you can sign in using your Google, Yahoo or Facebook account. While Microsoft Office Live and Google Docs offer valuable preloaded templates (whereas Zoho Sheet requires you to find or create your own templates), using Microsoft Live does require that you download a plug-in. This makes it an excellent option for home or office use, but with a shared computer such as in a computer lab or library, it may not be a viable option for you, since many of these facilities don’t allow software to be installed by public users.
4. Upload an existing spreadsheet or create a new spreadsheet as you would in Microsoft Excel, as the user interface on all three programs is nearly identical. Then save the spreadsheet. To share it, you will need to title and save the document.
5. Share the document by entering the email addresses of those you wish to view or manipulate the document. As you select a user, you can designate their privilege, such as to 'read only' or 'edit.' With Google Docs, you also have the ability to assign additional editors who will then have the added permissions to invite others. Once you’ve given an email address, the recipient will receive an email and her designated privilege and she can begin accessing or editing the shared documents.

Read more ►

How to Change the Default Email in Excel 2003

1. Start Internet Explorer by double-clicking on the icon on the desktop or by clicking 'Start' and choosing the 'Internet Explorer' icon on the Start menu.
2. Select the 'Tools' menu option, and then click on 'Internet Options.'
3. Click on the 'Programs' tab on the 'Internet Options' dialog box.
4. Click on your desired email program from the 'Email' combo box.
5. Click 'Apply' and then 'OK' to save changes. Now you can use your desired email program as your default email for Excel 2003.

Read more ►