- 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
This chapter is from the book
This chapter is from the book
This chapter is from the book
Inserting Cells
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.
Caution: Watch for Misaligned Data When Inserting Cells
Be aware that when you insert a cell, the cells below or to the right of that cell shift (one row down or one column to the right). Be careful that when this happens, your data table does not become misaligned. If it does, you may want to use the Insert Rows or Insert Columns options (explained later in this chapter).