+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Excel - Copy/Paste Columns in Technical; Hi all, I keep being given a bunch of these Emark book things to convert from 'sets' to 'classes' since ...
  1. #1
    Fleetwood's Avatar
    Join Date
    Feb 2012
    Posts
    741
    Thank Post
    181
    Thanked 105 Times in 56 Posts
    Rep Power
    44

    Excel - Copy/Paste Columns

    Hi all,

    I keep being given a bunch of these Emark book things to convert from 'sets' to 'classes' since the teachers can't do it themselves. They're basically like APP grids.

    Anyway, all I need to do is copy and paste columns from one excel file to another. However, not in the same order. For example: The data for Column F and Column K in the original file needs to go in Column D and Column P. All I keep getting when I try to c/p that is "the command you choose cannot be performed with multiple selections" - this is proving to be a HUGE annoyance as it means I'm having to copy ony column at a time, which ends up taking a lot more time.

    Anybody care to give me some workarounds on how I can make this quicker?
    Cheers!
    Last edited by Fleetwood; 2nd October 2012 at 10:53 AM.

  2. #2

    X-13's Avatar
    Join Date
    Jan 2011
    Location
    /dev/null
    Posts
    9,175
    Thank Post
    600
    Thanked 1,990 Times in 1,370 Posts
    Blog Entries
    19
    Rep Power
    837
    You can copy both across, but because the gap is bigger in the new file it won't put them where you want them.

  3. #3
    Fleetwood's Avatar
    Join Date
    Feb 2012
    Posts
    741
    Thank Post
    181
    Thanked 105 Times in 56 Posts
    Rep Power
    44
    Ah bogger. Fair enough, thanks! If they didn't protect the sheet and lose the password I'd have tried hiding the unwanted columns /slitwrists

  4. #4

    X-13's Avatar
    Join Date
    Jan 2011
    Location
    /dev/null
    Posts
    9,175
    Thank Post
    600
    Thanked 1,990 Times in 1,370 Posts
    Blog Entries
    19
    Rep Power
    837
    Quote Originally Posted by TBlax View Post
    Ah bogger. Fair enough, thanks! If they didn't protect the sheet and lose the password I'd have tried hiding the unwanted columns /slitwrists
    Couldn't you just copy them across and insert the missing columns?


    Le EDIT: You could also try this. [I take no responsibilty for any harm caused by this.]
    Last edited by X-13; 2nd October 2012 at 11:52 AM.

SHARE:
+ Post New Thread

Similar Threads

  1. Excel - Copy data based on row value
    By mdench in forum How do you do....it?
    Replies: 4
    Last Post: 29th April 2012, 05:39 PM
  2. [MS Office - 2010] Copy & Paste short cut won't work
    By kindy198636 in forum Office Software
    Replies: 0
    Last Post: 6th March 2012, 01:47 AM
  3. [MS Office - 2007] Excel - Long text cells copy & paste as '#'
    By LosOjos in forum Office Software
    Replies: 10
    Last Post: 7th June 2011, 04:22 PM
  4. Clipboard is not working two ways for copy paste over RDP ?
    By albertwt in forum Windows Server 2000/2003
    Replies: 0
    Last Post: 24th February 2011, 08:31 PM
  5. Replies: 7
    Last Post: 19th May 2006, 11:53 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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