How to Count Multiple Criteria in Excel 2003

1. Open your Excel spreadsheet.
2. Locate the formula bar at the top of the spreadsheet. It will have an 'fx' symbol on the left.
3. Type the following syntax in the formula bar (without the quotes):'=countif(range,criteria)'Replace 'range' with the range of cells that you want the Excel to include (e.g. 'A1:A20') and replace 'criteria' with the criteria you wish to use for the formula (e.g. '>20' where ALL values greater than 20 will be taken into account).
4. Press 'Ctrl Shift Enter' to enter the array.

Read more ►

How to Create a Worksheet Form in Excel 2003

1. Launch Microsoft Excel 2003. Start a new worksheet, or open the worksheet that you wish to add forms to.
2. Click 'Tools,' and select 'Customize.' The 'Customize' menu will appear.
3. Click the 'Toolbars' tab, and scroll down to 'Forms.' Place a checkmark next to 'Forms,' and click 'Close.' The 'Forms' toolbar will appear on your Excel spreadsheet.
4. Click on the type of form that you want to add to your Excel 2003 worksheet from the 'Forms' toolbar. You can add labels, group boxes, buttons, checkboxes, option buttons, list boxes, combo boxes, scroll bars and spinners.
5. Drag your cursor over the area in the worksheet where you want the form to appear, to create the form. You can edit and move the form after creation.
6. Right-click the form, and select 'Format Control.' The 'Format Control' dialog box will appear.
7. Edit the form using the options in the 'Format Control' dialog box. You can change the size, color, text and protection settings for the form.
8. Add macros to the forms by right-clicking the form and selecting 'Assign Macro.' The 'Assign Macro' dialog box will appear. Macros control the functions of the form.
9. Select a pre-created macro from the list of macros, and click 'OK' to use the macro or 'Edit' to open the Microsoft Visual Basic Editor so that you can write the code for the macro.

Read more ►

How to Select a Cell Without Deselecting

1. Add one cell at a time to previously selected cells, without deselecting any of these previously selected cells, by pressing and holding 'Ctrl' while you use the left mouse button to add new cells.
2. Add a range of cells to previously selected cells without deselecting any of these previously selected cells by pressing and holding 'Shift' while you drag the left mouse button to add a new range of cells.
3. Add more cells to an existing selection of cells by turning on the 'Add to Selection' feature by pressing 'Shift' 'F8,' and then using your mouse to select any nonadjacent cells.
4. Turn off this 'Add to Selection' feature by pressing 'Shift' 'F8' a second time, and Excel will revert to the default cell selection technique.

Read more ►

How to Use Excel 2003 With Map Coordinates

1. Start Excel and enter the following text into the following cells:'LatA' in cell A1'LonA' in cell C1'LatB' in cell A2'LonB' in cell C2These will be the labels that appear to the left of the cells in which you'll be entering the latitude and longitude pairs of your map coordinates.
2. Now you will name the contents of cells B1, D1, B2 and D2 with names corresponding to the labels you entered in Step 1. These names will be used in two complex formulas rather than direct cell references, to make them easier to understand. Name cell B1 as 'LatA' by clicking B1 and entering 'LatA' into the cell name drop-down, located to the left of the formula bar in Excel. Repeat this process for cell D1, naming the cell 'LonA,' for cell B2, naming it 'LatB' and cell D2, naming it 'LonB.'
3. Enter 'Bearing' into cell A3, and copy and paste the following formula into cell B3:=MOD(ATAN2(SIN(LonB-LonA)*COS(LatB),COS(LatA*SIN(LatB)-SIN(LatA)*COS(LonB-LonA))),6.30318)This formula returns the angle to the east of North between the coordinates in row 1 and the coordinates in row 2, in degrees. The last term, '6.30318,' is two times pi.
4. Enter 'Distance' in cell A4, and copy and paste the following formula into cell B4:=ACOS(COS(RADIANS(90-LatA)) *COS(RADIANS(90-LatB)) SIN(RADIANS(90-LatA)) *SIN(RADIANS(90-LatB)) *COS(RADIANS(LonA-LonB))) *3959This formula returns the distance between the coordinates in row 1 and the coordinates in row 2, in miles. The last term, '3949,' is the radius of the Earth, in miles. To convert the distance to kilometers, change the last term to '6371.'
5. Enter the latitude and longitude pair of your first map coordinate into cells B1 and D1 respectively. Enter the latitude and longitude pair of your second map coordinate into cells B2 and D2. The bearing between the two points will appear in cell B3, in degrees, and the distance between the two coordinate pairs will appear in cell B4.

Read more ►

How to Recover a Password for VBA Projects in Excel

1. Download and install Rixler's VBA Password Recovery Master. The software can unlock any length VBA password automatically. Point the software to the location of your password protected VBA file and the software will work to recover the password. When your password has been recovered, a single mouse click will copy the password to the Office Clipboard.
2. Order the Pro Edition of Dombajsoft's Remove VBA Password Program. The software instantly removes any VBA password, unlocking the file so you can get into your project. The software doesn't recover the password, but it does gain you access to your file. Once you have access you can add a new password of your choice. The software supports VBA projects up to and including Office 2010.
3. Purchase a copy of Softpedia's Remove VBA Password. Remove VBA Password instantly unlocks your VBA project in any Office application, including Excel, Word, PowerPoint, Publisher, Outlook, FrontPage and Project. Passwords of any length or character set can be removed in seconds, allowing you to gain access to your file.

Read more ►

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 ►