Copying

SS- flashing border

Clipboard

Like all the Microsoft Office applications you can cut (or copy) cells from one location to another.
The easiest way to cut, copy and paste values is to use the Office clipboard. This is just a temporary storage area.
All the Microsoft Office applications share the Office clipboard which makes it very easy to cut and paste between applications.
When you cut (or copy) data you are just placing it on the clipboard.
You can cut, copy and paste data between different worksheets and workbooks using the clipboard.
Every time you cut or copy an item a short representation of that item appears on the Office clipboard.
You can display the Office clipboard at any time by pressing (Ctrl + C) twice with the same cells selected.
The clipboard task pane allows you to cut or copy two or more different ranges and then paste them back possibly in a different order.

Clipboard Task Pane

Copying Values

Dragging the Fill Handle with a single cell highlighted will copy the value to all subsequent cells.
Using the Copy Cells option lets you copy the values from a range of cells.
This can also be done with a range of cells using the Copy Cells option.
Enter the values 15, 30 and 45 into cells "B2", "B3" and "B4" respectively. Drag the fill handle and select Copy Cells.

If you select a single cell containing a number and drag the fill handle the value will be copied into the adjacent cells.
This is the default when you use Auto Fill on a single cell containing a number.

If you select more than one cell and drag the fill handle then the default is for the series to be continued.
Alternatively you can enter the value in the first cell, highlight the whole range and press (Ctrl + D) to copy the value down.
You can also use the shortcut key (Ctrl + R) to copy a value across to the right.

To copy the contents of the active cell to all the other cells in a selected range, press F2 and then (Ctrl + Enter).

Copying Text

You can repeat text as well as numbers.
Select the cells "B2:B4" and drag the fill handle down using the left mouse button.
You will notice that a yellow tool tip should display the value that will be copied into the subsequent cell as you drag.

Copying Text (with Numbers)

Copying Empty Cells

You can also clear data within a selection by dragging the fill handle up or to the left within the selection
The data to be cleared appears with a grey dotted border as you drag the fill handle.

This can be used to remove formatted and as an alternative for removing data.
When you drag an empty cell over a cell that contains data you might be prompted asking you whether you want to overwrite the existing cells.
This option is controlled from (Tools > Options)(Edit tab, Alert before overwriting cells).

Auto Fill Floating Buttons

This was previously called the AutoFit Smart Tag.
Drag the fill handle with the right mouse button and displaying the Floating Buttons
more details

Copy As Picture

Camera Tool

This allows you to create a linked picture of a group of cells in your workbook.
Select Options > Customise
Change the "choose command from" to All Commands
Scroll down and add Camera to your Quick Access Toolbar.

Enter the values (5,10,15,20) into cells B2, B3, C2 and C3 respectively.
Select the range "B2:C3" and press Camera
Click on cell E3.
This has created a linked picture to your cell range.
Drag this picture to a different position.
Select cell "C2" and change the value to 30.
When you press Enter you will see that the picture is also updated.

Keep The Copy

Lets you copy cells and before you paste, you can perform other tasks.

You can even use the undo, and then paste if you accidentally paste it in the wrong cell.