| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
importing rows to cols
I have a spreadsheet with dates in row 1, cols A to IV and $ in row 2, cols A
to IV. Obviously I have run out of columns and will switch to rows. How do I import row 1 to col A and row 2 to col B? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
importing rows to cols
Hello Milco,
Highlight you cells and press Ctrl + X (Cut). Right click A1 and choose Paste Special. Check the Transpose button and OK. Judith -- Hope this helps "Milco" wrote: I have a spreadsheet with dates in row 1, cols A to IV and $ in row 2, cols A to IV. Obviously I have run out of columns and will switch to rows. How do I import row 1 to col A and row 2 to col B? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
importing rows to cols
Thanks for quick reply. Unfortunately Paste Special is grayed out so I can't
select it. "JudithJubilee" wrote: Hello Milco, Highlight you cells and press Ctrl + X (Cut). Right click A1 and choose Paste Special. Check the Transpose button and OK. Judith -- Hope this helps "Milco" wrote: I have a spreadsheet with dates in row 1, cols A to IV and $ in row 2, cols A to IV. Obviously I have run out of columns and will switch to rows. How do I import row 1 to col A and row 2 to col B? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| odd or even rows......and importing from Access | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
