| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move content line to column
how can I move contents from line to colum or column to line?
for example from A1:M1 to A1:A13 who can help? Robert |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move content line to column
Bach up your file. then
Highlight and Cut the range you want to move. A1:M1 (Assuming range A2:A13 is clear of data) With your active cell (cursor) still in A1 Go to menu, Edit Paste-Special, Check Transpose box near bottom of screen, OK "Robert Ehrlich" wrote in message ... how can I move contents from line to colum or column to line? for example from A1:M1 to A1:A13 who can help? Robert |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move content line to column
Thanks for your help.
I have never seen the menu "Edit Paste-Special" I only know Edit Paste... please explain. Robert "JMay" schrieb im Newsbeitrag news:mxOZb.8909$iB.2765@lakeread06... Bach up your file. then Highlight and Cut the range you want to move. A1:M1 (Assuming range A2:A13 is clear of data) With your active cell (cursor) still in A1 Go to menu, Edit Paste-Special, Check Transpose box near bottom of screen, OK "Robert Ehrlich" wrote in message ... how can I move contents from line to colum or column to line? for example from A1:M1 to A1:A13 who can help? Robert |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move content line to column
Best way to learn it's features:
Open a New Workbook, enter in cell a1 123. With cursor on A1 select Copy, then go to the menu, edit paste-special.. and the dialog box will come up showing all features available to you.. In the upper right-hand corner of the box you will see a "?" left-click on it and then move to each choice (one-by-one) and left-click on them; as you do an explanation follow (in a pale-yellow box). After reading, left-click inside the pale-yellow box and the box is turned off. Then again back to the ? and go to the next choice; go thru them all. That's me suggestion (for starters)... "Robert Ehrlich" wrote in message ... Thanks for your help. I have never seen the menu "Edit Paste-Special" I only know Edit Paste... please explain. Robert "JMay" schrieb im Newsbeitrag news:mxOZb.8909$iB.2765@lakeread06... Bach up your file. then Highlight and Cut the range you want to move. A1:M1 (Assuming range A2:A13 is clear of data) With your active cell (cursor) still in A1 Go to menu, Edit Paste-Special, Check Transpose box near bottom of screen, OK "Robert Ehrlich" wrote in message ... how can I move contents from line to colum or column to line? for example from A1:M1 to A1:A13 who can help? Robert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i use the = to move formatting and content between tabs? | Excel Worksheet Functions | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| Move equations from line to line automatically | Excel Discussion (Misc queries) | |||
| Excel: is it possible to move column contents into a line | Excel Discussion (Misc queries) | |||
| Move a column in one line of code | Excel Programming | |||
Hybrid Mode
