When you move or copy a cell, Excel moves or copies the entire cell, including formulas and their resulting values, cell formats, and comments.

#1)
Copying and pasting cells using the context menu (right mouse click) shortcut:

First:

Select the cells you want to copy. In this example, the range of B4:E4.

Then:

Right mouse click.

Then:

Select Copy from the menu.

Then:

Your selected cells are highlighted with an animated dashed border.

Now to paste:

Note:
There are many special ways to paste cells beyond the default pasting action. We will cover Paste Special in greater detail in the future.

The result:

The copy selection has been pasted in the range B15:E15
#2)
Copying and pasting cells using keyboard shortcuts:

First:

Select the cells you want to copy. In this example, the range of B4:E4.

Then:

Press and hold the Crtl key and press the C key (Ctrl + C). Your selected cells are highlighted with an animated dashed border.

See also Keyboard Shortcuts

Now to paste:

Select the cell where you want to paste to, in this example cell B15, and then press and hold the Crtl key and press the V key (Ctrl + V).

Note:

There are many special ways to paste cells beyond the default pasting action. We will cover Paste Special in greater detail in the future.

See also Keyboard Shortcuts

The result:

The copy selection has been pasted in the range B15:E15
#3)
Copying and pasting cells using the Ribbon:

First:

Select the cells you want to copy. In this example, the range of B4:E4.

Then:

Click the Copy button on the Home tab of the ribbon.

See also Keyboard Shortcuts

Now to paste:

Select the cell where you want to paste to, in this example cell B15, and then Click the Paste button on the Home tab of the ribbon.

Note:

There are many special ways to paste cells beyond the default pasting action. We will cover Paste Special in greater detail in the future.

The result:

The copy selection has been pasted in the range B15:E15

Summary

In a worksheet, you can select cells, ranges, rows, or columns. This is an important skill which allows you to, for example, apply the same formatting change to all of the selected cells. You can also select all or part of the cell contents and turn on Editing mode to modify the data within a cell.