Microsoft Office Tutorials and References
In Depth Information
Moving data within a workbook
In this exercise, you’ll copy a set of data headers to another worksheet, move a column
of data within a worksheet, and use Paste Live Preview to control the appearance of
SET UP You need the 2013Q1ShipmentsByCategory workbook located in the
Chapter02 practice file folder to complete this exercise. Open the workbook, and
then follow the steps.
On the Count worksheet, select cells B2:D2 .
On the Home tab, in the Clipboard group, click the Copy button to copy the
contents of cells B2:D2 to the Clipboard.
KEYBOARD SHORTCUT Press Ctrl+C to copy worksheet contents to the Clipboard.
For a complete list of keyboard shortcuts, see “Keyboard shortcuts” at the end of
On the tab bar, click the Sales tab to display that worksheet.
Select cell B2 .
On the Home tab, in the Clipboard group, click the Paste button’s arrow, point to
the first icon in the Paste group, and then click the Keep Source Formatting icon
(the final icon in the first row of the Paste gallery). Notice that Excel displays how the
data would look if you pasted the copied values without formatting, and then pastes
the header values into cells B2:D2 , retaining the original cells’ formatting.
Right-click the column header of column I , and then click Cut , which causes Excel
to outline column I with a marquee.
Right-click the header of column E , and then, in the Paste Options area, click Paste
to paste the contents of column I into column E .
KEYBOARD SHORTCUT Press Ctrl+V to paste worksheet contents exactly as they
appear in the original cell.