Volumes of Text in a single cell

[Guest]

I appologise if this has been covered before, or that it is really basic. I
am new to Excel and new to this forum!!

Here it is:
After I have pasted large volumes of text (say 2 or 3 paragraphs) in to a
single cell, sometimes the final lines of the last 2 paragraphs run out of
the cell and becomes invisible. Sometimes the entire final paragraph runs
off, on one line.

I have toggled the "Wrap Text" function;
I have put the text into Word to clear formatting and/or paragraph marks to then repaste into Excel

- But I am still having problems.

The only way to get over this is to put new paragraph marks in place (using
the ALT + ENT buttons) at each point Excel causes the run off. However if I
want to resize the column for whatever reason at a later point - there are
then too many paragraph marks!!

Your help is greatly appreciated!!

 

[Peter G]

I have written an Excel addin for dealing with cells containing long
text strings. It contains a simple cell viewer/editor to allow you to
read and edit the content of a cell.

You can download it from
http://wwwusers.brookes.ac.uk/p0054663/PDGExcelUtils.xla

Once it is installed just use the Escape key to start the cell text
edit form.

Peter Grebenik

 

[Harlan Grove]

I have written an Excel addin for dealing with cells containing long
text strings. It contains a simple cell viewer/editor to allow you to
read and edit the content of a cell.

You can download it from
http://wwwusers.brookes.ac.uk/p0054663/PDGExcelUtils.xla

Once it is installed just use the Escape key to start the cell text
edit form.

Do you make it easy to change this key binding? Does this disable the Escape
key from performing its default actions?