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.
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0
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.
0