Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 180
Default type a sentence so it extends over grids

Hello ... I'm trying to make a schedule in excel and am having a problem
typing info at the bottom of the page. Only part of it is visibile. How can I
type so that the entire sentence appears?
Thanks in advance for your help
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default type a sentence so it extends over grids

Donna,

Text can spill into the next cell if it's empty. And the next, etc. Look for something
(even a space character) in the cell that's stopping it. Also, make sure that the cell
containing the text isn't set for wrap text (Format - Cells - Alignment).

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Donna" wrote in message
...
Hello ... I'm trying to make a schedule in excel and am having a problem
typing info at the bottom of the page. Only part of it is visibile. How can I
type so that the entire sentence appears?
Thanks in advance for your help



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 169
Default type a sentence so it extends over grids

In article , "Earl Kiosterud" wrote:
Donna,

Text can spill into the next cell if it's empty. And the next, etc. Look for
something
(even a space character) in the cell that's stopping it. Also, make sure that
the cell
containing the text isn't set for wrap text (Format - Cells - Alignment).


Also note that XL cells can "only" handle 255 characters. Doesn't sound like
that's your problem ... but in case it is, you can obviously split long text
across more than one cell. :)

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default type a sentence so it extends over grids

xl95 was the last version that only held 255 characters.

xl97-xl2003 holds 32k--about 1k will show up in the worksheet unless the user
does something special.

Bruce Sinclair wrote:

In article , "Earl Kiosterud" wrote:
Donna,

Text can spill into the next cell if it's empty. And the next, etc. Look for
something
(even a space character) in the cell that's stopping it. Also, make sure that
the cell
containing the text isn't set for wrap text (Format - Cells - Alignment).


Also note that XL cells can "only" handle 255 characters. Doesn't sound like
that's your problem ... but in case it is, you can obviously split long text
across more than one cell. :)


--

Dave Peterson
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
CTRL+SHIFT+END extends selection of cells to last - how reset? LisaH Excel Discussion (Misc queries) 9 July 28th 06 01:36 PM
Grids phil2006 Excel Discussion (Misc queries) 1 June 24th 06 04:10 AM
Grids Leonard Excel Worksheet Functions 1 December 7th 05 09:22 PM
Removing grids Zapiszsie Excel Discussion (Misc queries) 2 July 5th 05 08:54 AM
excell worksheet - how do I get the grids to show? Peg Excel Worksheet Functions 3 May 24th 05 12:57 AM


All times are GMT +1. The time now is 11:19 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"