| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Hi,
I have to copy numbers from cell a1, b1,c1...........z1 to a20,a21,a22,a23... so. for e.g-- a1 = 21 b1 = 23 c1 = 24 etc z1 = 40 i need to copy as follows:- a20 = a1 a21 = b1 a22 = c1 Is there an easy way to copy the numbers instead of typing one by one .... I have many records to copy..... Thanks for your kind help  Meeru |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
--Select the range A1:Z1 and copy
--Select cell A20. Right click>PasteSpecial>check 'Transpose' and click OK -- Jacob "Meeru" wrote: > Hi, > > I have to copy numbers from cell a1, b1,c1...........z1 to a20,a21,a22,a23... > so. for e.g-- > > a1 = 21 > b1 = 23 > c1 = 24 > etc > z1 = 40 > > i need to copy as follows:- > a20 = a1 > a21 = b1 > a22 = c1 > > Is there an easy way to copy the numbers instead of typing one by one .... > I have many records to copy..... > > Thanks for your kind help > Meeru |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy formulas down a column containing data | Gary | Microsoft Excel Misc | 1 | 15th Oct 2008 04:56 PM |
| copy data and formulas from a column and paste into a row | john.laffe | Microsoft Excel Worksheet Functions | 1 | 12th Dec 2007 02:59 PM |
| Find last column, move formulas over, copy/paste data | =?Utf-8?B?TWlrZSBSLg==?= | Microsoft Excel Worksheet Functions | 0 | 19th Sep 2007 06:40 AM |
| Skip column cells and copy formulas | mahadevan.swamy@gmail.com | Microsoft Excel Misc | 2 | 13th Mar 2007 07:54 AM |
| copy/paste column remove formulas | sugargenius | Microsoft Excel Programming | 2 | 18th Jul 2006 11:49 PM |
