Copy formulas in Column

M

Meeru

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
 
J

Jacob Skaria

--Select the range A1:Z1 and copy
--Select cell A20. Right click>PasteSpecial>check 'Transpose' and click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas won't drag down the column 2
Copy multiple cells to one cell 10
Want code to copy to ABOVE row 22 column A on sheet 1 10
How do I move data from one worksheet to another? 1
How to copy the function SUM but offseted in 7 columns 2
Copy/Paste formulas in merged cells 2
Formula needed for adding every nth column on another sheet 6
fill reference to cells in a row down a column 3

Top