| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy Column headings to Rows
Hello-
I'm trying to find a fast way to list all the headings in my spreadsheet. Because there are so many, I thought I could just list them vertically. Is this possible? I didn't get anyone to answer my post on wraping columns, so I'm hoping this will atleast let me print the headings. Thanks. |
|
#2
|
|||
|
|||
|
Copy Column headings to Rows
Easiest way I know is to Copy the column headings, highlight the cell you want to be the start of your new column with the headings in, and go to Copy Paste Special and check the Transpose box. Works for me... -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=484424 |
|
#3
|
|||
|
|||
|
Copy Column headings to Rows
Simple - Beautiful.
Thanks for teaching me. "Brisbane Rob" wrote: Easiest way I know is to Copy the column headings, highlight the cell you want to be the start of your new column with the headings in, and go to Copy Paste Special and check the Transpose box. Works for me... -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=484424 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| Copy one cell to entire column | Excel Discussion (Misc queries) | |||
| MACRO - copy rows based on value in column to another sheet | Excel Discussion (Misc queries) | |||
Linear Mode
