If you group the sheets then any formatting you do in lets say cell A1 will
appear in Sheet2 A1. etc.
To group sheets click on Sheet1 and while holding Shift click on Sheet 2.
If you want to group a lot of sheets then click on the tab for Sheet1 and
while holding Shift click on Sheet16 all the sheets tabs will be white. That
shows that they are grouped.
To select sheets that are not side by side use the Ctrl key and click on
individual sheet tabs.

Remember to ungroup the sheets when you are finished. To ungroup right
click on any white tab (sheet1) and choose ungroup.

"Kent" wrote:

Hi,

I have an excel file that has two worksheets in it. On Sheet1 when I put data
in it and change the font/color/bold is it possible to carry that over to
Sheet2
automactically?

Please let me know

Thank You

Kent