Four Ways To Copy In Excel
An Excel tutorial by Peter Kalmstrom
most obvious way to copy cell content in Excel is probably
to use the copy and paste buttons.
In the demo below Peter Kalmstrom shows three other ways
that are often quicker and more convenient.
The four copy methods are:
The copy methods Peter shows are all good for text and numbers.
The text or numbers will be exactly the same when you paste
- Banner buttons
- Right click
- Ctrl+C and Ctrl+V
- Ctrl + drag and drop
However, if you copy a cell that contains a formula and
paste it in another cell, the formula will adapt to that
row and column. This is very useful, but you should
be aware of that Excel does this. Then you can take advantage
For more information about how that works, please refer
the Tips article about home costs calculations.
Peter uses Excel 2013 for his demo, but the four copy methods
will work for earlier versions of Excel too.