| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formulas in Column
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy formulas in Column
--Select the range A1:Z1 and copy
--Select cell A20. Right clickPasteSpecialcheck '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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy formulas down a column containing data | Excel Discussion (Misc queries) | |||
| Office XP - Excel 2002; Column formatting & Formulas Do Not Copy | Excel Worksheet Functions | |||
| copy data and formulas from a column and paste into a row | Excel Worksheet Functions | |||
| Find last column, move formulas over, copy/paste data | Excel Worksheet Functions | |||
| Skip column cells and copy formulas | Excel Discussion (Misc queries) | |||
Linear Mode
