how can i make excel from vertical to horizontal?

G

Gary''s Student

Use page settings:


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

Max

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

Another guess ..

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

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

Another way, which links B1:D1 dynamically to A1:A3
Put in B1: =INDEX($A:$A,COLUMN(A1))
Copy across to D1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Move Chart with Text 0
Document extends beyond horizontal ruler! 1
Excel chart, set a vertical baseline on a certain date 1
[Excel 2010] how to get a horizontal scroll bar form control 2
Keeping a Table to a Single Page 3
Horizontal Line Graphic 2
Adjust Vertical Pane Splitter 0

Top