View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
 
Posts: 117
Default 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
.