Shortcut to Copy a Worksheet in Same Workbook

September 24th, 2004 | Categories: Shortcuts | Tags:

If you need to create a copy of a worksheet in the same workbook there’s a quicker way than right clicking the tabname and using the “move or copy” dialogue box.

While holding the CTRL key down, left click the activesheets tab, then drag the tab to the location you would like a copy.

Note: This only works for the activesheet. In other words, if Sheet1 is active and you hold CTRL and click Sheet2’s tab, you will invoke the multiple select, not the copy.

No comments yet.