How to Drag Sum Formulas From Cell to Cell in Microsoft Excel 2003

1. Select the cell with the sum formula that you wish to drag. To select a cell that you wish to drag a sum formula from, you must first have a cell that contains a sum formula. You will need to left-click on the cell that you wish to drag the formula on, to highlight and activate that cell.
2. Activate the formula drag corner. To drag a formula you can easily do so by using the cursor to highlight the lower right corner of the cell, where a drag box will appear.
3. Drag the formula to the new cells. To drag the sum formula across the span of other cells, left-click on this drag box and hold as you drag the box to highlight new cells. When you let go of the mouse button, the formula will appear in all of the cells that you highlighted when you used the drag box.
4. Test the formula to assure that you implemented it properly. Make sure that you dragged the formula properly by double-checking the math to assure that the formula is functioning as desired.

Read more ►

How to Make Drop

1. Open Excel. Click on the Windows icon at the top of the the window and scroll down to 'Open.' Click on the command and browse through the folders on your computer to find your list. Click on it once to select it and click on 'Open.'
2. Click on a blank sheet in the workbook (use the tabs on the bottom to select a blank sheet). Type the entries you would like to see in your drop-down list in a column with no spaces in between the entries.
3. Highlight the list so it is all selected. Click in the name box (this is a text box next to the function bar) and give your list a name (for example, you can name it which column you will be using the list in).
4. Go back to your list and click in the first cell you want the drop-down list to occur. Click on the 'Data' menu at the top of the screen and click on 'Validation.' Click on the 'Settings' tab when the 'Validation' window opens.
5. Click on 'List' in the 'Allow' box. Type '=' and your list name in the 'Source' box. Click on the box next to 'In-Cell drop down.' Click on the 'Ignore Blank' box if the cell can be left blank. Once it is complete, click 'OK.'
6. Right-click the cell you have just created the list and click on 'Copy.' Highlight the entire column, right-click, and click 'Paste' to make every cell in that column into that drop-down list.

Read more ►

How to Recover a File After I Choose Not to Save the Changes

1. Avoid closing out the program after you have edited the document but want to return it back to normal. You may click 'Ctrl' and 'Z' or 'Apple' and 'Z' (when using a Mac computer) and the document moves back to a previous step. Continue pressing this until you remove all of the edits you want. You may also click 'Edit,' 'Undo' to perform the same actions.
2. Launch the software back up if you have already closed the document but did not save the changes. Click the 'File' tab and you may find all of the 'Recent' documents displayed. Choose the document you recently have been working on and the information appears since its last auto save (the computer automatically saves the document in progress, just in case you fail to before the program is closed or freezes).
3. Select 'File,' 'Open' if you never saved any changes to the document and want the original file open. A browse window appears on the computer screen. Select the file you wish to view, then choose 'Open' and the original document loads onto the computer screen, without all of the unsaved edits.

Read more ►

How to Find Data Source for Excel 2003

1. Open your file in Excel 2003. Click the 'Data' tab near the top of the Excel window.
2. Click the 'Connections' icon right below the 'Data' tab. Click the 'Properties' button on the right side of the 'Workbook Connections' form.
3. Click the 'Definition' tab on the 'Connection Properties' form. View the 'Command text' box at the bottom of the form to see the data source for the Excel file.

Read more ►

How to Open Xlsx in Excel 2003

1. Access the Microsoft Downloads website. Type 'Compatibility Tool' in the search box. Download the Compatibility Tool. Once it has downloaded to your computer, double click the execution file and follow the installation instructions. Click 'OK' once the installation is complete.
2. Open Excel 2003 and locate an Excel 2007 workbook. Click 'File' on the menu bar, then click 'Open.' Browse your files and locate the workbook. Click the workbook, then click 'Open.'
3. View the xlsx workbook in Excel 2003. You can work with this new format since the compatibility tool is installed.

Read more ►

How to Change the Language in Microsoft Excel

1. Click the Microsoft 'Office' button in Excel and click the 'Excel Options' button to open a dialog box.
2. Click the 'Popular' tab on the left side of the screen if it isn't already selected.
3. Click the 'Language Settings' button. A new window opens.
4. Click any language on the left side of the screen that you want to be able to work with. Click the 'Add' button to move that language to the box on the right, enabling it for use in Excel and your other Office products.
5. Click the down arrow in the Primary Editing Language section to change the default language for Excel and all of Office.
6. Click 'OK' to close the window and then click 'OK' again.

Read more ►

How to Add the Sum Function to an Excel 2003 Toolbar

1. Open Excel 2003 and select 'Tools' on the menu bar. Select 'Customize.' The Customize dialog box appears. Click the 'Toolbars' tab. Select 'New.' The New Toolbar dialog box appears. Type a name for your new toolbar and click 'OK.'
2. Review your new floating toolbar. Click the 'AutoSum' button on the standard toolbar to reveal a drop-down list of functions. Click 'SUM.'
3. Drag 'SUM' from the standard toolbar to your new floating toolbar. Click 'Close' to close the Customize dialog box.

