Thanks Matthew for the tip. However, I cannot added anything from
Autoshapes, using the method as you suggested. The Autoshapes is all greyed
out when I group the sheets together. Do you have any suggestion?

Thanks again,

Patricia

"Matthew" wrote:

On 10 Oct, 18:01, Fuel Cells for the Future <Fuel Cells for the
wrote:
Hello:

I need to view the same rows that has a combination of formatted cells
(shaded, merged cells), text, and shapes in mulitple worksheets. Currently,
I am copying and pasting these rows into the mulitple worksheets. I am
looking for a way to do this, so that when I make a changes to these rows, I
can do this in one place, and I am able to view this changes in the mulitple
worksheets - without having to copy and paste in every worksheet. I would
really appreciate your input!

Thanks,

Patricia

Patricia,

If I read this correctly, you want to format multiple sheets in one
go, if so then 'group' the sheets together by clicking the tab whilst
holding shift or ctrl and any change you make in one sheet will affect
the rest.

Matthew