Font Attributes

[Kent]

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

 

[Erin]

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.

 

[CLR]

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]

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

 

[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