View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Matthew[_2_] Matthew[_2_] is offline
external usenet poster
 
Posts: 54
Default Creating Repeating Rows in Mulitple Worksheets

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