| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I copy a row to a column?
Hello, Folks
I need to have a column of values on one sheet equal a row of values on a different sheet. i.e.: 'sheet2'A1='sheet1'A1; 'sheet2'A2='sheet1'B1; 'sheet2'A3='sheet1'C1; etc. Is there a way to do this using edit/fill or copy? It's way too tedious to type every cell in, or even to click from one sheet to the other for every cell, but I can't find any short cut. TIA, Dennis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
| How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
| how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) | |||
Threaded Mode
