Chapter 3. STRUCTURING YOUR WORKBOOK

Cut, Copy, and Paste Cells

If you want to use the same data in multiple locations, you can copy and paste the data instead of retyping it. For example, you can copy a list of data in one worksheet to another worksheet, or you can copy a formula to multiple other cells. When you copy and perform a standard paste to a cell or range of cells, Excel duplicates everything in the original cell — including the cell values, formulas, formatting, comments, and data validation — and leaves the original cell unchanged.

If you want to move information from one location to another, you can cut the information, and then paste it. Cutting and pasting removes data from its current location and places it in a new location. For ...

Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with O’Reilly online learning.

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