How to Divide Cells in Excel

Divide the Numbers in a Cell
1. Click on a cell to enter your data.
2. Type an equal sign (=).
3. Type your first number. For this example, we will divide 15 by 5.
4. Press the forward slash key on your keyboard (/). This is the division sign in Excel.
5. Type in your next number, 5.
6. Press the 'Enter' key on your keyboard or click on the check mark on the tool bar. This displays the result of the calculation.
Divide Numbers in a Range of Cells
7. Type the number 15 into cell A1.
8. Type the number 5 into cell A2.
9. Click cell A3 and type an equal sign (=).
10. Click on cell A1. 'A1' should appear after the equal sign in A3.
11. Press the forward slash (/) key on your keyboard.
12. Click on cell A2. 'A2' should appear after the forward slash. Your formula should look like this: = A1/A2.
13. Press the 'Enter' key on your keyboard or click on the check mark button on the tool bar to perform the calculation. The answer 3 should appear in cell A3.
Divide Numbers Using the Quotient Function
14. Use the quotient function. You can divide numbers with the quotient function: QUOTIENT (Numerator, Denominator). The only difference between using this function and using regular division is that, if there are any remainders, the answer from the quotient function will not display it.
15. Type the number 15 into cell A1. This is your numerator.
16. Type the number 2 into cell A2. This is your denominator.
17. Click on A3, where the result will be displayed.
18. Click on the 'Paste function' button (fx) on the tool bar to open the list of functions. Select 'Quotient.' The quotient dialog box should appear.
19. Click on the 'Numerator' line. Click on cell A1.
20. Click on the 'Denominator' line in the dialog box. Click on cell A2.
21. Click on 'OK' to close the Quotient dialog box. The number 7 appears as the answer in cell A3. Notice that the answer does not include any remainders.

Read more ►

How to Calculate a Percentile Using Excel

1. Enter your dataset in a continuous column in Excel. For this example, assume that the data is entered in cells A1 to A100.
2. Determine what percentile you want to calculate, and convert it to a number between zero and one. For example, the 20th percentile is 0.2, the 55th percentile is 0.55, the 100th percentile is 1, and so on. This example will use the 40th percentile (0.4).
3. Enter the following formula in the cell where you want the percentile result to show:=PERCENTILE(A1:A100,0.4).This tells Excel to calculate the 40th percentile of the data in cells A1 to A100.

Read more ►

How to Add a Shadow to a Chart in Excel

1. Start Microsoft Excel and open an existing workbook from your files that contains a chart to which you would like to add a shadow.
2. Select the chart you would like to add a shadow to by clicking on it with your mouse. The chart will be surrounded by a light blue outline when it is selected.
3. Choose the 'Format' tab at the top of the Excel screen to show the formatting options that you can apply to your selected chart. Locate the 'Shape Styles' section of the 'Format' ribbon.
4. Click the small half box and arrow button that lies on the 'Shape Styles' title bar on the lower right corner. This will open the 'Format Chart Area' dialog box.
5. Select 'Shadow' from the left side of the 'Format Chart Area' dialog box to display the shadow settings you can add to the selected chart.
6. Use the 'Preset' drop-down menu to choose a preset shadow from Excel. You can change the color of the shadow by selecting a new color from the 'Color' drop-down menu. The settings for the shadow can be changed using the 'Transparency,' 'Size,' 'Blur,' 'Angle' and 'Distance' sliders.
7. Click the 'Close' button to close the 'Format Chart Area' dialog box and return to your chart, which is now highlighted with a shadow.

Read more ►

How to Make a Pictograph on Excel

1. Launch Excel 2010 and open a spreadsheet containing data that can be expressed in a graph. Highlight the cells that you want Excel to include in the graph.
2. Select the 'Insert' tab at the top of the window. Click 'Column' or 'Bar' in the 'Charts' section of the toolbar to generate a graph from the selected data.
3. Double-click one of the graph's bars. This opens a Format Data Point window.
4. Select the 'Fill' heading on the left side of the Format Data Point window.
5. Click to select the 'Picture or Texture Fill' radio button.
6. Click the 'File' button under 'Insert from' and double-click the image you want to use for the selected bar.
7. Click the 'Stack' radio button to display several stacked copies of the selected image in place of the bar, or click the 'Stretch' radio button to display a single image stretched to fill the bar.
8. Click 'OK' and repeat Steps 3 through 7 for the remaining bars of the graph.

Read more ►

How to Set Printing Options in Excel

