How can I group formating, not data on worksheets?
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.
"Lana" wrote in message
...
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?
|