There are many ways to copy and paste cell values and/or formulas. This section will cover several methods to get the same result done.
- Copy and Paste on the Home tab of the ribbon:
Select the cell you want to copy and then click on the copy in the Clipboard group of the Home tab. (To move the content or formula, select the Cut button above the copy)
Then select the cells you want to paste the values and/or formulas to and click on the Paste in the Clipboard group of the Home tab.
2. Using the Keyboard shortcuts:
Select the cell you want to copy and hold down CTRL + C. Then select the cells to paste and hold down CTRL + V.
3. Use the mouse:
Select the cell you want to copy and click the right button on mouse. Click Copy.
Then select the cells you want to paste the values and/or formulas to and click the right button on mouse. Click Paste.
- Paste –will paste values or formulas
- Values –will paste the value of the copied cells only, removing all formulas
- Formulas –will paste the formula of the copied cells
- Transpose –will paste the result of the formula, but in transpose. Example: if I had originally entered a formula of C4=B4+$B$2, then copied the formula but pasted it as transpose in C5, the result would be C5=C4+$B$2
- Paste Link –pastes a formula , but it links to the cell copies; therefore, will give the value of the formula of the copied cell in all pasted cells
- Selecting Paste Special –will allow you to select the same as above: formulas, values as well as keeping formats. But, there is a section called operation here. If you want to take a group of numbers and add, multiply, subtract, or divide by a particular number, you can do this by selecting an operation in this section.
You’ll see above where the original set of numbers are listed in column F. I copied the number 2 in column G, then highlighted the rest of the numbers in the same column. I clicked the right button on my mouse and selected Paste Special and the add function under operation. The result was adding the number 2 to all the cells I had highlighted.
4. Select cell and drag:
Select cell to copy. Put mouse pointer on the bottom right hand corner until the pointer turns into a cross. Then, click the left button of mouse and drag down to cells you want values and or formulas to be pasted in.
5. Double click corner of cell:
Select cell to copy. Put mouse pointer on the bottom right hand corner until the pointer turns into a cross. Then, double click the left button of mouse. Values and/or formulas in cell will copy down to the bottom of the data set or the column to the left.