- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
There might be times when you need to insert new cells into the middle of your dataset. For example, if you have a table that shows data by region, you might need to insert blank cells to accommodate a new region. To avoid retyping all the data again or copying and pasting, you can insert cells and shift the current cells to their correct locations.
Select the cell or cells that need to be shifted to insert new cells.
Right-click and choose the Insert option.
In the Insert dialog box, choose whether you want to shift existing cells right or down to make room for the new cells. Then press the OK button.
Click in your newly created cells and start adding data.