How to Divide in Excel
Open the Microsoft Excel program on your computer., Select a saved spreadsheet or create a new spreadsheet. , Click the "File" menu at the top and save your spreadsheet under a name on your computer., Create a custom table., Highlight the areas of...
Step-by-Step Guide
-
Step 1: Open the Microsoft Excel program on your computer.
Regularly save your spreadsheet as you add data. , Set up your columns.
Columns are the vertical partitions that move from top to bottom in Excel.
Use the top row of horizontal cells to name your columns.
These may include titles like date, name, address, amount payable, amount receivable, amount paid or total.
Set up your rows.
Begin entering data that corresponds with your column headings in the second horizontal row and all the horizontal rows below it.
Decide if you want to create totals in a column to the right of your data or below a column in a row labeled "Total." Some people prefer for the final calculations to be listed a few rows below all of the entered numbers. ,, Select "Format Cells."
Decide how many decimal points you would like and click "Ok." This will allow you to use numerical formulas on the data, rather than treating numbers as though they are text entries. , Learning how to name the cells that contain your data will help you to write an Excel formula.
Columns are lettered at the top of your sheet.
They start at "A" and continue through the alphabet, using double letters after "Z." Rows run along the left side.
They are numbered in sequential order. , Identify the letter first and then the number.
For example, "C2." Writing "C2" in a formula will tell Excel to use the data in that specific cell.
Selecting an entire group of cells in the B column, will tell Excel to use a range of cells.
For example, "C2:
C6." The colon indicates it is a range of cells.
The same method can be used with rows. , This may be under the "Totals" column or at the end of a row. , This runs horizontally at the top of your sheet.
The function bar is a blank space next to the letters "fx."
You can also press the "fx" button.
This will automatically load an equals sign and ask what equation you would like to perform. , This is the number that will be divided.
For example, "C2."
, This is the number by which you will divide the first number. , The answer will appear in the cell you selected.
For example, your formula may look like this: "=C2/C6" -
Step 2: Select a saved spreadsheet or create a new spreadsheet.
-
Step 3: Click the "File" menu at the top and save your spreadsheet under a name on your computer.
-
Step 4: Create a custom table.
-
Step 5: Highlight the areas of the Excel sheet where you will enter numbers
-
Step 6: rather than words.
-
Step 7: Click the "Format" menu at the top.
-
Step 8: Choose either "Number" or "Currency" in the list.
-
Step 9: Notice how the cells are organized in your Excel sheet.
-
Step 10: Choose any cell inside your spreadsheet.
-
Step 11: Click on the cell where you would like the answer of your division equation to appear.
-
Step 12: Find the formula bar in the Excel tool bar.
-
Step 13: Type an equals sign into the bar.
-
Step 14: Enter the cell you would like to use as your numerator.
-
Step 15: Add a forward slash
-
Step 16: or "/" symbol.
-
Step 17: Enter the cell you would like to use as your denominator.
-
Step 18: Press "Enter."
Detailed Guide
Regularly save your spreadsheet as you add data. , Set up your columns.
Columns are the vertical partitions that move from top to bottom in Excel.
Use the top row of horizontal cells to name your columns.
These may include titles like date, name, address, amount payable, amount receivable, amount paid or total.
Set up your rows.
Begin entering data that corresponds with your column headings in the second horizontal row and all the horizontal rows below it.
Decide if you want to create totals in a column to the right of your data or below a column in a row labeled "Total." Some people prefer for the final calculations to be listed a few rows below all of the entered numbers. ,, Select "Format Cells."
Decide how many decimal points you would like and click "Ok." This will allow you to use numerical formulas on the data, rather than treating numbers as though they are text entries. , Learning how to name the cells that contain your data will help you to write an Excel formula.
Columns are lettered at the top of your sheet.
They start at "A" and continue through the alphabet, using double letters after "Z." Rows run along the left side.
They are numbered in sequential order. , Identify the letter first and then the number.
For example, "C2." Writing "C2" in a formula will tell Excel to use the data in that specific cell.
Selecting an entire group of cells in the B column, will tell Excel to use a range of cells.
For example, "C2:
C6." The colon indicates it is a range of cells.
The same method can be used with rows. , This may be under the "Totals" column or at the end of a row. , This runs horizontally at the top of your sheet.
The function bar is a blank space next to the letters "fx."
You can also press the "fx" button.
This will automatically load an equals sign and ask what equation you would like to perform. , This is the number that will be divided.
For example, "C2."
, This is the number by which you will divide the first number. , The answer will appear in the cell you selected.
For example, your formula may look like this: "=C2/C6"
About the Author
Edward Parker
A seasoned expert in arts and creative design, Edward Parker combines 5 years of experience with a passion for teaching. Edward's guides are known for their clarity and practical value.
Rate This Guide
How helpful was this guide? Click to rate: