You might copy and paste a lot when you do the same operation
to several sheets. To avoid the unnecessary work, you can use these
features that can be applied to multiple sheets through one operation
both in Microsoft® Excel
2003 and IBM® Lotus® Symphony™ Spreadsheets.
After you select the sheets, the following features can
be applied:
- When you enter data in one of the sheets, the data is automatically
entered in all sheets.
- When you set the cell properties in one of the sheets, such as
the font size, the font name and the font color, the properties are
also applied to the same cells of other sheets.
- When you set the page properties to one of the sheets, the properties
are applied to all sheets.
- When you enter a formula in one of the sheets, the same formula
is entered in all sheets.