Chapter 6. Rearranging Worksheet Data

Rearranging Worksheet Data

You can rearrange your worksheet data to improve the presentation of your worksheet information. This chapter shows you how to use Excel's many tools to make adjustments to the worksheet structure.

Move and Copy Data

You can use the Cut, Copy, and Paste commands to copy data within Excel, or move and share data between other Office programs. For example, you might cut a row of labels and paste them into another worksheet, or copy a formula from one cell to another cell in the same worksheet. You can also drag and drop data to move and copy it within a worksheet.

The Copy command makes a duplicate of the selected ...

Get Teach Yourself VISUALLY™: Excel® 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.