How to Copy and Paste in Excel?

How to Copy and Paste in Excel?
Last Updated on 07/05/2024
Reading time: 2 minutes

Copy-paste is the most common action you do in Excel to save a lot of time.

  1. Copy-paste using the ribbon

    This is the original technique to perform a copy-paste in Excel. It works but it isn't the most efficient

  2. Shortcuts

    Former a copy-paste is such a common manipulation that you have 2 shortcuts to do this task

  3. The Fill handle

    Also, when you drag and drop the fill handle, you can paste values or formulas

Benefits of the action Copy Paste in Excel

With Excel, you can copy any cell or any range of cell

  1. Select the cell you want to copy and click on the following icon "Copy" in the Home tab.
  2. Just after, you see an animation with dotted lines moving (the dancing ants πŸ•ΊπŸœ). This animation means that the cell has been copied to the computer's memory.
  3. Then, select the cell where you want to paste the contain of the first cell
  4. Click on the Paste icon.
  5. All the contain of the first cell (color, font, borders, formula) is transferred to the second cell.
Copy Paste in Excel with the ribbon

Keyboard Shortcut

You can also use the following shortcut to perform the same action

Copy contents of the selection to the clipboardCtrl + C
Paste contents of the clipboard. Ctrl + V

The fill-handle

When you want to copy/paste on adjacent cells, doing this action with the mouse is faster. You notice a square in the bottom-right corner of a cell: the fill-handle. Whatever is contained in your original cell, you have to click and drag to copy this cell.

Increase series of number with the fill handle

If you have a single value, use the fill handle to copy the same value. If you press Ctrl, you extend the series.

Increase series automatically

The fill handle helps you to increase the series of values automatically. NO FORMULA is needed πŸ˜‰

Duplicate column with the Ctrl Key

If you want to duplicate a column, the easiest way is to

  1. Select the column you want to duplicate
  2. Move the cursor to the edge of the selection
  3. Press the Ctrl key
  4. Drag and Drop BUT never release the Ctrl Key
Duplicate with Ctrl

Copy a formula

When a cell contains a formula, Excel automatically changes the formula's references. Let's copy cell C2 to the range C3:C6.

How to copy paste formulas with the mouse in Excel

Automatically, Excel has changed the references of the cells in the formulas πŸ˜‰ You can "block" the cell references by putting the $ sign on both sides of the reference to ensure that they do not move.

Leave a Reply

Your email address will not be published. Required fields are marked *

How to Copy and Paste in Excel?

Reading time: 2 minutes
Last Updated on 07/05/2024

Copy-paste is the most common action you do in Excel to save a lot of time.

  1. Copy-paste using the ribbon

    This is the original technique to perform a copy-paste in Excel. It works but it isn't the most efficient

  2. Shortcuts

    Former a copy-paste is such a common manipulation that you have 2 shortcuts to do this task

  3. The Fill handle

    Also, when you drag and drop the fill handle, you can paste values or formulas

Benefits of the action Copy Paste in Excel

With Excel, you can copy any cell or any range of cell

  1. Select the cell you want to copy and click on the following icon "Copy" in the Home tab.
  2. Just after, you see an animation with dotted lines moving (the dancing ants πŸ•ΊπŸœ). This animation means that the cell has been copied to the computer's memory.
  3. Then, select the cell where you want to paste the contain of the first cell
  4. Click on the Paste icon.
  5. All the contain of the first cell (color, font, borders, formula) is transferred to the second cell.
Copy Paste in Excel with the ribbon

Keyboard Shortcut

You can also use the following shortcut to perform the same action

Copy contents of the selection to the clipboardCtrl + C
Paste contents of the clipboard. Ctrl + V

The fill-handle

When you want to copy/paste on adjacent cells, doing this action with the mouse is faster. You notice a square in the bottom-right corner of a cell: the fill-handle. Whatever is contained in your original cell, you have to click and drag to copy this cell.

Increase series of number with the fill handle

If you have a single value, use the fill handle to copy the same value. If you press Ctrl, you extend the series.

Increase series automatically

The fill handle helps you to increase the series of values automatically. NO FORMULA is needed πŸ˜‰

Duplicate column with the Ctrl Key

If you want to duplicate a column, the easiest way is to

  1. Select the column you want to duplicate
  2. Move the cursor to the edge of the selection
  3. Press the Ctrl key
  4. Drag and Drop BUT never release the Ctrl Key
Duplicate with Ctrl

Copy a formula

When a cell contains a formula, Excel automatically changes the formula's references. Let's copy cell C2 to the range C3:C6.

How to copy paste formulas with the mouse in Excel

Automatically, Excel has changed the references of the cells in the formulas πŸ˜‰ You can "block" the cell references by putting the $ sign on both sides of the reference to ensure that they do not move.

Leave a Reply

Your email address will not be published. Required fields are marked *