Cell Content – Part 2

To copy and paste cell content:

Excel allows you to copy content that is already entered into your spreadsheet and paste that content to other cells, which can save you time and effort.

  1. Select the cell(s) you want to copy. In our example, we’ll select F9.
  • Click the Copy command on the Home tab, or press Ctrl+C on your keyboard.
  • Select the cell(s) where you want to paste the content. In our example, we’ll select F12:F17. The copied cell(s) will have a dashed box around them.
  • Click the Paste command on the Home tab, or press Ctrl+V on your keyboard.
  • The content will be pasted into the selected cells.

To cut and paste cell content:

Unlike copying and pasting, which duplicates cell content, cutting allows you to move content between cells.

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

To drag and drop cells:

Instead of cutting, copying, and pasting, you can drag and drop cells to move their contents.

  1. Select the cell(s) you want to move. In our example, we’ll select H4:H12.
  2. Hover the mouse over the border of the selected cell(s) until the mouse changes to a pointer with four arrows.
  • Click and drag the cells to the desired location. In our example, we’ll move them to G4:G12.
  • Release the mouse. The cells will be dropped in the selected location.
Start Quiz
Course Quiz Navigation
Complete all questions in quiz to move to the next lesson.