Hi, As per my understanding, you want to select a set of vertical cells (column) and paste their content in another set of horizontal cells (row). If correct, then the 'Transpose' option is what you are looking for. To implement this option in Microsoft Excel 2007,
1. Select the set of vertical cells containing source data (A1 to A20 in your case). 2. Press CTRL+C to copy. 3. Place the cursor on the first target cell (B1 in your case). 4. Press ALT+H to go to the Home tab on the menu bar and DOWN ARROW to open the ribbon. 5. Move to the 'Paste' split button with UP/DOWN keys and activate it with SPACEBAR to open the inner menu. 6. Press T for Transpose and come out of the menu structure with ESC. 7. Now check the contents of target cells (b1 to U1 in your case). Hope That Helps! On 11/30/09, Sameer <[email protected]> wrote: > > 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 > -- Best Regards, Zujar Shabbir Kanchwala... Hello : 9769371152 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
