Virtually In The Black | Outsourced Accounting and Bookkeeping Services for Small Businesses

Latest News

Excel – Copy and Paste

By / MS Office -Excel / Comments Off on Excel – Copy and Paste

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.

  1. Copy and Paste on the Home tab of the ribbon:

excel copy pic1-4

 

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.

excel copy pic2-2

 

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:

excel copy pic3-2

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.

excel copy pic4-2

  • 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.

excel copy pic5-2

excel copy pic6-2

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:

excel copy pic7-2

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:

excel copy pic8-2

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.