how can i make excel from vertical to horizontal?
how can i make excel from vertical to horizontal?
|
how can i make excel from vertical to horizontal?
Use page settings:
Pull-down: File Page Settings... Page and check Landscape -- Gary's Student "Mariaepa" wrote: how can i make excel from vertical to horizontal? |
how can i make excel from vertical to horizontal?
"Mariaepa" wrote:
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: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 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
All times are GMT +1. The time now is 03:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com