| Home |
| Search |
| Today's Posts |
|
#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 . |
| 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) | |||
Threaded Mode
