• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Inserting Cells

Although inserting rows and columns makes it easy to dramatically change the layout of a worksheet, occasionally you might need to insert only a cell, or cells, into a worksheet. Inserting cells causes the data in existing cells to shift down a row or over a column to create a space for the new cells.

Caution

Watch Your Formulas and Functions Inserting cells into a worksheet can throw off the cell references in formulas and functions. Double-check your formulas and functions after inserting cells to be sure the calculations are acting on the appropriate cell addresses.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint