Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Repeating Rows in Mulitple Worksheets
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Repeating Rows in Mulitple Worksheets
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging data from mulitple worksheets | Excel Worksheet Functions | |||
How do I sum totals from mulitple worksheets | Excel Worksheet Functions | |||
mulitple worksheets vlookup | Excel Discussion (Misc queries) | |||
Repeating a formula across mulitple columns | Excel Worksheet Functions | |||
Changes to Mulitple Worksheets | Excel Worksheet Functions |