Microsoft Office Tutorials and References
In Depth Information
the contents of the cell or cells. For instance, Gregory Weber, the Northwest Distribution
Center Manager for Consolidated Messenger, might want to copy the cells that contain a
set of column labels to a new page that summarizes similar data.
Important If you select a group of cells, the first cell you click is designated as the active cell.
You’re not limited to selecting cells individually or as part of a range. For example, you
might need to move a column of price data one column to the right to make room
for a column of headings that indicate to which service category (ground, three-day
express, two-day express, overnight, or priority overnight) a set of numbers belongs.
To move an entire column (or entire columns) of data at a time, you click the column’s
header, located at the top of the worksheet. Clicking a column header highlights every
cell in that column and enables you to copy or cut the column and paste it elsewhere
in the workbook. Similarly, clicking a row’s header highlights every cell in that row,
enabling you to copy or cut the row and paste it elsewhere in the workbook.
When you copy a cell, cell range, row, or column, Excel copies the cells’ contents and
formatting. In previous versions of Excel, you would paste the cut or copied items and
then click the Paste Options button to select which aspects of the cut or copied cells to
paste into the target cells. The problem with using the Paste Options button was that
there was no way to tell what your pasted data would look like until you completed the
paste operation. If you didn’t like the way the pasted data looked, you had to click
the Paste Options button again and try another option.
With the new Paste Live Preview capability in Excel, you can see what your pasted data
will look like without forcing you to commit to the paste operation. To preview your
data using Paste Live Preview, cut or copy worksheet data and then, on the Home tab
of the ribbon, in the Clipboard group, click the Paste button’s arrow to display the Paste
gallery, and point to one of the icons. When you do, Excel displays a preview of how
your data will appear if you click that paste option.