• 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, on occasion 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 make sure that the calculations are acting upon 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