Microsoft Excel is a number processing program that allows you to organize and store data. One of its main functions is a mathematical formula that can divide, multiply, add and subtract numbers of your choice. Learn how to divide numbers in Microsoft Excel.
Step
Method 1 of 4: Entering Data in Microsoft Excel
Step 1. Open Excel on your computer
Step 2. Select the saved file, or create a new file
Step 3. Click the "File" menu at the top
Name and save the file on your computer. Be diligent in saving the file after you enter the data.
Step 4. Create a table
- Arrange the columns in your table. Columns are vertical sections that slide from top to bottom in Excel. Use the top horizontal row to name your columns. Column names can be headings, such as date, name, address, debit, credit, amount paid, or total.
- Arrange the rows in your table. Start entering data that matches the column names in the second horizontal row and so on.
- Decide whether you want to create a total in a column to the right of the data, or under a column in a row named "Totals". Some people prefer to display the calculation results a few lines below the numbers.
Method 2 of 4: Formatting Cells
Step 1. Select the area where you enter the numbers in Excel
Step 2. Click the "Format" menu at the top, then select "Format Cells
Step 3. Choose between "Number" or "Currency" on the list
Select the number of digits after the comma that you want.
This step allows you to apply formulas to the data, instead of treating the numbers as text
Method 3 of 4: Knowing Cell Names
Step 1. Understand cell arrangement in Excel
Understanding the naming of the cells that hold your data will help you write Excel formulas.
- Columns are at the top of the data, starting with "A," and continuing through the alphabet. After "Z", column names will use double letters.
- Rows are shown on the left, and are numbered sequentially.
Step 2. Select the cells in your data
Know the letter of the cell, then the number, for example "C2."
- Writing "C2" in a formula will prompt Excel to use the data in that cell.
- Selecting a group of cells in column B will prompt Excel to use the number of cells. For example "C2:C6". The colon indicates that the selected cell is a certain number of cells. You can also use this trick to select rows.
Method 4 of 4: Creating a Division Formula in Excel
Step 1. Click on the cell where the division result will appear, for example under the "Total" column or at the bottom of the row
Step 2. Find the formula bar on the Excel toolbar
This bar appears horizontally at the top of the data. The function box is an empty box next to the letter "fx."
Step 3. Type the equals symbol in the function box
You can also press the "fx" button to enter the equals sign automatically and select the calculation you want to perform
Step 4. Enter the cell you want to use as the numerator, for example "C2
Step 5. Add a leading slash or "/" symbol
Step 6. Enter the cell you want to use as a divider
Step 7. Press "Enter
"The result of the division will appear in the cell you selected."=C2/C6"