Read more ►

How to Get a Running Total by Subtraction in Excel 2007

1. Enter the numbers you want to subtract from beginning total in a column on the left. For example, if you want to subtract 10, 14, 19 and 16 from 1000, you would place 10, 14, 19 and 16 in cells A2, A3, A4 and A5. Place the beginning total in a second column. For example, 1000 would go into cell B1.
2. Write the formula for the running subtraction, or balance. In cell B2, type '=SUM(B1-A2)'. This will subtract 10 from 1000 and put the result, 990, in cell B2.
3. Copy the formula to the lower cells to create a running total. Click on cell B2. Move the cursor to the bottom right corner, then click and drag the cell downward to drag the formula down the column. This will copy the formula to the lower cells so you won't have to rewrite the formula for each cell.

Read more ►

How to Do Percentages

1. Divide the number (N) by 100 to obtain a decimal, and then move the decimal point two places to the right to obtain your percentage (P).For example, if you have 100 items, what percent is N, where N=24?
N / 100 = P
24 / 100 = .24 or 24%
2. Convert a fraction or decimal to a percent by multiplying by 100.For example, 1 girl (N) out of 5 (T) receives an equal share of the money from a bake sale. Divide the given amount (N) by the total amount (T) and multiply by 100 for the percent (P).
N/T x 100 = P
1/5 x 100 = 20 or 20%
3. Convert a percentage to a fraction by dividing by 100 and then simplifying.20% = 20/100 = 1/5
4. Convert a percentage to a decimal by moving the decimal two places to the left.20% = 20.0 = .20
200% = 200.0 = 2.0
5. Convert to like measurements before calculating percent. When determining a percentage of differing measurements, you must first have all elements the same.For example, to determine the percent of 2 inches out of 12 feet, first convert the feet to inches.
12 inches = 1 foot
12 x 12 = 144 inches2 inches is what percent of 144?
2 = Percent x 144
2 ÷ 144 = .0138
Move the decimal point two places to the right of multiply by 100 for a percentage of 1.38%.

Read more ►

How to Create a Histogram in Excel

1. Type or import data into an Excel spreadsheet. Organize data into columns representing the 'Input Range,' representing data range on the y-axis, and the 'Bin Range,' representing frequency values on the x-axis.
2. Verify the 'Analysis ToolPak' option under Tools/Add-Ins has been checked or activated. If 'Data Analysis' option isn't available, please see the 'Tips' section for activating the Analysis ToolPak under the 'Add-Ins' menu.
3. Click on the 'Data Analysis' option under the 'Tools' menu.
4. Open the 'Histogram' option window.
5. Select 'Input Range' by dragging your mouse over the data you want to include in the analysis.
6. Choose 'Chart Output.'. Your chart will appear within the same Excel worksheet as your data.
7. Use 'Chart Options' and 'Format Data Series' menu to adjust the final appearance of the chart. You can use these options to adjust, size, position and labeling.

Read more ►

How to Make a Spreadsheet in Excel 2003

1. Launch Excel 2003 and open a blank document. Click the 'File' menu and select the 'New' option, which opens a task pane to the right of the screen. Click the 'Blank Workbook' link in the 'New' section.
2. Enter your desired data into the individual spreadsheet cells. You may input text or numbers into cells. Format your data, as necessary, by highlighting the appropriate cells and clicking the 'Format' menu. Select the 'Cells' option to open a separate window. Click one of the options in the 'Category' section of the 'Number' tab -- for example, 'Number' to format the data in the selected cells.
3. Use preformatted formulas to calculate data in the spreadsheet. Select a blank cell and click the 'Insert Function' button to the left of the 'Formula Bar,' which opens a separate dialog window. Select a function, such as 'SUM,' from the Insert Function menu and click the 'OK' button. Select the cells that you want to use your formula, according to the required information to complete the selected formula. Click the 'OK' button.
4. Save your spreadsheet. Click the 'File' menu and select the 'Save As' option; select a folder in the resulting dialog window in which to save the XLS file using the 'Look in' menu. Type a name for the file in the 'File name' field and click the 'Save' button.

Read more ►

How to Calculate Age From Date of Birth in Excel

1. Write the date of birth in cell A1. For example, write 2/9/1967.
2. Type the TODAY function in cell B1. The TODAY function is:
=TODAY()
This will always return the current date.
3. Type the following into cell C3:
=(B1-A1)/365.25.
The person's age in years will appear once you hit 'Enter.'

Read more ►

How to Import XLR Files