1. Start Microsoft Excel and open a spreadsheet that you would like to print.
2. Choose the 'File' button and click 'Print' to bring up the 'Print' dialog box.
3. Change the printer you are using by clicking the 'Name' list under the 'Printer' section of the 'Print' dialog box. You can view the printers you have installed and click on which printer you would like to use to print your spreadsheet.
4. Check the 'Print to file' check box in the 'Printer' section of the 'Print' dialog box to print the spreadsheet to another computer file instead of from a printer.
5. Set the print range of your spreadsheet by selecting the 'All' radio button to print all of the pages or 'Page(s)' radio button to print only a certain page or multiple pages in your spreadsheet. If you choose the 'Page(s)' option you will need to use your keyboard to specify which pages you would like to print.
6. Select what you would like to print by choosing either 'Selection,' 'Active sheet(s),' 'Entire workbook' or 'List' under the 'Print what' section of the 'Print' dialog box.
7. Set the number of copies that you want to print by using your keyboard to type in the number beside 'Number of copies' under the 'Copies' section of the dialog box. You can also choose to collate the spreadsheet by putting a checkmark in the 'Collate' check box in this same section.

Read more ►

How to Use Excel 2003 Formulas Functions for Budgets

1. Decide which formula you want to use. For example, you may want to add a column of data or multiply certain budgetary numbers by 12 to convert from a monthly to yearly budget.
2. Locate the formula you need in the 'Microsoft: Excel Commonly Used Formulas' (see Resources). For example, click on 'Add Numbers' in the Math subsection. One of the functions you can use is the 'Sum' function, which adds numbers in a single cell or multiple cells.
3. Enter the formula into the cell where you would like the answer to appear. For example, you may want to add a list of budget items in cells B2 to B10 and display the result in cell B11. All formulas begin with an equals sign ('='), so type the following text into cell B11:=SUM(B2:B10)The colon means 'to' as in 'Cells B2 to B10 inclusive.'
4. Use a function instead of a formula to perform calculations. For example, you can use the autosum function in Excel instead of specifying a formula. To use the autosum function, click on the cell where you would like the total to appear (in the above example, that was cell B10). Then click the autosum symbol on the standard toolbar. The autosum symbol is an uppercase sigma. Click on the cells you would like to sum (for example, B2 through B10). The autosum function will place your result in cell B10.

Read more ►

How to Scroll With a Mouse Wheel in Excel 2007

1. Open Microsoft Excel 2007 and launch the document you need to view.
2. Click inside the document somewhere (or on the scrollbar at the side of the page). This tells the mouse you are working inside the loaded Excel document.
3. Drag your finger from top to bottom over the scroll wheel on the mouse. This moves the page down and you can see the scrollbar on the side of the screen move with your movements.
4. Drag your finger from the bottom of the scroll wheel to the top. Doing so scrolls the page back up toward the top of the document.

Read more ►

How to Make Vertical Words in Excel

1. Open your spreadsheet in Microsoft Excel.
2. Click the cell containing the text you wish to make vertical.
3. Click the 'ab' symbol in the Alignment group of the Home tab and select 'Vertical Text' to align letters on top of one another. Alternatively, select 'Formal Cell Alignment,' enter '-90' or '90' in the 'Degrees' field, and click 'OK' to rotate normal text 90 degrees. Selecting '-90' will align the bottom of the characters to the left, while selecting '90' will align them to the right.

Read more ►

How to Use Excel 2007 to Make a Climate Graph With Negative Temperatures

1. Open the Worksheet.
2. Enter a date or time in each cell along one column or one row. For example, the dates April 1, April 2 and April 3 can fill cells B4, B5 and B6, respectively.
3. Enter the temperature values, one value per cell, in this temperature column. The values can be positive or negative. Enter these values in cells adjacent to the categories in Step 2. For example, enter '7' '-2'and '4' in cells C4, C5 and C6, respectively.
4. Click the cells that contain the dates and temperature values.
5. Click on the 'Insert' tab on the Ribbon. The 'Charts' group includes the 'Line' chart button.
6. Click on the 'Line' button to display the different line charts available. The '2-D' line chart displays values over time and different categories, such as dates.
7. Click on the 2-D chart button to convert the data. The chart displays both positive and negative temperature values. Try the other line chart styles to see the effect.
8. Edit the chart for a custom look. For example, the 'Design' tab includes 'Chart Layouts' and 'Chart Styles' groups. The 'Format' tab includes the 'Shape Styles' group that changes the color of the outline and background.
9. Save this worksheet.

Read more ►

How to Remove Password Protection in Excel

1. Open Excel and open the workbook for which you wish to remove the password protection. At this point, if you are using Excel 2003 or an earlier version, proceed to Step 2. If you are using Excel 2007, skip straight to Step 5.
2. Click on the 'File' menu, and then select 'Save As.' Click on the 'Tools' menu and select 'General Options.'
3. Double-click on the asterisk that is in the 'Password to open' box, and then press 'DELETE' on your keyboard. DO the same for the box labeled 'Password to modify.'
4. Click on 'OK,' then 'Save,' and finally 'Yes' to complete the password protection removal if your are using Excel 2003 or earlier.
5. Click on the 'Review' tab at the top of the Excel 2007 window, and locate the group of icons within the 'Changes' group. Click on 'Unprotect Sheet.' Type in the appropriate password when and if you are prompted, and you are finished.

