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

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

Hold down Ctrl and Shift and highlight both sheet tabs........then do the
formatting.....it will take on both sheets


Vaya con Dios,
Chuck, CABGx3


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

Hello,

Thank you very much for your response. I tried that and it works great.

But how would I have the data that I put in cell A1 on Sheet 1
be automactically entered in C3 on Sheet 2 with all the font attributes?

Thank You
Kent


"Erin" wrote:

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

Hello,

This does not work when the columns and rows are different.
Any idea on how to do this with them being different?

Thank You
Kent

"CLR" wrote:

Hold down Ctrl and Shift and highlight both sheet tabs........then do the
formatting.....it will take on both sheets


Vaya con Dios,
Chuck, CABGx3


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