Quick Copy Autoshapes and Form Controls

January 21st, 2005 | Categories: Shortcuts | Tags:
-->

CtrlCopyI haven’t used this shortcut in a couple years. I was reminded of it when it was used in the Charts Webcast.

You can quickly create a copy of an Autoshape in a Worksheet, or a copy of Controls on a Userform:

1. Hold down the Ctrl key
2. Click and Drag the Object to copy

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. ross
    January 22nd, 2005 at 01:30
    Reply | Quote | #1

    you can do this with Anything you can select in any (most) windows enviroments, inc. file dirs.

  2. ross
    January 22nd, 2005 at 01:35
    Reply | Quote | #2

    … just to make the point this goes fro cell ranges, work sheets, etc.

    in the VBE you can drag VBE componets to another project to make a copy of it (with the same name) with out using +ctrl, – you can not use + ctrl to make a copy in th same project (names issue i guess)

  3. Mark
    January 22nd, 2005 at 10:50
    Reply | Quote | #3

    Yep, the other stuff works.. I wish I would have remembered copy range(click the edge and drag after holding ctrl) it used to be a favorite. I’m more a mouse guy than keyboard guy, if there is such a type distinction.

    Thanks.

  4. mutuelle
    June 26th, 2009 at 17:50
    Reply | Quote | #4

    I just want to thank you man ,it’s really informative ,I enjoy those tutorials a lot.