Microsoft Office Tutorials and References
In Depth Information
Moving data within a workbook
Moving data within a workbook
You can move to a specific cell in lots of ways, but the most direct method is to click the
desired cell. The cell you click will be outlined in black, and its contents, if any, will appear
in the formula bar. When a cell is outlined, it is the active cell, meaning that you can modify
its contents. You use a similar method to select multiple cells (referred to as a cell range )—
just click the first cell in the range, and drag the mouse pointer over the remaining cells
you want to select. After you select the cell or cells you want to work with, you can cut,
copy, delete, or change the format of 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 versions prior to Excel 2010, 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 Paste Live Preview capability in Excel, you can view what your pasted data will
look like before committing to the paste operation. To preview your data by 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 a menu containing the Paste
Search JabSto ::




Custom Search