Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visibility of contents in a merged cell
Hi
First I explain below what I did; I merged cells from a1 to e17. Formatting : Left, Top and yes for wrapping. Then I kept key 'i' until the cell got filled up. The problems(2) First when I click the merged cell I am not able to view the full cell contents. Accidently only I was able to ascertain the characters after the 1050th character can only be viewed by going into the cell. Cannot I change this? The other problem is just like in this message box I want to move onto the next lines in the merged cell by pressing enter or by pressing some other key. I like my merged cell to behave just like ms word or this message box. Could any one solve my problems? Many Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visibility of contents in a merged cell
You can enter 32767 characters in a cell but by default only 1024 of these
characters will show or print. Merging many cells into one large cell does not make the cell characteristics any different than a single cell. Just makes it look larger but has the same constraints. Find a different method like using a textbox. Gord Dibben MS Excel MVP On Tue, 15 May 2007 11:30:00 -0700, Varne wrote: Hi First I explain below what I did; I merged cells from a1 to e17. Formatting : Left, Top and yes for wrapping. Then I kept key 'i' until the cell got filled up. The problems(2) First when I click the merged cell I am not able to view the full cell contents. Accidently only I was able to ascertain the characters after the 1050th character can only be viewed by going into the cell. Cannot I change this? The other problem is just like in this message box I want to move onto the next lines in the merged cell by pressing enter or by pressing some other key. I like my merged cell to behave just like ms word or this message box. Could any one solve my problems? Many Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visibility of contents in a merged cell
Gord Dibben
Hi Cannot the default setting be reset to say 10000 characters? If so how? Regards Varne "Gord Dibben" wrote: You can enter 32767 characters in a cell but by default only 1024 of these characters will show or print. Merging many cells into one large cell does not make the cell characteristics any different than a single cell. Just makes it look larger but has the same constraints. Find a different method like using a textbox. Gord Dibben MS Excel MVP On Tue, 15 May 2007 11:30:00 -0700, Varne wrote: Hi First I explain below what I did; I merged cells from a1 to e17. Formatting : Left, Top and yes for wrapping. Then I kept key 'i' until the cell got filled up. The problems(2) First when I click the merged cell I am not able to view the full cell contents. Accidently only I was able to ascertain the characters after the 1050th character can only be viewed by going into the cell. Cannot I change this? The other problem is just like in this message box I want to move onto the next lines in the merged cell by pressing enter or by pressing some other key. I like my merged cell to behave just like ms word or this message box. Could any one solve my problems? Many Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visibility of contents in a merged cell
The default is 1024 and cannot be reset but there are workarounds like adding an
Alt + Enter every 100 chars. And formatting tricks. See Harlan's response at this thread. http://snipurl.com/1kqre Gord Dibben MS Excel MVP On Tue, 15 May 2007 12:21:02 -0700, Varne wrote: Gord Dibben Hi Cannot the default setting be reset to say 10000 characters? If so how? Regards Varne "Gord Dibben" wrote: You can enter 32767 characters in a cell but by default only 1024 of these characters will show or print. Merging many cells into one large cell does not make the cell characteristics any different than a single cell. Just makes it look larger but has the same constraints. Find a different method like using a textbox. Gord Dibben MS Excel MVP On Tue, 15 May 2007 11:30:00 -0700, Varne wrote: Hi First I explain below what I did; I merged cells from a1 to e17. Formatting : Left, Top and yes for wrapping. Then I kept key 'i' until the cell got filled up. The problems(2) First when I click the merged cell I am not able to view the full cell contents. Accidently only I was able to ascertain the characters after the 1050th character can only be viewed by going into the cell. Cannot I change this? The other problem is just like in this message box I want to move onto the next lines in the merged cell by pressing enter or by pressing some other key. I like my merged cell to behave just like ms word or this message box. Could any one solve my problems? Many Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visibility of contents in a merged cell
Gord Dibben
Hi Yes. Alt + Enter definitly helped. Thanks. But as you say the restriction on my project can be alleviated by using a text box. I know how to link a text box with a cell content. But not the other way around. Let me explain. I will enter text onto a text box. I need a macro to post that onto a particular cell. The macro I tried just did that but if I enter different text the macro is not adapting. It writes the old text again into the cell. I am at it. if you do not mind please tell me where I am going wrong. Again many thanks. You have given a solution to my original problem. Regards M Varnendra "Gord Dibben" wrote: The default is 1024 and cannot be reset but there are workarounds like adding an Alt + Enter every 100 chars. And formatting tricks. See Harlan's response at this thread. http://snipurl.com/1kqre Gord Dibben MS Excel MVP On Tue, 15 May 2007 12:21:02 -0700, Varne wrote: Gord Dibben Hi Cannot the default setting be reset to say 10000 characters? If so how? Regards Varne "Gord Dibben" wrote: You can enter 32767 characters in a cell but by default only 1024 of these characters will show or print. Merging many cells into one large cell does not make the cell characteristics any different than a single cell. Just makes it look larger but has the same constraints. Find a different method like using a textbox. Gord Dibben MS Excel MVP On Tue, 15 May 2007 11:30:00 -0700, Varne wrote: Hi First I explain below what I did; I merged cells from a1 to e17. Formatting : Left, Top and yes for wrapping. Then I kept key 'i' until the cell got filled up. The problems(2) First when I click the merged cell I am not able to view the full cell contents. Accidently only I was able to ascertain the characters after the 1050th character can only be viewed by going into the cell. Cannot I change this? The other problem is just like in this message box I want to move onto the next lines in the merged cell by pressing enter or by pressing some other key. I like my merged cell to behave just like ms word or this message box. Could any one solve my problems? Many Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Very Basic Problem - Merged Cell Equals Contents of a Single Cell | Excel Worksheet Functions | |||
Visibility of active cell. | Excel Discussion (Misc queries) | |||
Clearing the Contents of Merged Cells | New Users to Excel | |||
Clearing the contents of merged cells | Excel Programming |