Why can't I copy a worksheet with all the formating, column/row sizes to
another worksheet within the same workbook. I have tried to do past special
but it only does the column size. I want the whole thing. I tried making a
template, but it won't let me make many worksheets with the same thing.

Gina if you right click on the tab you want to copy you will get a menu
option and selece Move or Copy, click the box Create a copy and then if you
highlight one of the tab options above the check box it will allow you to put
it at the end or before which ever one you click on. I hope this is the
answer that you were looking for.
--
"If you can''''t have the best of everything make the best of everything you
have"...BIAKathy


"Gina" wrote:

Why can't I copy a worksheet with all the formating, column/row sizes to
another worksheet within the same workbook. I have tried to do past special
but it only does the column size. I want the whole thing. I tried making a
template, but it won't let me make many worksheets with the same thing.