Sameer, Have you tried the transpose option when using the paste special dialog?
Pranav -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sameer Sent: Monday, November 30, 2009 6:40 PM To: Access India Subject: [AI] Help required in MS Excel Dear Friends, In an MS Excel worksheet, I have data in cells A1 to A20. I want to cut & paste the data in the cells B1 to U1. But whenever I cut & paste the data appears in the entire block of cells from B1 to U20 instead of just the required cells. Is there any way in which the data copied from A1 to A20 could be pasted only in B1 to U1? I could cut & paste a single cell at a time but it would be time-consuming. Thanking you all in advance for any & all assistance. Regards Mr. Sameer Latey, Mumbai, India To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
