How to add cells in excel (Step-by-Step)
A free Office suite fully compatible with Microsoft Office
Do you want to know how to add cells in Excel WPS (2016/2019/mac/online)? This can easily be done in WPS using information provided in below sections. Many people get confused as to How to add cells in excel/spreadsheet in WPS (2016/2019/mac/online). Adding cells is one of the most common requirements that one can face while using excel WPS. While you are entering data and you want to add a row or a column in the spreadsheet, it can be done following the below mentioned simple steps.
Using WPS excel/spreadsheet is very simple and helpful only if you know the right steps and methods. This article is aimed at making you understand that How to add cells in WPS Excel/Spreadsheet. After reading the complete article you will be able to add cells ie rows or columns very easily in you WPS excel/spreadsheets (2016/2019/mac/online).
Three different ways on How to add cells in WPS Excel/Spreadsheet
1.1 How to add cell i.e.
rows or columns through row/columns labels:
1.Right click on any of the row label or column label. In above picture, we have right clicked on Column E Label.
2.A drop down menu will appear. You can see 02 different options here to add cells. i.e. Insert column left and Insert column right.
3.Right next to both these options, you can mention the number of columns to be added on either side and then clink on that option.
4.Columns shall be added accordingly.In the same way you can add rows in it as well, for that you need to right click on any of the row labels as shown in below picture and then the same procedure is to be repeated.
In this method only rows whole rows of cells or columns of cells can be added.
In method 3 singular cells can be added too.
1.2 How to add cell ie rows or columns through specific cells:
1.To add cells through specific cells, you need to right click on any specific cell besides which you require to add cells.
2.A drop down menu will appear. Hover down your mouse cursor to insert tab.Once your cursor is at Insert tab, a sub-menu pane will appear.
This method offers more advanced options to add cells.You can add new rows or columns.
1.3 How to add individual cells through specific cells too:
1.To add individual cells through specific cells, you need to right click on any specific cell besides which you require to add cells.A drop down menu will appear.
2. Hover down your mouse cursor to Insert tab.Once your cursor is at Insert tab, a sub-menu pane will appear.
3.You can add new rows or columns as well as you can add individual cells to the left or above side of the selected cells as well.In the latter way a singular cell is added and all remaning cells are moved accordingly. Following images show a new cell being added to the left of the selected cell.
In this way you can easily add cells in the WPS excel/spreadsheet.
This article has covered the simplest ways on How to add cells? in WPS Excel/Spreadsheet. You can use these simple steps as explained above and easily add cells in your WPS Excel/Spreadsheet whenever required.
Hopefully you have learnedHow to add cells in WPS Excel/Spreadsheet?.If you want to know more about Word features, you can follow WPS Academy to learn.
You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.
Was this helpful?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to copy file names in Excel from a folder?
- 4. How to import external data in WPS Spreadsheet
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Check if value is in list in Excel (3 easy methods)