Read more ►

How to Get Data From Excel Into Word

1. Click Excel's Office button, then click the 'Open' command. Navigate to and double-click a file you'd like to open to Word. Click the 'Save as' command after the file loads, then click the 'Excel 97-2003' format from the 'type' dropdown list. This format lets Word read the Excel data. Click the Office button's 'Close' command to close the workbook.
2. Click Word's Office button, then click the 'Open' command. Click the 'Excel' type from the 'Type' dropdown list, then navigate to the folder in which you saved the Excel workbook in the previous step.
3. Double-click the workbook to begin loading it. Word will display a warning message indicating the possible presence of malicious content. Click 'Yes' to continue opening the workbook.
4. Click the 'Entire' option from the dropdown control labeled 'Open document,' if you want to load the entire Excel workbook into Word. Otherwise, click one of the sheets listed in the dropdown to select just that sheet for importing to Word. For example, if your Excel data is only on 'Sheet1,' click that sheet in the 'Open document' dropdown.
5. Click the 'Name range' dropdown list if you chose to import only a particular spreadsheet in the previous step. Skip this step if you're importing the entire workbook. Otherwise, click a named range of cells in the workbook to import just that named range. For example, if the workbook contains a blocked of cells named 'ArtPatrons,' you can click that name in the 'Name range' dropdown to import just that block of cells.
6. Click 'OK' to import the Excel data into Word. Word will format the imported data as a table in a new Word document.

Read more ►

How to Change the Toolbar in Excel 2007

1. Locate the Quick Access Toolbar in Excel 2007. It will be either next to the Office button or under the ribbon.
2. Right-click on the Quick Access Toolbar and select 'Customize Quick Access Toolbar.' Check or uncheck the 'Show Quick Access Toolbar Below the Ribbon' box to place the toolbar where you want it.
3. In the ribbon, navigate to the feature you want to add to the Quick Access Toolbar.
4. Right-click on the feature you wish to add, and a menu will appear.
5. Select the 'Add to Quick Access Toolbar' option. The feature should now be on the toolbar.

Read more ►

How to Make a Time Line in Microsoft Excel

1. Gather all the information you need for the time line.
2. Open Microsoft Excel. Click on the Excel desktop icon or find Excel in the Start Menu under 'All Programs.'
3. Click the 'File' tab and pick 'New' to start a new spreadsheet.
4. Add a title to your time line. Click 'Insert' and then choose 'Header and Footer.' Type the title in the header section. Format the title to suit your needs and click 'OK.'
5. Move a few rows down the spreadsheet and input the first date. You can format the cells all at once or individually. If you are including times in your chart you may want to format the cells separately.
6. Format the descriptions so they appear vertically instead of horizontally in your time line. Highlight the cell or groups of cells you want to change. Click the 'Format' tab. Choose 'Cells.' When the format window opens pick 'Alignment.' Change the number in the 'Degrees' box. The diagram on the side displays the look of the angle you chose.
7. Create borders around the cells or the entire time line. Highlight the cells. Select 'Format' from the menu bar. Now pick 'Borders' and choose the type of border to use from the list provided.
8. Add a background color to specific cells. Select the cells you want to add color to. Choose 'Fill Color' or select the paint brush from the draw tool bar at the bottom of the screen. Pick a color and click 'OK.'
9. Insert pictures into the time line. Choose 'Insert' from the menu bar and then click on 'Picture.' Choose a file from your computer or a clip art from Excel's clip art gallery.
10. Save the time line. Select 'File' from the menu bar and then click 'Save' from the drop-down menu.
11. Print your time line. Click 'File' on the menu bar. Pick 'Print' from the drop-down menu and click 'OK.'

Read more ►

How to Manipulate Data in an Excel 2007 Pivot Table

1. Open Excel 2007 and select a workbook containing data. Click the 'Office' button and select 'Open.' Browse your files and select the workbook. Click the 'Open' button to open the workbook.
2. Highlight the data you want included in the PivotTable. Select 'Insert' on the menu bar, and then select 'PivotTable.' A drop-down menu appears. Select 'PivotTable' again. Click 'OK.'
3. Add fields to the PivotTable by checking fields from the right 'PivotTable Field List.' By default, the fields appear in the column section. Manually drag the fields to any of these sections (row, totals or filter) to see how manipulating them changes your pivot table.

Read more ►

How to Convert Excel Time Difference to Decimal Number

1. Click a cell where you want the decimal representation of the time difference to appear.
2. Type '= A1 * 24' and then press 'Enter.'
3. Change the cell location 'A1' to the actual location where your time difference appears. For example, if the time difference is 1:15 and appears in cell C3, type 'C3' into the formula instead of 'A1.' Pressing 'Enter' for this result will give you the decimal result '1.25.'

Read more ►