Worksheet Copy/Move Shortcuts in Excel 2010


show more Worksheet Copy/Move shortcuts provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Worksheet Copy/Move shortcuts

If you want to change the location of a worksheet within a workbook, it's simply a matter of dragging that worksheet. For example, I want to have this current worksheet here, HR List, to appear after the Profits sheet. Simply, drag the sheet tab at the bottom of the screen, drag it to the right. Certainly, you can drag it left throughout as well as needed. Position it wherever we wish. Copying a worksheet is often started by right- clicking a sheet tab, going into Move or Copy. And although this is not incorrect, there is a much faster way to copy a worksheet.

So imagine for example that this project budget 2012, I want to make a copy of this and turn it into the budget for 2013, but rather than copying and pasting data, I'm about to copy the worksheet, simply by dragging this with the Ctrl key held down. A tiny little plus appears in the icon. I'll drag it to the right and let go with the mouse. It could hardly be faster. These two worksheets are identical in all respects excep...

Worksheet Copy/Move shortcuts
Video duration: 2m 29s 3h 43m Intermediate

Viewers:

Worksheet Copy/Move shortcuts provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...