Stop duplication in excel worksheets

Closed
melbournedon - Apr 14, 2011 at 08:38 PM
willowyok Posts 1 Registration date Friday April 15, 2011 Status Member Last seen April 15, 2011 - Apr 15, 2011 at 01:40 PM
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 responses

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 15, 2011 at 12:27 AM
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.
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 15, 2011 at 10:00 AM
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
willowyok Posts 1 Registration date Friday April 15, 2011 Status Member Last seen April 15, 2011
Apr 15, 2011 at 01:40 PM
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.