View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default How can I "Shift + Enter" text in Excel?

Just FYI - and maybe to help make life a little easier. It is not necessary
to format the cell first - using alt-enter in a cell automatically turns on
wrap text.

"bj" wrote:

set format-cell-alignment select wrap text
in the cell use alt-enter to start a new line

"NeedHelp" wrote:

I would like to have heading text in bold and then a description directly
underneath(in the same cell).

If I Ctrl + V text from outside Excel that has this layout, it works
perfectly but I want to know how to do this in Excel.

Is this possible? If so, can you give me directions plus the keyboard
shortcut if there is one?