|  

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

CATEGORY - Excel General VERSION - Microsoft 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.
Screenshot // Copying/Moving a Cell(s) Between Sheets/Workbooks in Excel 2007
Copying/Moving a Cell(s) Between Sheets/Workbooks in Excel 2007
Rate This Tip
12 34 5
Rating: 1.17     Views: 5794
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments