Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Glissader
 
Posts: n/a
Default Copying worksheet but changing format

Is it possible to copy one worksheet into a new one but switch the headings
to be on the left vertical and vice versa? Or must I manually recreate the
whole worksheet in this new set-up?

Thanks
  #2   Report Post  
Sheila D
 
Posts: n/a
Default

I think you probably need Paste Special and Transpose which takes headings
from Row and puts in column or vice versa. HTH

Sheila

"Glissader" wrote:

Is it possible to copy one worksheet into a new one but switch the headings
to be on the left vertical and vice versa? Or must I manually recreate the
whole worksheet in this new set-up?

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying worksheet tabs Lynn Excel Discussion (Misc queries) 1 March 18th 05 06:50 PM
Copying a date format Michele/Nextel Excel Discussion (Misc queries) 1 March 17th 05 09:19 PM
when copying a worksheet to a new one, some of the information do. AZ Excel Discussion (Misc queries) 2 February 4th 05 02:01 AM
How do I change format of all comments in worksheet? Clare Castle Excel Discussion (Misc queries) 1 January 19th 05 04:54 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM


All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"