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" <pranav....@gmail.com>
To: <accessindia@accessindia.org.in>
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: accessindia-boun...@accessindia.org.in
[mailto:accessindia-boun...@accessindia.org.in] 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 accessindia-requ...@accessindia.org.in
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 accessindia-requ...@accessindia.org.in
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 accessindia-requ...@accessindia.org.in 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