| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transpose data between columns, rows or cells
Hi, How can I switch data between cells, rows or columns in one step? For instance, if I want to switch the contents of cells A1 and B1, how do I do that without having to retype everyting, and without having to use a third column (that's what I do now: first I copy B1 to C1, then A1 to B1, then C1 to A1, then delete C1 - this method is obviously very tedious...). Tnx, John -- jonnel ------------------------------------------------------------------------ jonnel's Profile: http://www.excelforum.com/member.php...o&userid=36946 View this thread: http://www.excelforum.com/showthread...hreadid=566598 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Sort multiple rows by data in certain columns | Excel Discussion (Misc queries) | |||
| Find data in columns, then place in rows | Excel Worksheet Functions | |||
| extract data from a range of cells in rows or columns when a date. | Excel Worksheet Functions | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
Threaded Mode
