Langsung ke isi 
Hello Kawan Mastah! If you are here, you must be looking for ways to add cells in Excel. Well, you are in the right place! In this journal article, we will guide you through the process of adding cells in Excel. It’s easier than you think! Let’s get started!
What are cells in Excel?
Before we dive into the process of adding cells in Excel, let’s first understand what cells are. Cells are the individual units in a spreadsheet where you enter data. Each cell is identified by a unique combination of a column and a row. For example, the cell at the intersection of column B and row 3 is referred to as B3. Now that we know what cells are, let’s move on to the process of adding cells.
Step 1: Select the cells to be added
The first step in adding cells in Excel is to select the cells that you want to add. To select a cell, simply click on the cell with your mouse. To select multiple cells, click and drag your mouse over the cells you want to select.
You can also select a range of cells by clicking on the first cell in the range and then holding down the Shift key on your keyboard while clicking on the last cell in the range.
Step 2: Click on the ‘AutoSum’ button
Once you have selected the cells that you want to add, the next step is to click on the ‘AutoSum’ button. The ‘AutoSum’ button is located on the ‘Home’ tab in the ‘Editing’ group. It is denoted by the symbol ‘Σ’. Click on the ‘AutoSum’ button to add up the values in the selected cells.
Step 3: Verify the result
Once you have clicked on the ‘AutoSum’ button, Excel will automatically add up the values in the selected cells and display the result in the cell below the selected cells. Verify that the result is correct and make any necessary adjustments.
Adding cells using formulas
Now that you know how to add cells using the ‘AutoSum’ button, let’s look at how to add cells using formulas. Formulas allow you to perform more complex calculations than the ‘AutoSum’ button.
Step 1: Enter the formula
To add cells using a formula, enter the formula in the cell where you want the result to be displayed. The formula for adding cells is ‘=SUM(cell1:cell2)’. Replace ‘cell1’ and ‘cell2’ with the actual cell references of the cells that you want to add.
Step 2: Press Enter
Once you have entered the formula, press the Enter key on your keyboard to calculate the result. Excel will add up the values in the selected cells and display the result in the cell where you entered the formula.
Step 3: Verify the result
As always, verify that the result is correct and make any necessary adjustments.
FAQ
| Question | Answer |
|---|---|
| What is the difference between the ‘AutoSum’ button and formulas? | The ‘AutoSum’ button is a quick and easy way to add up values in a range of cells. Formulas offer more flexibility and allow for more complex calculations. |
| What if I want to add cells that are not adjacent? | You can still use the ‘AutoSum’ button or formulas to add non-adjacent cells. To select non-adjacent cells, hold down the Ctrl key on your keyboard while clicking on the cells you want to select. |
| Can I add cells in Excel for Mac? | Yes, the process for adding cells in Excel for Mac is the same as in Excel for Windows. |
There you have it, Kawan Mastah! A simple guide to adding cells in Excel. We hope this article was helpful to you. If you have any further questions or need additional assistance, please feel free to reach out to us.