Home > Articles

Editing Worksheets

  • Print
  • + Share This
This chapter is from the book

Inserting Cells

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.

start.gif

1.gif Click the spot in your worksheet where you want to insert a cell.

2.gif Open the Insert menu and choose Cells to open the Insert dialog box.

3.gif Select what you want to happen to the existing cells when the new cell is inserted; for example, Shift cells down, and click OK.

4.gif The existing cells shift and a new cell is inserted.

end.gif

  • + Share This
  • 🔖 Save To Your Account