+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2007
    Posts
    24

    How do I move the contents of multiple cells?

    I need to select many cells and move them. Can I do this if I ctrl+click on multiple cells? All cells I need to move are not in a group.

    Thanks,
    Multi
    Need a website or other media? Visit Amalgam Web and Media (http://www.amalgamweb.com) today for a free quote on any custom project.

  2. #2
    Forum Guru Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007
    Posts
    3,441

    Re: How do I move the contents of multiple cells?

    Excel does not allow you to move non-contiguous ranges of cells. You will have to move each contiguous group separately.

    If this is something you do often, a VBA solution could be an option, but if it is a one-off event then VBA is not worth the time/effort.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0