When data are entered in a cell and formatting is applied to a cell in one worksheet in a group, the corresponding cells in the other grouped worksheets also receive the data and formatting.

Question

Quizplus · Accepted Answer

This is the default setting when worksheets are grouped in Excel. Any changes made to a cell in one grouped worksheet will automatically affect the corresponding cells in the other grouped worksheets. However, this feature can be turned off or modified by adjusting the settings for the grouped worksheets.

When Data Are Entered in a Cell and Formatting Is