Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can i make excel from vertical to horizontal?
how can i make excel from vertical to horizontal?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
Excel formula to make AAA-BBB equal to/consistent with BBB-AAA | Excel Worksheet Functions | |||
Excel column headers to a vertical list | Excel Discussion (Misc queries) | |||
How do I make a time Stamp in excel? | Excel Discussion (Misc queries) | |||
Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) |