Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot merge or unmerge cells in Excel
I am working in a spreadsheet/workbook that I created and for the life of me
cannot figure out what the problem is here. I can't unmerge/split cells that are merged (nothing works) nor can I merge cells that I want to be merged. I've never run into this before and I'm at a complete loss as to what could be causing this. The workbook is shared across our company network, but even when I'm the only one using it, it's still a problem. Can anybody help?? I would be most appreciative because I don't have time to monkey around with this or continue searching online for an answer. Thanks so much in advance! Best, Tara |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot merge or unmerge cells in Excel
There's the clue to your problem "The workbook is shared across our company"
If you look in the helpfile under the heading "Features that are unavailable in shared workbooks" you'll find that item 4 mentions merged cells. The only way to change the cells is to unshare the worksheet, do your modifications then reshare it again. "Tara" wrote: I am working in a spreadsheet/workbook that I created and for the life of me cannot figure out what the problem is here. I can't unmerge/split cells that are merged (nothing works) nor can I merge cells that I want to be merged. I've never run into this before and I'm at a complete loss as to what could be causing this. The workbook is shared across our company network, but even when I'm the only one using it, it's still a problem. Can anybody help?? I would be most appreciative because I don't have time to monkey around with this or continue searching online for an answer. Thanks so much in advance! Best, Tara |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot merge or unmerge cells in Excel
Thank you so much bigwheel! I thought about giving that a try while I was
troubleshooting...just as a guess as to the problem...but didn't because I was frustrated and just needed an answer. Thanks again for your help! "bigwheel" wrote: There's the clue to your problem "The workbook is shared across our company" If you look in the helpfile under the heading "Features that are unavailable in shared workbooks" you'll find that item 4 mentions merged cells. The only way to change the cells is to unshare the worksheet, do your modifications then reshare it again. "Tara" wrote: I am working in a spreadsheet/workbook that I created and for the life of me cannot figure out what the problem is here. I can't unmerge/split cells that are merged (nothing works) nor can I merge cells that I want to be merged. I've never run into this before and I'm at a complete loss as to what could be causing this. The workbook is shared across our company network, but even when I'm the only one using it, it's still a problem. Can anybody help?? I would be most appreciative because I don't have time to monkey around with this or continue searching online for an answer. Thanks so much in advance! Best, Tara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Excel Docs | Excel Discussion (Misc queries) | |||
Maintain proper links when Excel cells are moved | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) |