• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part I: Everyday Worksheet Tasks > Moving or Copying Data and Formulas

Chapter 8. Moving or Copying Data and Formulas

  • Move data

    Move data and formulas using drag-and-drop or the Edit Cut and Edit Paste commands.

  • Fill and copy data

    Copy data and formulas, and create data series using the Fill and Copy commands or the fill handle.

  • Do special pastes

    You can paste nonadjacent copies, formats, the results of formulas and transposed data

  • Copy data across a workbook group

    Learn how to copy data from one worksheet or workbook to another worksheet or workbook.

Your worksheet wouldn't be easy to work with if re-arranging the data was impossible or if you had to enter every number or formula. With Excel, you can move data around, if necessary. You also can enter data or a formula once and then copy it to other rows and columns.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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