Copying Cells Contents

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Copying Cells Contents

Introduction

If you have done word processing before, you are probably familiar with techniques of copying and pasting text from one part of a document to another, or from one document to another. The same technical approaches are also available in Microsoft Excel.

You can copy the content of one or more cells and store the value(s) in the clipboard. In Microsoft Excel 97, you could store only one item at a time in the clipboard. If you cut or copied something, it would replace the content of the clipboard with the new selection. In Microsoft Excel 2000, the clipboard could contain up to twelve items. When the Clipboard toolbar was functional, you could select copied or cut items from its list of buttons. If you used more than 12 stored items, the toolbar functioned on a first-in first-out basis.

In Microsoft Office 2007, the clipboard is represented as a window. To display it, on the Ribbon, in the Home tab, and in the Clipboard section, you can click the more options button:

The Clipboard window can be moved to any location of your choice on the screen. You can also hide/close it if you don't need its services. To close it, you can click its Close button or you can click the more options button.

Copying and Pasting Cells

In Lesson 2, we saw that you could copy one or more columns and put them to the clipboard. In reality, you would have copied the contents of the cells under the column header and paste the values of those cells to (an)other column(s). As a reminder, to copy the contents of the cells of a column to the clipboard:

  • Right-click a column header and click Copy
  • Click the column header. On the Ribbon, click Home. In the Clipboard section, click Copy

After copying a column, the values of all of its cells are available from the clipboard. To paste those cells to another column:

  • Right-click the target column header and click Paste
  • Click the column header. On the Ribbon, click Home. In the Clipboard section, click Paste

In Lesson 3, we saw how to copy a row and paste it somewhere. When you copy a row, you in fact copy the values of the cells on the right side of its row header. You can then paste the copied values to another row.

Instead of copying all the cells of a column or all of the cells of a row, you can copy only one or more cells to the clipboard:

  • To copy the content of a cell:
    • Right-click that cell and click Copy. To paste, click the target cell and simply press Enter, or right-click the target cell and click Paste
    • Click the cell. On the Ribbon, click Home. In the Clipboard section, click Copy. Click the target cell. To paste the content of the selected cell, click Paste
    • Click the cell. Press and hold Ctrl. Position the mouse on one of its borders. The mouse cursor would be pointing to the top-left and accompanied by a + sign:
       


      While holding Ctrl, drag to the target cell. When the target cell is surrounded, release the mouse and release Ctrl
  • To copy the contents of various cells, select the cells in a range:
    • Right-click the selection and click Copy. Click the top-left cell of the target cell. To paste, simply press Enter, or right-click a targeted cell and click Paste
    • On the Ribbon, click Home. In the Clipboard section, click Copy. Click the top-left cell or the target. To paste, in the Clipboard section of the Ribbon, click Paste
    • Press and hold Ctrl. Position the mouse on one of the borders of the selection. The mouse cursor would be pointing to the top-left and accompanied by a + sign. While holding Ctrl, drag the group in the desired direction. When the target cells are surrounded, release the mouse and release Ctrl

Practical Learning: Copying Cells Contents

  1. Open the Grier Summer Camp3 workbook and click the Employment Application1 if necessary to activate it
  2. Right-click Cell B8 and click Copy
  3. Click Cell F8 and press Enter. That pastes First Name to cell F8
  4. On the Ribbon, click Home if necessary.
    In the Clipboard section, click the Clipboard button Clipboard
  5. Right-click Cell B13 and click Copy
  6. Click Cell F13
  7. On the Clipboard window, click Home Phone
  8. Click Cell F15 and type 2)
  9. Select Cells from C32:G35
    In the Clipboard section of the Ribbon, click the Copy button Copy. That action copies the selected range to the Clipboard
  10. Click Cell C38
  11. In the Clipboard window, click the top button to paste the copied selection
  12. Cells C38:G41 should still be selected. If the group of Cells C38:G41 is not selected, select it. Position your mouse on one of the borders of the selected group until the mouse pointer turns into a cross
  13. Press and hold Ctrl
  14. With the mouse pointer pointing to North West and the mouse now having a small + sign, click and hold the mouse down, then drag towards the lower side of the screen. A small box guides you to know where the selection is leading
     
    Copy
  15. When you get to C44:G47, release the mouse, then release Ctrl
  16. To save the workbook, on the Quick Access toolbar, click the Save button Save