Copy and Move Cells to New Workbook in MS Excel


excel logo

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.
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.