copy formats column width & row heights between Excel WORKSHEETS?
 

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!

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!

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!

Christine,

1) You're welcome.
2) Thanks for the feedback.

This group has answered many of my queries, so I have no hesitation in
answering other's queries when I can.
Give time, you may find that you can help others out with their queries too.

ATB
Henry

"tccc1219" wrote in message
...
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!

Henry, thanks a million. I wonder how many other obscure tricks there are out
there. Is there a website that can be searched for them. I seldom get a
satisfactory answer by searching MS Help On-Line.


"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!

copy formats column width & row heights between Excel WORKSHEE
 

WHERE IS THE LOCATION OF THE PAINTBRUSH PLEASE. IT'S NOT ONE OF MY ICONS.
AND HOW DO I ADD IT? thanks.

"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!