| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| Delete all contents of cell but one word | Excel Discussion (Misc queries) | |||
| VBA Excel Macro to delete contents in named cell | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
