ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   If you delete the contents of a cell in a worksheet in a group, w (https://www.excelbanter.com/excel-discussion-misc-queries/91038-if-you-delete-contents-cell-worksheet-group-w.html)

jmfadg5

If you delete the contents of a cell in a worksheet in a group, w
 
If you delete the contents of a cell in a worksheet in a group, the contents
in the same cell in each worksheet, what will happen to cells in the other
worksheets?

C01d

If you delete the contents of a cell in a worksheet in a group, w
 

The way a worksheet group works is such that whatever actions you
perform on one sheet within the group will be reflected in other
sheets.

In your case, suppose you delete the contents of Cell A6, all others
sheets in the group will have the contents in cell A6 deleted as well.
You can overcome this by ungrouping the sheets, making changes to
individual sheets and regrouping them.


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=546358



All times are GMT +1. The time now is 12:53 PM.

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