How to View Headers and Footers in Microsoft Excel 2003

1. Scroll to the “View” tab on the command bar; the “View” submenu will open.
2. Under the “View” submenu, select “Header and Footer” to open the Header and Footer Properties box.
3. View the headers and footers by looking at the “Header” preview box at the top and the “Footer” preview box at the bottom. If you find that you wish to make any changes, simply click on the “Custom Header” or “Custom Footer” buttons to amend them.
4. If you have made any changes, click on the 'OK' button to implement them. You can also click on this button to close the box if you have not made any changes.

Read more ►

How to Change the Margin in a Header in Excel 2007

1. Click the 'Office' button in the upper left-hand corner of the screen.
2. Click 'Print,' then 'Print Preview.'
3. Select 'Show Margins.'
4. Click on the header margin, and drag the mouse to where you want your new margins.
5. Click 'Exit Print Preview.'

Read more ►

How to Filter a List in Microsoft Excel With Limits on the Number of Rows

1. Open the workbook in Excel and click the arrow beside the column header row in the list. Next, proceed to Step 5. Alternately, if you have not yet applied AutoFilter to your list, proceed to Step 2.
2. Select the data you would like to filter. Left-click the mouse and drag it to cover the range of cells.
3. Select 'Data' from the toolbar menu. Next, select 'List' and then click 'Create List.'
4. Check the box 'My list has headers' if applicable. Next, click 'OK.' (Note: If you select this option and your list does not have a header, the first cell in the list will be assigned as the column header cell. If this option is unchecked, the default name 'Column1' will be assigned as the header row.)
5. Right-click the arrow next to the column header row, and then select '(Top 10...).'
6. Click the list box in the middle of the Show region located in the Top 10 AutoFilter dialog box.
7. Type in a number from 1 to 10. Alternately, use the down arrow next to the list box in the middle of the Show region, and scroll to pick your desired number.
8. Select 'Items' in the far right side of the Show region of the Top 10 AutoFilter dialog box, and then click 'OK.' (Note: You can alternatively select 'Percent' instead of 'Items.')
9. Test your AutoFilter list. To do this, click on the arrow next to the column header row, and then click '(Top 10...).'

Read more ►

How to Unshare a Workbook

How to Unshare a Workbook in Microsoft Excel 2003
1. Open the Microsoft Excel 2003 application on your computer and then click the “File” option from the top toolbar menu. Click on the “Open” option.
2. Locate the Excel 2003 file that has the workbook you want to stop sharing. Click on the file and then click the “Open” button.
3. Click the “Tools” option from the top toolbar menu and then click the “Share Workbook” option.
4. Click the “Editing” tab from the “Share Workbook” dialog box. Click on the box next to the “Allow changes by more than one user at the same time” option so that it is deselected.
5. Click the “Yes” button to stop sharing the workbook. Click the “File” option and then click the “Save” option to save all of your changes.
How to Unshare a Workbook in Microsoft Excel 2007
6. Open the Microsoft Excel 2007 application on your computer. Click the “Microsoft Office” button and then click the “Open” option.
7. Locate the Excel 2007 file that contains the workbook you want to stop sharing. Select the file and then click the “Open” button.
8. Click the “Review” tab and then click on the “Share Workbook” option from the “Changes” group.
9. Click the “Editing” tab from the “Share Workbook” dialog box. Click on the box next to the “Allow changes by more than one user at the same time” field so that it is deselected.
10. Click the “OK” button and the workbook will no longer be shared. Click the “Microsoft Office” button and then click the “Save” option to save your changes.

Read more ►

How to Import a Word 2007 File to Excel 2007

1. Open the Microsoft Excel 2007 spreadsheet file that you want to import a Word 2007 file into.
2. Click on the 'Microsoft Office' button, and then click on the 'Open' option. The 'Open' dialog box will appear on your screen.
3. Select the 'Text Files' option, and then double-click on the Word 2007 file that you want to import. The text import wizard dialog box will appear.
4. Click on the 'Delimited' option if your Word 2007 text includes commas or tabs that separate the fields, or click on the 'Fixed width' option if the fields are aligned in columns.
5. Select the number of the row where you want the text to be placed, and then click on the 'Next' button. Click on the 'Next' button again.
6. Select an option below the 'Column data format' heading, such as the 'General,' 'Text,' 'Date' or 'Do not import column' option. Click on the 'Finish' button.
7. Click on the 'Existing worksheet' option, and click on the 'Collapse' button to select a cell range where you want the text to be placed. Click on the 'OK' button, and your text will be imported.

