- Editing Data
- Overwriting and Deleting Data
- Undoing and Redoing Changes
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Cutting, Copying, and Pasting Data
- Flipping Rows and Columns
- Moving Data
- Finding Data
- Replacing Data
- Adding and Viewing Cell Comments
- Editing and Deleting Cell Comments
- Inserting Symbols
- Tracking Changes
- Accepting or Rejecting Tracked Changes
- Checking Spelling
There might be times when you are entering data into your worksheet and notice that you typed the wrong information, so that you are off by one cell in a column or row. To avoid retyping all the data again, or copying and pasting, you can insert cells and shift the current cells to their correct locations.
Click the spot in your worksheet where you want to insert a cell.
Open the Insert menu and choose Cells to open the Insert dialog box.
Select what you want to happen to the existing cells when the new cell is inserted; for example, Shift cells down, and click OK.
The existing cells shift and a new cell is inserted.