Menu

type a sentence so it extends over grids

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Posted to microsoft.public.excel.misc

Bruce Sinclair Bruce Sinclair is offline

Bruce Sinclair is offline

external usenet poster

Posts: 169

Default

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:10 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement