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