Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I view ALL Text in a cell

I have one spreadsheet that will not allow me to see all the text. I need to
change the format, so that as I type it is still visible. Currently I have
an alotted number of characters and when I pass that amount the certain
number of characters are the only ones I see in the cell, but in the formula
bar I see the full amount. Anyone help?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default How do I view ALL Text in a cell

The following limitations apply to worksheet entries:

32,767 characters per cell
Only 1,024 display in a cell
All 32,767 display in the formula bar.

You can squeeze some additional display characters beyond the 1,024 by
manually inserting line breaks by pressing <Alt + Enter at each point in
the text where you want to insert a new line.
--
Kevin Backmann


"tarat76" wrote:

I have one spreadsheet that will not allow me to see all the text. I need to
change the format, so that as I type it is still visible. Currently I have
an alotted number of characters and when I pass that amount the certain
number of characters are the only ones I see in the cell, but in the formula
bar I see the full amount. Anyone help?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How do I view ALL Text in a cell

You can enter 32767 characters in a cell but the cell will display only 1024
of these.

The formula bar will display all.

To have more display in the cell use Alt + Enter every 100 characters to
introduce an in-cell linefeed.


Gord Dibben MS Excel MVP


On Mon, 29 Sep 2008 13:37:02 -0700, tarat76
wrote:

I have one spreadsheet that will not allow me to see all the text. I need to
change the format, so that as I type it is still visible. Currently I have
an alotted number of characters and when I pass that amount the certain
number of characters are the only ones I see in the cell, but in the formula
bar I see the full amount. Anyone help?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default How do I view ALL Text in a cell

Hi,

Kevin and Gord both said it! However, in 2007 you can see more characters
in the spreadsheet - 32,768

In 2003 you can see the content of the cell displayed in an object such as a
rectangle. It can show the full 32,768 but of course that is within the
object which sometimes is a solution - if you need to print the contents.

--
Thanks,
Shane Devenshire


"tarat76" wrote:

I have one spreadsheet that will not allow me to see all the text. I need to
change the format, so that as I type it is still visible. Currently I have
an alotted number of characters and when I pass that amount the certain
number of characters are the only ones I see in the cell, but in the formula
bar I see the full amount. Anyone help?

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
Can't view all text in a cell Jackie Excel Worksheet Functions 2 July 16th 08 07:19 PM
I CANT VIEW CELL/TEXT COLOR UNLESS IN PRINT PREVIEW truckergirl Excel Worksheet Functions 1 September 4th 07 03:45 PM
How do I view all text in a merged cell? Wrap text is activated. susjorg Excel Discussion (Misc queries) 1 January 23rd 07 08:34 PM
How do I view cell text without it visually hiding other cells? ldmci Excel Discussion (Misc queries) 1 May 27th 05 04:12 PM
cannot view all of text in large cell, even though I have it to w. sydme Excel Discussion (Misc queries) 1 December 27th 04 04:26 PM


All times are GMT +1. The time now is 11:37 AM.

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"