| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can the number of words per cell in Excel be increased?
Hi there!
I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can the number of words per cell in Excel be increased?
The limit size of a cell is 32,736 characters although you can only display
up to 256 characters. You can see all the limits using the worksheet help menu under Excel specifications and limits "Joerg" wrote: Hi there! I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can the number of words per cell in Excel be increased?
Hi
There is an excellent addin available from Dr Peter Grebenik which allows you to type 32,000 characters in a cell and view them all. It can be downloaded here http://excelusergroup.org/media/p/2362.aspx -- Regards Roger Govier "Joerg" wrote in message ... Hi there! I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can the number of words per cell in Excel be increased?
Add a linefeed every 100 characters.
100 charsAlt + Enter100 charsAlt + Enter. Gord Dibben MS Excel MVP On Mon, 16 Mar 2009 03:20:02 -0700, Joerg wrote: Hi there! I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can the number of words per cell in Excel be increased?
Joel
If you actually read the help on specs and limits you would find that you can display 1024 characters............not 256. Gord On Mon, 16 Mar 2009 03:39:01 -0700, Joel wrote: The limit size of a cell is 32,736 characters although you can only display up to 256 characters. You can see all the limits using the worksheet help menu under Excel specifications and limits "Joerg" wrote: Hi there! I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can the number of words per cell in Excel be increased?
Joerg wrote:
Hi there! I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg Once the number of words in a cell becomes excessive, one approach is to use a hyperlink to another document, perhaps Notepad, which contains all the information you want to display for that cell. Bill |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can the number of words per cell in Excel be increased?
"Gord Dibben" wrote: Add a linefeed every 100 characters. 100 charsAlt + Enter100 charsAlt + Enter. Gord Dibben MS Excel MVP On Mon, 16 Mar 2009 03:20:02 -0700, Joerg wrote: Hi there! I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can the number of words per cell in Excel be increased?
Can you be more specific with your instructions? I've tried a number of
different combinations and all that happens is a line return, which gives me even less space in the cell. Thanks! "Gord Dibben" wrote: Add a linefeed every 100 characters. 100 charsAlt + Enter100 charsAlt + Enter. Gord Dibben MS Excel MVP On Mon, 16 Mar 2009 03:20:02 -0700, Joerg wrote: Hi there! I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can the number of words per cell in Excel be increased?
Format the cell to wrap text after you have added the linefeeds.
Gord On Thu, 30 Apr 2009 07:27:01 -0700, Pamela wrote: Can you be more specific with your instructions? I've tried a number of different combinations and all that happens is a line return, which gives me even less space in the cell. Thanks! "Gord Dibben" wrote: Add a linefeed every 100 characters. 100 charsAlt + Enter100 charsAlt + Enter. Gord Dibben MS Excel MVP On Mon, 16 Mar 2009 03:20:02 -0700, Joerg wrote: Hi there! I am working on an Excel spread sheet with a lot of text information. There appears to be maximum number of words/characters set for each cell, so that parts of the text information are not displayed. Regardless if I increase the cell size. Any feedback welcome. Many thanks Joerg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert Number into words in EXCEL same or a new cell ? | Excel Worksheet Functions | |||
| Can excel give value in words of number entered in another cell? | Excel Worksheet Functions | |||
| Can the max. number of 65,000 rows in Excel be increased? | Excel Discussion (Misc queries) | |||
| Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
![Joerg[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
