LinkBack URL
About LinkBacks
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!
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!
After selecting cell to begin pasting at, Go to Edit|Paste special and select Transpose... click Ok
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
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?
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.
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..
Don't know what you mean.
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.
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.
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.
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.
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.
Sorry, I can't think of any other way....
Perhaps with some VBA?....but I don't really know how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks