Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disappearing info in merged cells - Excel
I created a document that had merged cells. After saving my document several
times, info that was placed in merged cells kept disappearing. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disappearing info in merged cells - Excel
Nora
I will assume you know that if you data in 4 cells then merge those cells only the data in top left cell will remain after merging. So, I guess that leaves us with data disappearing from cells you have merged previously and added/changed within. I cannot replicate this behaviour unless I enter more than 1024 characters in the merged cell. Excel treats multiple cells merged to 1 as a single cell. Excel allows 32,767 characters in a cell but only 1024 characters will be visible or can be printed. One way to overcome this limit is to place an ALT + ENTER every now again to stretch the visible limit. Gord Dibben Excel MVP On Tue, 22 Nov 2005 10:29:03 -0800, "Nora" wrote: I created a document that had merged cells. After saving my document several times, info that was placed in merged cells kept disappearing. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How locate merged cells in Excel | Excel Discussion (Misc queries) | |||
why can't i enter text into merged cells in excel | Excel Worksheet Functions | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |