We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

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

hatalar205 gravatar image

updated 2020-08-07 23:13:47 +0200

Alex Kemp 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

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

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



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 +0200 )edit

Question Tools


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

Seen: 1,148 times

Last updated: Feb 27 '12