Excel Tips Tutorial: How to Insert Cells in Data Tables in MS ExceI
A spreadsheet in Microsoft Excel is a combination of cells in row-column matrix. Cells are divided in many columns or rows. While working with data tables in Excel, very frequently we need to insert new rows or columns according to the relevancy of data. Say, in below example, a cell is inserted at I5. When I5 cell is inserted and shifted down, all cells below I5 moved down as well. Similarly, when a cells is shifted right, all cells to the right of that cells are shifted right as well.
Letís learn how to insert cells in a table.
Step 1: Open Microsoft Excel and open the table you want to update by inserting cells.
Inserting single row: click on any row number to select the whole row. Now right click and select Insert. You will see that the whole row is shifted down to create a blank row at the same place. Now put information in the new row as per your need.
Step 3: Inserting multiple rows Drag your mouse over the row headers to select multiple rows. Then right click and select Insert. All the selected rows are shifted downward and blank rows are inserted.
Inserting columns: to insert single or multiple columns we will follow similar procedure as that in the case of rows. First select the specific columns and right click and Insert new blank columns.