CATEGORY: Excel Keyboard Shortcuts VERSIONS: All Microsoft Excel Versions

Using keyboard shortcuts To copy and paste cells to another sheet: 1. Select a range of cells that contains data. 2. Press and hold Ctrl+Alt and drag the data from the corner of the selection area to a new location in another sheet. To move cells to another sheet: 1. Select a range of cells that contains data. 2. Press and hold Alt and drag the data from the corner of the selection area to a new location in another sheet. To copy/move cells to another workbook: 1. From the Windows menu, choose Arrange. 2. Select any of the Arrange Windows options and click OK. In Excel 2003, use Compare Side by Side to arrange the windows. 3. Select a range of cells that contains data. 4. Press and hold Ctrl+Alt (to copy) or Alt (to move) and drag the cells to a new locations in a sheet in another workbook.

Screenshot // Copying/Moving a Cell(s) Between Sheets/Workbooks

Rate this tip 1 2 3 4 5   RATING: 2.76   VIEWS: 36517 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

The Fall of Advertising and the Rise of PR Yes, You Can Time the Market! Special Edition Using Microsoft Access 2002 The Financial Numbers Game: Detecting Creative Accounting Practices Microsoft Excel VBA Programming for the Absolute Beginner Marketing Management

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books