Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
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.

start.jpg

circle_1.jpg Select the cell or cells that need to be shifted to insert new cells.

circle_2.jpg Right-click and choose the Insert option.

circle_3.jpg 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.

circle_4.jpg Click in your newly created cells and start adding data.

end.jpg
  • + Share This
  • 🔖 Save To Your Account