Copy and Move Cells to New Workbook in MS Excel

You may have an occasion when you would like to copy cells from your current workbook to a new one. Fortunately, this is very easy to do.

Follow the steps below to learn how:

  1. Close all open workbooks except for your current on and the one where you would like to paste the cells.
  2. In the workbook where you would like to insert the copied cells, be certain the area where you would like your copied cells to reside is visible.
  3. On the View tab of your Ribbon, in the Window group, click Arrange All.
  4. Click OK and both workbook windows will appear.
  5. Select the cells you would like to copy or move.
  6. To copy your cells, click CTRL + Alt.
  7. To move your cells, click just your Alt key.
  8. Point to an outside edge of your selected cells and drag the cells over to the other workbook and drop them in the area of your choice.
  9. Click the Maximize button at the topmost corner of one of your workbooks to restore the windows.
Exit mobile version


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!