software

how can i make excel from vertical to horizontal?

Use page settings:Pull-down:
File gt; Page Settings... gt; Page and check Landscape
--
Gary's Studentquot;Mariaepaquot; wrote:

gt; how can i make excel from vertical to horizontal?

quot;Mariaepaquot; wrote:
gt; how can i make excel from vertical to horizontal?

Another guess ..

Assume a source quot;verticalquot; range is A1:A3,
which is to be copied and placed quot;horizontallyquot; in B11

Via copy gt; pasting:
Select A1:A3, right-click gt; Copy
Right-click on B1 gt; Paste special gt; check quot;Transposequot; gt; OK

Another way, which links B11 dynamically to A1:A3
Put in B1: =INDEX($A:$A,COLUMN(A1))
Copy across to D1
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--