Does anyone know how to make an Excel cell behave like a word document? I
like to create a spread sheet that will allow me to space by pressing enter
and to press tab without going outside the cell.
Thanks,


Ian8276
--
Hello

Alt + enter adds a new line in the same cell if that was what you wanted, it
doesn't add a space though and I don't think Word does either. If you select
transition navigation keys under tools transition then you can tab between
strings within the same cell. It will affect the way you navigate
in other ways though, once you are out of edit mode it will skip a whole
screen.
--


Regards,


Peo Sjoblom


"Ian8276" wrote in message
...
Does anyone know how to make an Excel cell behave like a word document? I
like to create a spread sheet that will allow me to space by pressing
enter
and to press tab without going outside the cell.
Thanks,


Ian8276
--
Hello

In Excel you can hit Alt + Enter to create a linefeed in a cell.

That's about it.


Gord Dibben MS Excel MVP


On Mon, 26 Nov 2007 14:31:00 -0800, Ian8276 wrote:

Does anyone know how to make an Excel cell behave like a word document? I
like to create a spread sheet that will allow me to space by pressing enter
and to press tab without going outside the cell.
Thanks,


Ian8276