| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Horizontal Cells changed to Vertical cells
I have seen the solution awhile ago when I visited this board frequentl but I am unable to locate it now. I have a spreadsheet with values i rows but i want to switch these values into columns. As so: abcde a b c d e Thanks in advance, Hoffman -- hoffman ----------------------------------------------------------------------- hoffman3's Profile: http://www.excelforum.com/member.php...fo&userid=1018 View this thread: http://www.excelforum.com/showthread.php?threadid=47085 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Horizontal Cells changed to Vertical cells
Is there a reason that you can't just use Transpose from Paste Special?
Since you've posted into this programming thread, I guess you're looking for code, so: Selection.Copy Range("D9").PasteSpecial Paste:=xlPasteAll, Transpose:=True hoffman3 wrote: I have seen the solution awhile ago when I visited this board frequently but I am unable to locate it now. I have a spreadsheet with values in rows but i want to switch these values into columns. As so: abcde a b c d e Thanks in advance, Hoffman3 -- hoffman3 ------------------------------------------------------------------------ hoffman3's Profile: http://www.excelforum.com/member.php...o&userid=10187 View this thread: http://www.excelforum.com/showthread...hreadid=470853 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Horizontal Cells changed to Vertical cells
Copy the cells and then position the cursor somewhere else and use Paste
Special | Transpose Regards Trevor "hoffman3" wrote in message ... I have seen the solution awhile ago when I visited this board frequently but I am unable to locate it now. I have a spreadsheet with values in rows but i want to switch these values into columns. As so: abcde a b c d e Thanks in advance, Hoffman3 -- hoffman3 ------------------------------------------------------------------------ hoffman3's Profile: http://www.excelforum.com/member.php...o&userid=10187 View this thread: http://www.excelforum.com/showthread...hreadid=470853 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| taking numbers in vertical cells putting them in horizontal cells | Excel Worksheet Functions | |||
| need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
| PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS | Excel Discussion (Misc queries) | |||
| how to re-group the cells from vertical to horizontal | Excel Worksheet Functions | |||
| Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel | |||
![hoffman3[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
