Originally posted by: kam300
Date: June 11, 2008 at 01:32 AM
Source: https://forum.mmajunkie.com/threads/attn-computer-saavy-jfc-fighters.2358/
I don't have a clue but I know how to get the info let me know if this helps you at all.
Move or copy entire cells
When you move or copy a cell, Excel moves or copies the entire cell, including formulas and their resulting values, comments, and cell formats.
Select the cells that you want to move or copy.
How to select cells
To select Do this
A single cell Click the cell, or press the arrow keys to move to the cell.
A range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells Click the first cell of the range, and then drag to the last cell.
A large range of cells Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.
All cells on a worksheet Click the Select All button.
Nonadjacent cells or cell ranges Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
More or fewer cells than the active selection Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell (active cell: The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.) and the cell that you click becomes the new selection.
Note To cancel a selection of cells, click any cell on the worksheet.
Do one of the following:
To move cells, click Cut on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), or press CTRL+X.
To copy cells, click Copy on the Standard toolbar, or press CTRL+C.
Select the upper-left cell of the paste area (paste area: The target destination for data that's been cut or copied by using the Office Clipboard.).
Tip To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.
Click Paste on the Standard toolbar, or press CTRL+V.
Notes
To choose specific options when you paste cells, you can click the arrow next to Paste on the Standard toolbar, and then click the option that you want.
By default, Excel displays the Paste Options button on the worksheet to provide you with special options when you paste cells, such as Keep Source Formatting and Match Destination Formatting. If you don't want to display this button every time you paste cells, you can turn this option off. On the Tools menu, click Options. On the Edit tab, clear the Show Paste Options buttons check box.
Excel replaces existing data in the paste area when you move cells.
When you copy cells, cell references are automatically adjusted. When you move cells, however, cell references are not adjusted, and the contents of those cells and of any cells that point to them may be displayed as reference errors. In this case, you'll need to adjust the references manually.
If the selected copy area (copy area: The cells that you copy when you want to paste data into another location. After you copy cells, a moving border appears around them to indicate that they've been copied.) includes hidden cells, Excel also copies the hidden cells. You may need to temporarily unhide cells that you don't want to include when you copy information.
If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of the copied cells.
<Back to top>
Move or copy entire cells by using the mouse
By default, drag-and-drop editing is turned on so that you can use the mouse to move and copy cells.
Select the cells or range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells that you want to move or copy.
How to select cells
To select Do this
A single cell Click the cell, or press the arrow keys to move to the cell.
A range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells Click the first cell of the range, and then drag to the last cell.
A large range of cells Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.
All cells on a worksheet Click the Select All button.
Nonadjacent cells or cell ranges Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
More or fewer cells than the active selection Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell (active cell: The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.) and the cell that you click becomes the new selection.
Do one of the following:
To move a cell or range of cells, point to the border of the selection. When the pointer becomes a move pointer , drag the cell or range of cells to another location.
To copy a cell or range of cells, hold down CTRL while you point to the border of the selection. When the pointer becomes a copy pointer , drag the cell or range of cells to another location.
Notes
Excel replaces existing data in the paste area (paste area: The target destination for data that's been cut or copied by using the Office Clipboard.) when you move cells.
When you copy cells, cell references are automatically adjusted. When you move cells, however, cell references are not adjusted, and the contents of those cells and of any cells that point to them may be displayed as reference errors. In this case, you'll need to adjust the references manually.
If the selected copy area (copy area: The cells that you copy when you want to paste data into another location. After you copy cells, a moving border appears around them to indicate that they've been copied.) includes hidden cells, Excel also copies the hidden cells. You may need to temporarily unhide cells that you don't want to include when you copy information.
If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of the copied cells.
<Back to top>
Insert moved or copied cells between existing cells
Select the cell or range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells that contains the data that you want to move or copy.
Do one of the following:
To move the selection, click Cut on the Standard toolbar, or press CTRL+X.
To copy the selection, click Copy on the Standard toolbar, or press CTRL+C.
Select the upper-left cell of the paste area (paste area: The target destination for data that's been cut or copied by using the Office Clipboard.).
Tip To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.
On the Insert menu, click Cut Cells or Copied Cells.
In the Insert Paste dialog box, click the direction in which you want to shift the surrounding cells.
Note If you insert entire rows or columns, the surrounding rows and columns are shifted down and to the left.
<Back to top>
Copy visible cells only
If some cells, rows, or columns on your worksheet are not displayed, you have the option of copying all cells or only the visible cells. For example, you can choose to copy only the displayed summary data on an outlined (outline: Worksheet data in which rows or columns of detail data are grouped so that you can create summary reports. The outline can summarize either an entire worksheet or a selected portion of it.) worksheet.
Select the cells that you want to copy.
On the Edit menu, click Go To.
In the Go To dialog box, click Special.
In the Go To Special dialog box, click Visible cells only, and then click OK.
Click Copy on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), or press CTRL+C.
Select the upper-left cell of the paste area (paste area: The target destination for data that's been cut or copied by using the Office Clipboard.).
Tip To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.
Click Paste on the Standard toolbar, or press CTRL+V.
Notes
Excel pastes the copied data into consecutive rows or columns. If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of the copied cells.
If you click the arrow next to Paste on the Standard toolbar, you can choose from several paste options to apply to your selection.
When you copy or paste hidden or filtered (filter: To display only the rows in a list that satisfy the conditions you specify. You use the AutoFilter command to display rows that match one or more specific values, calculated values, or conditions.) data to another application or another instance of Excel, only visible cells are copied.
<Back to top>
Prevent copied blank cells from replacing data
Select the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells that contains blank cells.
Click Copy on the Standard toolbar, or press CTRL+C.
Select the upper-left cell of the paste area (paste area: The target
[... truncated — view original at source URL above ...]
