1
I tried your advise but it doesn't work with cells with formulas. So I went on trying and I found that not only TRANSPOSE but also LINK must be choosen. Now it works. Thanks.
hatalar205 ( 2012-02-27 14:54:47 +0200 )edit
I really don't know how to explain. So I uploaded a picture here. I want to display the formulas in C6 - G6 range, to C9 - C13 range cells. Do I have to do it one by one, or is there an easy way?
Hi: Select the cells in the row you want to make into a vertical column. Choose EDIT-CUT Click on the cell that will be the top of the new columnj Choose EDIT-PASTE SPECIAL Mark PASTE ALL and TRANSPOSE Click OK
I tried your advise but it doesn't work with cells with formulas. So I went on trying and I found that not only TRANSPOSE but also LINK must be choosen. Now it works. Thanks.
hatalar205 ( 2012-02-27 14:54:47 +0200 )editLibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-02-26 21:12:42 +0200
Seen: 215 times
Last updated: Feb 27 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.