Rajesh, You may want to select the range where you want the data pasted and then see what happens.
Pranav -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rajesh Narang Sent: Monday, November 30, 2009 9:47 PM To: [email protected] Subject: Re: [AI] Help required in MS Excel Hello sir, I have also tried this command, its works fine in empty row. But when I tried to use this command nearby the selected range, the paste special option shows unavailable in edit menu. Any solution in this regard? Regards, Rajesh Narang Skype ID: Raj..Narang ----- Original Message ----- From: "Pranav Lal" <[email protected]> To: <[email protected]> Sent: Monday, November 30, 2009 7:18 PM Subject: Re: [AI] Help required in MS Excel > 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 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
