Copying worksheet but changing format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I think you probably need Paste Special and Transpose which takes headings
from Row and puts in column or vice versa. HTH

Sheila
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Losing Formatting in 2003 to 2007 worksheets 3
Worksheet protection question 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cannot copy worksheet to another file 2
Copying template from one worksheet to another 2
extracting data 2
holding worksheet formats when copying/pasting 2

Back
Top