ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   type a sentence so it extends over grids (https://www.excelbanter.com/excel-discussion-misc-queries/147150-type-sentence-so-extends-over-grids.html)

Donna

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

Earl Kiosterud

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




Bruce Sinclair

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. :)


Dave Peterson

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

Bruce Sinclair

type a sentence so it extends over grids
 
In article , wrote:
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.


Oops ! Thanks for the correction. :)
I admit, I have never tried it ... and I also admit I can't imagine why
anyone would want to put that much text into a single spreadsheet cell. :)

Thanks again.

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. :)




All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com