When you work with files that consist of several sheets and forget to ungroup the sheets whereas the data which must be filled is different, there will be some sheets which are filled by the improperly data. So you need to ungroup the sheets first and then you can fill in the sheets by data that you want.
How to Group Worksheets in Excel
How to Group Worksheets in Excel
You can group together all or some of the worksheets in a Microsoft Excel workbook. The advantage of forming worksheet groups is that you can format the worksheets all at the same time. Keep reading to find out how you can use this time-saving feature of grouping worksheets in Excel.
