Select the cell you want to copy and click on the following icon.
Instantly, the data and the format (color, font, borders) contents of the first cell is transferred into the second cell
But, height and width of the source cell are not copied. The technique to reproduce the size of a cell will be seen in the section Adjusting rows and columns.
|Copy contents of the selection.||+|
|Paste contents of the clipboard.||+|
Another technique to perform copy / paste buttons are below and above but you must first select a range of cells.
|In a selected range of cells, copy contents of the first line to the rest of the selection|
|In a selected range of cells, copy contents of the first column to the rest of the selection||+|
Copy a formula
There is a special feature when you copy-paste a formula; cells’ references may be changed.
So obviously, it is very convenient that references change when we want to reproduce the calculation of other data but when we want to use several times the same cell, as interest rates, the copy we have a problem.
In the right corner of a cell, you notice a square: it is the fill-handle.
The fill handle has two functions:
- copy cells
- increment data series
The second issue will be studied in the form Fill Series
How to use the fill-handle
To copy a cell, just you position the fill handle until the mouse cursor turns into a cross with delicate features.