How to add cells to an Excel Worksheet
By
SpreadCheaters
Adding a cell in excel is easy. There can be four options.
- Adding a cell by shifting cells right
- Adding a cell by shifting cells down
So here we have a worksheet with different cells marked according to rows and columns.
While working on a worksheet in Excel you might need to add some new information and for that you might need to add an individual cell or even an entire column or a row.
Step 1 – Adding a cell by shifting cells right
– Depending on your requirement you may want to add a cell by shifting one cell to the right.
– So right click the cell where you want the new cell to be added.
– Click insert. On the insert dialog choose the option shift cells right and click OK.
– A new cell will be added by shifting the original cell to the right.
Step 2 – Adding a cell by shifting cells down
– You can also add a cell by shifting one cell to down.
– To do this right click on the cell where you want to add the cell and click insert.
– On the insert dialog choose the option shift cells down and click OK.
– You have now added a cell by shifting a cell down.
