Hi Henry - my Excel guru!, THANKS A MILLION!!!! I've done 70 worksheet
workbooks w/summary pages & massive formula and could not find the answer to
this from any Excel help menu or anyone I know. Your directions are so
simple & exact, AND IT WORKS!, and you saved me from spending more
frustrating time in trying to get the answer to this and COUNTLESS time in
creating multiple worksheet workbooks! I wish I knew about this site sooner!
THANKS AGAIN HENRY MY HERO!
Best regards, Christine

"Henry" wrote:

tccc1219,

On the worksheet that you want to copy, click on the little square above the
number 1 (Row number) and to the left of the letter A (Column letter).
Then click on the Format Painter Icon (The paintbrush).
You'll get the "Marching Ants" all round the worksheet.
Now click on the new worksheet tab and then click in the little square above
the 1, to the left of the A.
The new sheet will have the same format as the old one.

Henry


"tccc1219" wrote in message
...
Can anyone please explain in step by step laymen's terms on how to copy
ENTIRE formatting (including Row Heights & Column Widths) from WORKSHEET
TO
WORKSHEET within the same Workbook. I appreciate your help immensely!