In Excel, adding numbers is probably the most common calculations that you could do, it’s so common that they are whole bunch of different ways to do it.
Probably about a half dozens of different ways, lets start off with the basic manual way of adding numbers in Excel and then to the much easier and faster methods.
Let’s start off by adding across the row in the worksheet below:
Click on cell E6, type = sign to begin a formula or a function, select cell B6 type +. Select cell C6 type +, select cell D6, since that’s the last cell you want to add, just hit the Enter key.
What you should do next is to populate the total for the rest of the states from Lagos-Kano, using the auto fill hand, just double click on the auto fill handle or drag the auto fill handle down the column.
For me, I always double click on the auto fill handle, it’s super easy and fast, especially when you have large data to deal with.
You will be surprised by just dragging the auto fill handle down the column, Excel populates the corresponding rows automatically, that’s possible, all thanks to cell referencing.
Excel is literately adjusting based on the rows, following relative cell referencing.
Rather than looking at each cell in the total column for accuracy or looking at the formula bar to see if the formula is correct, wouldn’t it be nice to be able to see it all at once.
That’s absolutely possible, if you look at the upper left corner of your keyboard, to the left of number 1 and above the Tab key. There is a Tilde(~), if you press:
- Control (Ctrl)+Tilde (~): show formulas in cells
Excel, shows you all the formulas at once: it’s now very easy to eye ball, how those formulas were adjusted using cell referencing.
All the above technique can be use to add numbers manually across the row.
After adding the numbers and pressing the “Enter” key, all you have to do is, click and drag the auto fill handle to the right.
Double clicking the auto fill handle won’t work across the row, only down the columns.
Now that you have all these numbers added up, you will agree this is a kind of a slow manual way, right? So, I’m going to show some super-fast and easier ways to do it.
You can watch the video below for visual explanation. Thanks, sharing is caring.
Download Resource for practice