Ask Your Question
0

Displaying formulas from horizontal block of cells to vertical block of cells [closed]

asked 2012-02-26 21:12:42 +0100

hatalar205 gravatar image

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? image description

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 05:04:53.797051

1 Answer

Sort by » oldest newest most voted
0

answered 2012-02-27 14:31:55 +0100

bkalaska gravatar image

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

edit flag offensive delete link more

Comments

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 gravatar imagehatalar205 ( 2012-02-27 14:54:47 +0100 )edit

Question Tools

Stats

Asked: 2012-02-26 21:12:42 +0100

Seen: 955 times

Last updated: Feb 27 '12