Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert vertical to horizontal
WE HAVE VERTICAL LINE OF NUMBER AND WE WANT TO CONVERT IN HORIZONTAL LINE.PLEASE GIVE SHORT CUT FORMULA
EXT: 1 2 3 4 5 6 7 8 9 10 Please convert in horizontal line. Submitted via EggHeadCafe - Software Developer Portal of Choice Pure Javascript Martin Browser Fractals http://www.eggheadcafe.com/tutorials...martin-br.aspx |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert vertical to horizontal
Select your column of numbers and then click Copy
Select the cell where you want to start your horizontal line and then click Paste special. Tick the box transpose and then OK "AMIT BHOPAL" wrote: WE HAVE VERTICAL LINE OF NUMBER AND WE WANT TO CONVERT IN HORIZONTAL LINE.PLEASE GIVE SHORT CUT FORMULA EXT: 1 2 3 4 5 6 7 8 9 10 Please convert in horizontal line. Submitted via EggHeadCafe - Software Developer Portal of Choice Pure Javascript Martin Browser Fractals http://www.eggheadcafe.com/tutorials...martin-br.aspx . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert vertical to horizontal
Hi,
You don't need a formula. Copy the numbers then select a cell 'outside' of the range and then 'Paste Special' select Transpose OK PS I think the Caps lock key on your keyboard is stuck. Mike "AMIT BHOPAL" wrote: WE HAVE VERTICAL LINE OF NUMBER AND WE WANT TO CONVERT IN HORIZONTAL LINE.PLEASE GIVE SHORT CUT FORMULA EXT: 1 2 3 4 5 6 7 8 9 10 Please convert in horizontal line. Submitted via EggHeadCafe - Software Developer Portal of Choice Pure Javascript Martin Browser Fractals http://www.eggheadcafe.com/tutorials...martin-br.aspx . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert vertical blocked list to horizontal list? | Excel Worksheet Functions | |||
Freeze Vertical and Horizontal | Excel Discussion (Misc queries) | |||
how do i convert vertical data into horizontal data | Excel Discussion (Misc queries) | |||
Vertical to Horizontal | Excel Discussion (Misc queries) | |||
Vertical to horizontal | Excel Discussion (Misc queries) |