copying a style from one worksheet to another in the same workbook

J

jbclem

All the explanations I've found tell me how to copy a style from one
workbook to another, and it looks like they are referring to everything
within the originating workbook. What I want to do is, inside the same
workbook, open up a new worksheet and duplicate the formatting already in a
different worksheet in the same workbook.

Can someone tell me how to do this, I'm using Excel 2002.


John
 
F

FSt1

All the explanations I've found tell me how to copy a style from one
workbook to another, and it looks like they are referring to everything
within the originating workbook.  What I want to do is, inside the same
workbook, open up a new worksheet and duplicate the formatting already ina
different worksheet in the same workbook.

Can someone tell me how to do this,  I'm using Excel 2002.

John
Click to expand...

hi
see this site. i think it does what you want.
http://office.microsoft.com/en-us/excel-help/using-styles-in-excel-HA001110199.aspx

regards
FSt1
 

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 Copy cells from one worksheet to another workseet - increment row & do again 0
Copy a worksheet to a new workbook 6
How to transfer a worksheet into a new workbook and keep the formulas intact 5
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Searching for a text in different worksheets in a different workbook 0
How to create absolute link to cell in another workbook (Excel 2003) 1
Copying Worksheet data 1
how to use a data validation list from another worksheet within the same workbook 2

Top