ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stop from duplicating entries on multiptle sheets (https://www.excelbanter.com/excel-discussion-misc-queries/74361-stop-duplicating-entries-multiptle-sheets.html)

Myhand

Stop from duplicating entries on multiptle sheets
 
We have created a calender of events for each month and it is duplicating
Holidays and such from one entry to all the sheets. Not sure what or how it
was set to this mode (Shortcut) how do we stop it.

Duke Carey

Stop from duplicating entries on multiptle sheets
 
It sounds as though you have all the sheets selected, so that whatever is
entered on one gets entered on all.

Right-click the sheet tabs at the bottom and choose Ungroup


"Myhand" wrote:

We have created a calender of events for each month and it is duplicating
Holidays and such from one entry to all the sheets. Not sure what or how it
was set to this mode (Shortcut) how do we stop it.



All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com