Results 1 to 2 of 2

Thread: Moving several columns into one row

  1. #1
    Newbie
    Join Date
    Aug 2005
    Posts
    1
    I probably won't explain this very well but here goes. Lets say I've got four columns of numbers, say A1-A5, B1-B5, C1-C5, D1-D5. Want I want is for all these cells to be in row one. So, I select cells A2-A5, B2-B5, C2-C5, D2-D5 and drag to cell E1, hoping that the copied cells will fill in row one, but they don't. Is there a way to do that? Otherwise I have to keep copying and pasting until all the cells are in the row. I know a macro could possibly do this, but the ranges will be different each time.

    Thanks for your help.

  2. #2
    Senior Member RickDev's Avatar
    Join Date
    Jul 2005
    Location
    Melbourne, Florida
    Posts
    438
    Sorry, almost deleted this post while trying to clean up the spam being left. I am not an excel expert but I know a site that might be able to help you out some if no one here can.

    Near the bottom of this link it has cell referencing stuff.
    http://www.expresscomputeronline.com/20021...echspace1.shtml
    RickDev
    "Nobody knows what I do until I stop doing it."

    Florida Web Design | Online Geek Hangout | Office Pranks and Humor

Similar Threads

  1. Moving again..
    By jro in forum General Chat
    Replies: 10
    Last Post: 12-15-2009, 06:55 PM
  2. Moving
    By gmoreno in forum General Chat
    Replies: 55
    Last Post: 08-05-2005, 06:52 AM
  3. rows and columns
    By ammad in forum Linux - General Topics
    Replies: 0
    Last Post: 06-08-2005, 04:08 AM
  4. moving
    By pbharris in forum General Chat
    Replies: 9
    Last Post: 08-16-2004, 11:38 PM
  5. moving lilo from mbr
    By in forum Linux - General Topics
    Replies: 3
    Last Post: 02-15-2002, 01:23 AM

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
  •