Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking rows to a column
Assuming you want to move the data from row to column:
1) Select all worksheets (click on the tab of the first one then press CTRL+SHIFT+PGDOWN) 2) Select cells A1:X1 with the mouse 3) Press CTRL+C to copy 4) Click on cell A2 5) Choose Paste Special... on the Edit menu (ALT+e+s) 6) Check mark the Transpose option and click OK 7) Select the first row and delete it Best, Rafael "Dan Evers" wrote: I saw the post below about linking columns to rows, but am not smart enough to adjust it to rows to columns. Example- Data in Sheet2, Rows A1-X1 need to go to Sheet1, Columns A1-A26. I need to do this for about 24 sheets, so I am too lazy to use the = function and manually input. Thanks in advance for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) |