Cell Content (Part 2)

Copy and paste cell content:

Excel lets you copy the already entered content into your spreadsheet and paste the content into other cells, saving you time and effort.

  1. Choose the cell(s) you want to copy. In our example, we will select F9.
  • On the Home page, click the Copy command or press Ctrl+C on your keyboard.
  • Pick the cell(s) where the material is to be pasted. We will select F12:F17 in our case. A dashed box will appear around the copied cell(s)
  • On the Home page, click the Copy command or press Ctrl+V on your keyboard.
  • The content will be pasted into the cells picked.

Cut and paste cell content:

Cutting enables you to transfer material between cells in comparison to copying and pasting, which duplicates cell content.

  1. Choose the cell(s) you want to cut. In our example, we will select G5:G6.
  2. Right-click the mouse and then pick the Cut command. Alternatively, you can use the command on the Home tab, or on your keyboard, press Ctrl+X.
  • Pick the cells where you want to paste the content. The cut cells will now have a dashed box around them.
  • Right-click the mouse and then pick the Paste command. Alternatively, you can use the command on the Home tab, or on your keyboard, press Ctrl+V.
  • The cut material will be stripped and paste into the selected cells from the original cells.

Drag and drop cells:

You can drag and drop cells to move their contents, rather than cutting, copying and pasting.

  1. Pick the cell(s) you want to move.
  2. Hover the mouse over the selected cell(s) border before the mouse switches to a four-arrow pointer.
  • Pick and drag the cells to the location of your choice.
  • Release the mouse. The cells will be dropped in your chosen location.

Start Learning for Free