Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
text
I entered text in column A and 5 rows
I want to change that information that I entered in A1, A2,A3,etc to go to A1,B1,C1,D1,etc. Can you help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
text
Select A1:A5 Copy
Right-click on A2 Paste special Check "Transpose" OK Delete col A -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Chris" wrote in message ... I entered text in column A and 5 rows I want to change that information that I entered in A1, A2,A3,etc to go to A1,B1,C1,D1,etc. Can you help |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
text
You want to move the data from a column to a row:
Select the data in Column A and pull-down: Edit Copy Click on Cell B1 (Not A1) and pull-down: Edit Paste Special and check the Transpose button This will copy your data into a row. Select the data from B1 thru the end and pull-down: Edit Cut Click on Cell A1 and pull-down: Edit Paste This will move the data back to starting at A1. -- Gary's Student "Chris" wrote: I entered text in column A and 5 rows I want to change that information that I entered in A1, A2,A3,etc to go to A1,B1,C1,D1,etc. Can you help |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
text
Copy the data in column A, move to the cell where you want the data to start
in and click on EDIT in the menu, select PASTE SPECIAL. Locate the TRANSPOSE checkbox and check it off. Click OK to exit and delete the data in Column A. Viola! -- Kevin Backmann "Chris" wrote: I entered text in column A and 5 rows I want to change that information that I entered in A1, A2,A3,etc to go to A1,B1,C1,D1,etc. Can you help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extra help with transpose | Excel Discussion (Misc queries) | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |