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 ...
2nd October 2012, 10:46 AM #1
Excel - Copy/Paste Columns
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?
Last edited by TBlax; 2nd October 2012 at 10:53 AM.
IDG Tech News
2nd October 2012, 11:26 AM #2
You can copy both across, but because the gap is bigger in the new file it won't put them where you want them.
2nd October 2012, 11:40 AM #3
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
2nd October 2012, 11:42 AM #4
Couldn't you just copy them across and insert the missing columns?
Originally Posted by TBlax
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.
By mdench in forum How do you do....it?
Last Post: 29th April 2012, 05:39 PM
By kindy198636 in forum Office Software
Last Post: 6th March 2012, 01:47 AM
By LosOjos in forum Office Software
Last Post: 7th June 2011, 04:22 PM
By albertwt in forum Windows Server 2000/2003
Last Post: 24th February 2011, 08:31 PM
By doomie in forum Windows
Last Post: 19th May 2006, 11:53 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)