Creating Repeating Rows in Mulitple Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
 
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
 
Back
Top