![]() |
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. |
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 |
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 |
All times are GMT +1. The time now is 02:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com