Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two worksheets are linked in the same workbook. Don't want it.
Running Office Excel 2007, I have two worksheets, in the same workbook, that
seem to be linked. Any change I make to ANY cell of sheet 1 is duplicated automatically in the same cell on sheet 2. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
two worksheets are linked in the same workbook. Don't want it.
You most likely have the sheets "grouped". To ungroup them, right-click on
the tab and choose "Ungroup Sheets". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Ray" wrote in message ... Running Office Excel 2007, I have two worksheets, in the same workbook, that seem to be linked. Any change I make to ANY cell of sheet 1 is duplicated automatically in the same cell on sheet 2. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
two worksheets are linked in the same workbook. Don't want it
Thanks Chip,
I have no idea how these sheets got grouped. I did copy and past the contents of sheet1 into sheet2, before I began changing things. Unfortunately, I didn't realize what was happening until I'd overwritten my entire sheet1. Thanks for the help. Any idea how I 'grouped' my worksheets without realizing it? Best regards, Ray "Chip Pearson" wrote: You most likely have the sheets "grouped". To ungroup them, right-click on the tab and choose "Ungroup Sheets". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Ray" wrote in message ... Running Office Excel 2007, I have two worksheets, in the same workbook, that seem to be linked. Any change I make to ANY cell of sheet 1 is duplicated automatically in the same cell on sheet 2. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
two worksheets are linked in the same workbook. Don't want it
To group sheets you can right-click on one sheet tab and "select all sheets".
Also select one sheet then hold SHIFT key and click on last sheet. Also hold CTRL key and select one sheet at a time. You could have used any one of these methods. Gord Dibben MS Excel MVP On Mon, 10 Sep 2007 10:42:00 -0700, Ray wrote: Thanks Chip, I have no idea how these sheets got grouped. I did copy and past the contents of sheet1 into sheet2, before I began changing things. Unfortunately, I didn't realize what was happening until I'd overwritten my entire sheet1. Thanks for the help. Any idea how I 'grouped' my worksheets without realizing it? Best regards, Ray "Chip Pearson" wrote: You most likely have the sheets "grouped". To ungroup them, right-click on the tab and choose "Ungroup Sheets". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Ray" wrote in message ... Running Office Excel 2007, I have two worksheets, in the same workbook, that seem to be linked. Any change I make to ANY cell of sheet 1 is duplicated automatically in the same cell on sheet 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked worksheets | Excel Discussion (Misc queries) | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Linked Worksheets | Excel Worksheet Functions | |||
Linked worksheets in Excel | Excel Discussion (Misc queries) | |||
Linked worksheets | Excel Discussion (Misc queries) |