© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_11

11. Transferring and Duplicating Data to Other Locations

David Slager

(1)Fort Wayne, Indiana, USA

There are times when you place data into cells and then later decide that you would rather display that data in a different location, or maybe you want that data duplicated elsewhere. Excel provides a variety of methods for doing this as well as allowing for you to select the format of the newly transferred or duplicated data. This transferred or duplicated data can be copied to locations within other data, in other worksheets and in other workbooks.

After reading and working through this chapter you should be able to

  • Move and copy cells using the drag-and-drop method ...

Get Essential Excel 2016: A Step-by-Step Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.