How do i paste in a horizontal manner?

[shrooms]

Assuming i copied a list of cells that are vertical [column format], how do i paste it such that it will become horizontal [horizontal format]

Admin pls help thanks!

[NBVC]

After selecting cell to begin pasting at, Go to Edit|Paste special and select Transpose... click Ok

[shrooms]

My original cell was this:
=IF(C388=B282,"YES",IF(C388=C282,"YES",IF(C388=D282,"YES",IF(C388=E282,"YES",IF(C388=F282,"YES",IF(C388=G282,"YES","NO"))))))

After transposing i had:
=IF(Z367=#REF!,"YES",IF(Z367=#REF!,"YES",IF(Z367=#REF!,"YES",IF(Z367=#REF!,"YES",IF(Z367=#REF!,"YES",IF(Z367=#REF!,"YES","NO"))))))

I was hoping that i can paste that cell with that exact same formulae in it horizontally.. i know the cut function will work but how do i transpose with the cut function?

[NBVC]

You can copy >> Paste Special and select Values as well as transpose...this will copy the results as values in a transposed array...

or you can select the row range to copy to and enter formula =Transpose(A1:A10) where A1:A10 is your original array and then confirm it with CTRL+SHIFT+ENTER instead of just ENTER...this will allow you to change results in original array and the corresponding cell in the new array will also change...


I don't think, however, you can transpose and maintain the exact same formulas.

[shrooms]

Is it possible to disable the autocell change feature when copy and paste is being done? Because my wanted cell numbers has all been changed after copying and paste..

[NBVC]

Don't know what you mean.

[shrooms]

Oh. for example, if i have this cell at cell box S396 with forumale " =C20 " , after pasting it at cell box u396 it becomes " =E20 "
Is there no way that we can disable this excel feature? (it automatically changes my cell)
because i would like it to be =C20 and not E20 at cell box u396.

[NBVC]

If you make the cell reference absolute by adding the $-signs, you will be able to copy to another cell without changing reference.

e.g. =$C$20 then copy to other cell

you can do this quickly by hitting F4 while your cursor is on the cell reference in the formula.

[shrooms]

yea i know abt the absolute cell reference function but i would like my formulaes to be intact meaning to say without showing the $ as $ would prevent me from doing further work like dragging, etc.

[NBVC]

The only other way I can think of is to copy the formula from the formula bar and then paste it in your new cell. This should keep it in tact.

[shrooms]

i have multiple cells that have to be copied and to remain intact when paste. Nvm i dont think excel has such capabilities yet. The Cut functions could help remain it intact, however, it doesnt have a tranpose function.

[NBVC]

Sorry, I can't think of any other way....

Perhaps with some VBA?....but I don't really know how.