WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to add cells in excel with formula

July 26, 2022
6.2K Views

How to add cells in excel? Excel is a versatile tool that you can use to perform many different types of tasks. If you have forgotten to add important information to your worksheet, you can quickly and easily add more cells.

Adding cells is inserting one or more cells between existing cells. If you want to know how to add cells in excel, you can continue reading.

How to add cells in excel basic form?

To learn how to add cells in excel 2016, you will need to write the basic form.

1. The first thing to do is start with an equals sign (=) followed by your cells separated by a plus sign (+).

2. You must press Enter to get your result.

This method can add a few cells to your Excel table. You can also use the SUM function to add more cells.

1. You will need to start with the equals sign; this is how Excel formulas start. Then you must write SUM (Your function will begin).

2. To continue, you must type the cells you want to add and divide them with commas, for example, =SUM(A2, A3, A4).

2a. If you want to add a chain of continuous cells to your Excel work, you can also separate them in the equation with a colon. You can use this step if the list of cells is long because you only need to enter the first and last cells.

2b. Another way to complete the formula is by clicking and dragging. When you type =SUM(, you can select the first cell you want to add and drag it to the last. In this method, Excel will do the rest of the process and separate with a colon. Besides, you will also be able to sum all the cells in a column just by annotating the cells as A: A in your formula. =SUM(A: A) will be displayed in the formula bar.

3. To finish and see the result, you must press Enter after deciding your cells.

These are some basic methods to learn how to add cells in excel mac.

How to add cells in excel using Shift Cells, Right?

If you want to know how to add cells in excel online consider you have a table with two columns, and now you should have 3 rows of data. You need to add a cell in cell B4 and move the data to the right; follow these steps.

1. Start by selecting the cell where you want to add a new cell.

2. Select the Insert option for the drop-down menu as shown in the image.

3. You need to select the Insert Cell option, and a pop-up menu will appear.

4. To continue with this method of how to add cells in excel 2019, you will need to select the Shift cells to the right option, then click OK.

As you can see in the picture, the number 3 shifts to the right and creates a new cell; this is what Shift cell right means.

Conclusion

Have you learned how to add cells in excel? As you can see, it is a simple process that will allow you to add new information to your spreadsheet. If you want to learn new Excel features, you can also follow WPS Academy.

It will let you download WPS Office to create and edit Excel, PowerPoint, and Word documents for free and enhance your working experience.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.