Make Cell behave Like Word

[Ian8276]

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

 

[Peo Sjoblom]

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

 

[Gord Dibben]

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

That's about it.


Gord Dibben MS Excel MVP