Microsoft Excel
1. Go to your 'Start' menu. Click 'All Programs,' 'Microsoft Officer Starter (English),' and then click 'Microsoft Excel 2010' to open Excel.
2. Click the 'File' menu and then click 'Open' to browse your hard drive for the XLR.
3. Browse your computer for the XLR you want to import and then click 'Open' to import the spreadsheet to Microsoft Excel.
OpenOffice Calc
4. Download and install the OpenOffice Suite from OpenOffice.org. Calc is the name of the spreadsheet software that is bundled with OpenOffice.
5. Click 'Start,' 'All Programs,' 'OpenOffice' and then click 'OpenOffice Calc' to run the spreadsheet program.
6. Click the 'File' menu and then click 'Open' to find the XLR you want to import into OpenOffice Calc.
7. Click 'Open' again to import the XLR file.

Read more ►

How to Calculate the Time Difference in Excel

Calculate Differences Between Hours
1. Open a new Microsoft Excel workbook.
2. Select the top cell in column 'A' and type 'Start Time,' and press 'Enter.'
3. Select the top cell in column 'B' and type 'End Time,' and press 'Enter.'
4. Select the top cell in column 'C' and type 'Time Difference,' and press 'Enter.'
5. Enter the start and end times in the appropriate columns by selecting the cell under the appropriate column and typing the time function, '=TIME(hour, minute, second)' and pressing 'Enter.' To enter times without using the TIME function, skip this step.
6. Format the cells for time by selecting the 'Home' tab on the top menu and clicking the arrow in the 'Font' section to open the 'Format Cells' window.
7. Click the 'Number' tab and select the 'Time' category. Select your preferred format in the 'Type:' box and click 'OK.' Enter times using proper syntax. Examples are '5 p' for 5:00 p.m., '5:42 p' for 5:42 p.m., or if you want to include seconds, '5:42:15 p' for 5:42:15 p.m. To display seconds, be sure to select a format that shows seconds.
8. Calculate the time difference by using the formula end time minus start time, using the 'TEXT' function for proper formatting (h=hour, m=minute and s=second). Select the cell under the appropriate column and type the combined text function and time formula, '=TEXT(B2-A2, 'h:mm:ss')' and press 'Enter.'
9. Select the cell containing the formula and hold down 'Ctrl' and 'C' to copy it. Paste the formula in column C next to all rows that contain start and end times to be calculated.
Calculate Differences Between Dates
10. Open a new Microsoft Excel workbook.
11. Select the top cell in column 'A' and type 'Start Date,' and press 'Enter.'
12. Select the top cell in column 'B' and type 'End Date,' and press 'Enter.'
13. Select the top cell in column 'C' and type 'Date Difference,' and press 'Enter.'
14. Enter the start and end dates in the appropriate columns by selecting the cell under the appropriate column and typing the date function, '=DATE(year, month, day)' and pressing 'Enter.' To enter times without using the DATE function, skip this step.
15. Format the cells for dates by selecting the 'Home' tab on the top menu and clicking the arrow in the 'Font' section to open the 'Format Cells' window.
16. Click the 'Number' tab and select the 'Date' category. Select your preferred format in the 'Type:' box and click 'OK.'
17. Enter dates using proper syntax. Click the cell and type '5-8' and press 'Enter' for dates in the current year. In the year 2010, Excel would read this date as May 8, 2010.
18. Include the year for dates not in the current year. Click the cell and type '5-8-9' or '5-8-09' and press 'Enter.' Excel would interpret this date as May 8, 2009.
19. Enter the full year for dates in other centuries. Type '5-8-1942' and press 'Enter.' Excel would interpret this date as May 8, 1942.
20. Calculate the date difference by using the formula end date minus start date. Type '=B2-A2' and press 'Enter.'
21. Calculate the date difference using workdays only by using the NETWORKDAYS function (=NETWORKDAYS(Start Date, End Date)). Type '=NETWORKDAYS(a2, b2)' and press 'Enter.'
22. Select the cell containing the formula and hold down 'Ctrl' and 'C' to copy it. Paste the formula in column C next to all rows that contain start and end dates to be calculated.

Read more ►

How to Create a Bar Graph From an Excel Spreadsheet

Creating a Chart
1. Start Microsoft Excel, and open the file you want to use to make a chart.
2. Drag the cursor over the columns you want to show in your chart.
3. Open the Insert menu, and select Chart. You can also select the chart icon on the toolbar.
4. Select the type of chart you want to make, such as a line graph or pie chart, from the list on the left.
5. Press Finish if you do not want to label or format your chart.
6. Press Next to label and format your chart.
Formatting Your Graph
7. In the box that appears after you clicked Next, click the Series tab.
8. Click on Series1, and enter a label for your data, such as 'Number of Widgets per Month,' in the Name field.
9. Click on any additional series, and name those as well.
10. Click Next.
11. Select the Titles tab to label your chart and both its x-axis and y-axis.
12. Select the Axes, Gridlines, or Legend tabs to format the look of your chart.
13. Select the Data Label tab to label specific points on your chart.
14. Select the Data Table tab to add a table of chart data under your chart.
15. Click Next.
16. Decide whether you want your chart on a new worksheet or on the same worksheet with your current Excel entries.
17. Click Finish.

Read more ►