Make Cell behave Like Word

  • Thread starter Thread starter Ian8276
  • Start date Start date
I

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
 
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
 
In Excel you can hit Alt + Enter to create a linefeed in a cell.

That's about it.


Gord Dibben MS Excel MVP
 
Back
Top