Stop duplication in excel worksheets

[Closed]
Report
-
Posts
1
Registration date
Friday April 15, 2011
Status
Member
Last seen
April 15, 2011
-
Hello,

I have set up a workbook with multifple worksheets. Each worksheet will have different data. I created each worksheet from a copy of the original worksheet. When I enter data in the first worksheet, the same data appears in all other worksheets. Why is this happening and how can I stop this from happening?

3 replies

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
this happans because either all sheets are selected or = formula are in all sheet.

Please check the same and revert back if problem is still unsolved.
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Melbournedon,

To clear your worksheet, click on the square to the left of the A of column A and to the top of 1 of row 1 and then hit delete.

This can also be done by selecting a cell and hitting Ctrl+A.

But why copy an existing sheet with data when you need an empty sheet?

Best regards,
Trowa
Posts
1
Registration date
Friday April 15, 2011
Status
Member
Last seen
April 15, 2011

It is not work the excel sheet. you can upgrade the software of office. You can change the setting and open a new file and check the particular options.