Read more ►

How to Disable Add

1. Open Microsoft Excel 2003.
2. Click 'Tools' on the top navigation bar and then click the 'Add-ins' option.
3. Un-check the check box next to the add-in you want to disable.
4. Click the 'OK' button.
5. Close and restart Excel. The add-in is disabled.

Read more ►

How to Do Macros in Excel 2003

1. Open up the Excel 2003 file in which you want to create a macro. Select the 'Tools' menu at the top of the screen, then move your mouse to the 'Macro' option and select 'Security' from the pop-up menu. Select either medium or low in order for macros to operate correctly in the worksheet. Low will always prompt you if you want to run the macro, while medium will not. Click 'OK' to continue.
2. Click on the cell where you want the macro to start. You will be given the option later to use relative references, and if you are then you will need to have selected the starting macro location beforehand.
3. Click on the 'Tools' menu again and move your mouse over 'Macro.' Choose 'Record New Macro' from the list of options. A small record macro window will appear.
4. Enter in the name of your macro into the 'Name' field. The name must begin with a letter and cannot be a cell reference, like 'A1' or 'Z12.' Type in a shortcut key in the required field so that Excel will run the macro when you press the key. This key must be a letter, and is case-sensitive. If you want this macro to be available on every workbook, change the 'Store macro in' box to read 'Personal Macro Workbook.' Finally, type in a description of the macro, so that you will remember what it does. Click 'OK' when you are done.
5. Decide whether you will be using relative references in your macro. When you use relative references, any movement around the spreadsheet will be relative to whatever cell is selected when you run the macro. For example, if you are starting at cell A1 and you select cell A2 in the macro, if you are using relative references, Excel will simply select the cell below the selected cell when someone runs the macro. Without relative references, the macro will always select cell A2 regardless of what cell the user has selected. Relative references are set 'off' be default, so if you want to turn them on, click on the small button to the right of the square 'Stop' button in the macro window. Relative references will stay on until you click the button again to turn them off.
6. Perform the macro actions on your spreadsheet. The macro will record every move that you make. Click the square 'Stop' button when you are done making the macro.
7. Hold 'Ctrl' and press the letter key you assigned to the macro when you want to run it.

Read more ►

How to Use Descriptive Statistics in Excel

1. Type your data into the spreadsheet. For example, you might type a list of heights into column A or a list of egg prices in column F.
2. Click on a blank cell in a spreadsheet.
3. Click on the 'Formulas' tab on the Excel toolbar, then click on 'More Functions' in the Function Library. Click on 'Statistical' and then mouse over the function for a description, and if it is the function you need, click on it to open a dialog box for the function. For example, 'Median' returns the median, or the middle number in the data set.
4. Type the location of your data into the text box. For example, if your data is in cells A1 to A3, type 'A1:A3' into the 'Number 1' text box.
5. Click on the 'OK' button. Excel will perform the calculation and return the answer in your chosen cell.

Read more ►

How to Graph Two Datas Scatter Plot in Excel

1. Open the Excel spreadsheet containing the two columns of data you want to turn into a scatter plot. Scroll down to the bottom of the column and click the lowest cell containing the data. Drag up and across until both columns are highlighted.
2. Navigate to the 'Insert' tab at the top of the spreadsheet, which is positioned to the left of the 'Home' tab. Click the 'Scatter' button in the 'Charts' heading near the top of the screen.
3. Click the icon in the drop-down menu for the specific type of scatter plot you want to use, such as 'Scatter With Only Markers,' 'Scatter With Smooth Lines and Markers' or 'Scatter With Straight Lines.'
4. Click the scatter plot and drag it to any location on the spreadsheet. Click either of the plot's four corners and drag in any direction to resize the plot, making it larger or smaller to fit into any collection of cells.

Read more ►

How to Use Excel to Calculate Beta Coefficient

