Tip Printed from ExcelTip.com

---

Copying/Moving a Cell(s) Between Sheets/Workbooks in Excel 2007


Using keyboard shortcuts

To copy and paste cells to another sheet:
1. Select a range of cells that contain data.
2. Point the mouse to the selection border, hold down the keys, and drag the range to a new location in another sheet.

To move cells to another sheet:
1. Select a range of cells that contain data.
2. Point the mouse to the selection border, hold down the key, and drag the range to a new location in another sheet.

To copy/move cells to another workbook:
1. Select View -> Arrange (in Window Group) -> select any option button in Arrange Windows dialog box and press OK.
2. Select a range of cells that contain data.
3. Point the mouse to the selection border, hold down the keys (to copy) or the key (to move) and drag the range to a new location in a sheet of another workbook.