how can i make excel from vertical to horizontal?

Guest · Jan 2, 2006

Guest · Jan 2, 2006

Use page settings:

Pull-down:
File > Page Settings... > Page and check Landscape

Max · Jan 2, 2006

Mariaepa said:
how can i make excel from vertical to horizontal?

Another guess ..

Assume a source "vertical" range is A1:A3,
which is to be copied and placed "horizontally" in B1

1

Via copy > pasting:
Select A1:A3, right-click > Copy
Right-click on B1 > Paste special > check "Transpose" > OK

Another way, which links B1

1 dynamically to A1:A3
Put in B1: =INDEX($A:$A,COLUMN(A1))
Copy across to D1