#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Text in a cell

I am putting a lot of text into a cell, but all of my text will not show.
The text is wrapped and I have clicked on Row Auto-fit, but I still cannot
see all of my text. I have even manually made the row bigger and it still
will not fit. Is there a certain character limit for a cell or is there
something else I'm just not doing?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Text in a cell

hi
cells can contain 32736 characters but only 1024 show in the cell. the rest
show in the formula bar.
in excel help type the word specifications for specs and limits on your
version of excel.
see this site for 2007 specs
http://office.microsoft.com/en-us/ex....aspx?pid=CH10

regards
FSt1

"angikb" wrote:

I am putting a lot of text into a cell, but all of my text will not show.
The text is wrapped and I have clicked on Row Auto-fit, but I still cannot
see all of my text. I have even manually made the row bigger and it still
will not fit. Is there a certain character limit for a cell or is there
something else I'm just not doing?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Text in a cell

As an addendum to FSt1's comment, you might be able to see more than 32,736
characters by inserting manual line breaks instead of having the cell word
wrap.

To insert a manual line break move to the position on the line where you
want to break to the next line and press <Alt + <Enter


--
Kevin Backmann


"angikb" wrote:

I am putting a lot of text into a cell, but all of my text will not show.
The text is wrapped and I have clicked on Row Auto-fit, but I still cannot
see all of my text. I have even manually made the row bigger and it still
will not fit. Is there a certain character limit for a cell or is there
something else I'm just not doing?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter text in a cell to return a text value in same cell Danno 24/7[_2_] Excel Discussion (Misc queries) 6 May 9th 08 06:26 AM
Find text in a cell and copy text to another cell Shaun Excel Discussion (Misc queries) 6 July 4th 07 05:25 PM
Copy text from cell to cell with one cell changing text Bobby Excel Worksheet Functions 5 March 15th 07 11:09 PM
linking a cell containing text to another cell containing text / data gin2000 Excel Discussion (Misc queries) 5 May 19th 06 09:08 PM
New text added to cell AFTER current text in same cell choc_penguin Excel Worksheet Functions 2 April 11th 06 08:23 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"