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
|