How to Add a Column or several Cells automatically with Excel (example)

Who I am
Catherine Le Nevez
@catherinelenevez
EXTERNAL REFERENCES:

vgr.com gamedesigning.org Reddit.com

Author and references

In any modern business, I employees with knowledge of excel will be evaluated. More if the job is related to accounting or calculation of some element. By focusing on more training in the area of office automation, you will pass a great opportunity to be promoted in the workplace.

How to Automatically Add Columns or Cells with Excel?

Well, times are making all these techniques essential to improve the efficiency of office processes. Keeping all these things in mind, we will teach you how to automatically add a column or multiple cells in Excel.



don't just know excel. Check out all our guides on the Microsoft Office computer suite, to learn about and edit Excel, Word, PowerPoint files, which will help you improve your value and reflect positively on your resume.

Both Word and PowerPoint are other important tools to master. The good thing is that since they have similar interfaces, improving one of them enhances your skills with the others.

Note that for this guide you will need to have downloaded and installed Excel on your computer. The program is paid, we understand, but it represents an investment in your training. As you progress, your chances of getting better positions in the company you want will increase.

Always take it one step at a time, trying to work things out at your own pace so you don't get frustrated. The other factor to go on is that you need to have a basic understanding of Excel spreadsheets or spreadsheets.


Once you get to this stage, it means you meet all the requirements to learn how to automatically add columns or more cells. Try to follow the guide while working on your spreadsheet. This way you will understand things quickly and they will remain in your memory without having to re-read them too many times.


Read How to increase the WiFi signal of my mobile or mobile Android and iPhoneWhat

is Excel?

When we talk about Excel, we are referring to the spreadsheet, developed by Microsoft Corporation. It belongs to the Microsoft Office family of products, which we mentioned earlier. Excel is currently the dominant spreadsheet on the market and one of the essential office tools.

These spreadsheets allow automation of mathematical processes, using different formulas and functions in Excel cells.

How to automatically sum a column or several cells in Excel?

The truth is that adding is a very simple and basic process, so you should not have any problems if you follow the steps to the letter.

You will start by accessing a new Excel file to work with. Once there, you will need to enter all the data you want in the columns, creating a table like the one shown below.

Remember that we are working on a simple example. Your table can contain much more data and columns.


After you have entered all the values you want to add, you will click on the cell where you want the result of that addition to appear. It is time for you to learn how to use a function in Excel. This is done by typing after an equal sign, in the case of a sum we put: = SUM ()


The coordinates of the cells we want to add will be in parentheses. To position them quickly, simply slide the mouse over them. Another method is to type the coordinate of the first one, then two points and finally the coordinate of the last one (this will add those and all the ones in between). It would be something like: = SUM (I4: I8).


In case our intention is to add only some elements, we will have to select each cell individually, clicking on it while holding down the Ctrl key. Or enter the formula with the coordinates separated by commas: = SUM(I4, I5, I6)

Remember that you can customize the tables to your liking, to make them more pleasing to the eye. Use light colors and draw the borders.

add a comment of How to Add a Column or several Cells automatically with Excel (example)
Comment sent successfully! We will review it in the next few hours.