How can I group formating, not data on worksheets?

[Guest]

Lotus has a function that allows you to group worksheets in a manner that the
cursor goes to the same place in every worksheet that is grouped together and
any formatting applies to every worksheet, but not the data. Once you group
worksheets, you can move around in all worksheets and the grouping stays.
Does Excel have that function?

 

[Richard O. Neville]

You can do this with worksheets within a workbook. Click on the first sheet
tab you want to format, then use Ctrl-click to select any others that will
share the formatting. A formatting change to cell B2 of any of the grouped
worksheets will also show up in B2 of the others. And, of course, you can
select more than one cell at a time to format.

If you want to select all the worksheets, right-click on any of them and
choose Select All Sheets. Be sure to ungroup them after you have made the
format changes.

 

[Guest]

You can do this with worksheets within a workbook. Click on the first sheet
tab you want to format, then use Ctrl-click to select any others that will
share the formatting. A formatting change to cell B2 of any of the grouped
worksheets will also show up in B2 of the others. And, of course, you can
select more than one cell at a time to format.

If you want to select all the worksheets, right-click on any of them and
choose Select All Sheets. Be sure to ungroup them after you have made the
format changes.




Thanks for the reply. I don't want to have to ungroup the sheets. I want to be able to insert a column or row without having to group sheets. Also, in Lotus, when the sheets are grouped, the data is exclusive to each sheet, but the formatting carries through. Such as inserting/deleting rows or columns, changing fonts, formatting, etc. and the cursor goes to the same place in each sheet when you change from one sheet to another. Any help with this?

Thanks