1. Create a new spreadsheet in Microsoft Excel. Type the historical data for the stock in question and the benchmark in two separate columns.
2. Find the percent change of the data for the benchmark and the stock using the following formula:=((Cell2-Cell1)/Cell1)*100Cell 1 indicates the previous period data point, and cell 2 indicates a current period data point. Drag the formula with the mouse down the two columns.For example, if the stock's daily stock price was $100 per share in June 2010 and is $125 in June 2011, the $125 is cell 2 and the $100 is cell 1. Subtract 100 from 125 to get 25. Divide 25 by 100, which equals .25. Multiple this by cell 1 or 100. The percent change for this particular stock is 25 percent.Complete this formula for the SP 500 as well, which is the benchmark. When finished, you will have a percent of change for your stock and the SP 500.
3. Figure out the beta coefficient by using the 'SLOPE' function in Excel. The slope function is '=SLOPE(range of % change of equity, range of % change of index).' For example, if there were daily changes to Apple's stock price in cells A1:A260, and the daily changes to the SP 500 were in column B1:260, the function would be '=SLOPE(A1:A260,B1:B260).'

Read more ►

How to Add an Axis Title to an Excel Chart

1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart to which you would like to add an axis title.
2. Select the entire Excel chart by clicking in the white area of the chart. A light blue line will surround the entire chart indicating it has been selected.
3. Choose the 'Layout' tab at the top of the Excel screen and locate the 'Labels' group within the 'Layout' ribbon.
4. Click the 'Axis Titles' button in the 'Labels' section of the 'Layout' ribbon to display a drop-down list.
5. Point to 'Primary Horizontal Axis Title' to create a title for your 'X'-axis or point to 'Primary Vertical Axis Title' to create a title for your 'Y'-axis.
6. Click to choose where you want the selected title to be displayed in relation to the rest of the chart. The selections you see will depend on how your chart is formatted. A default title for the chart will appear the in the location you have chosen.
7. Add your own title by clicking on the default title and typing your new title with your keyboard. Press the 'Enter' key when you are finished typing the title.

Read more ►

How to Open .Xlsx Files in .Xls

1. Download the Microsoft Office Compatibility Pack to your computer.
2. Launch the older version of Excel.
3. Click the 'File' menu and select 'Open.' Use the 'Look in' menu to find the folder in which the XLSX file is saved. Highlight the XLSX file name and click 'Open.'

Read more ►

How to Create a Stacked Column Chart With the Data Plotted in Rows Using Excel

1. Open the Excel 2010 file that hold the data that you want to use in a chart.
2. Check the data to ensure that you have headers in the first column. If you don't, right-click on the letter above the first column and choose 'Insert.' Type in a header for each row into the column you just created.
3. Click on any cell that is part of your data field. Excel will automatically expand the selection to all adjacent cells when you create the chart. If you need to chart a specific area of your data, click on the top left cell of the area you want to chart, then hold 'Shift' and click on the bottom right cell.
4. Select the 'Insert' tab at the top of the screen. Locate the 'Charts' area, and click on the 'Column' button to bring up a pop-up menu that includes all of the column chart options. Select the 'Stacked Column' option to create your chart.
5. Right-click anywhere on the chart, and choose 'Select Data.' A small window appears on the screen. Click the 'Switch Row/Column' button in the middle of the screen, and then click 'OK.' Your graph changes to show each row of data as a stacked column.

Read more ►

How to Put a Command Button on a Spreadsheet in Excel

1. Open the spreadsheet in Excel that you want to add a command button to. Click the 'Office File' button on the main ribbon and click 'Excel Options.' Enable 'Show Developer tab in the ribbon' if it isn't already checked and click 'OK.'
2. Click the 'Developer' tab, then click 'Insert.' This brings up the list of controls that you can insert. Click the 'Button' link from the list of options.
3. Click in the spreadsheet where you want the command button to be placed.
4. Choose a macro from the list to assign to your command button, then click 'OK.'
5. Right-click the button and click 'Format Control' to format how the button looks.

Read more ►

How to Make Ledgers on Excel

1. Open a new Microsoft Excel spreadsheet. Type 'Opening Balance' into Cell A1. Type the opening balance into cell D1.
2. Type the name of the first credit or deduction into cell A2. Type the amount -- positive for additions, negative for deductions -- into cell C2. Type the formula =(A1 C2) into cell D2.
3. Input the names of amounts additional additions and credits as you become aware of them. Each time click cell D2 and drag the black border around it down into the 'D' column of the row where you notate the new transaction to display the new running balance in the 'D' cell of that row.

Read more ►