Professor Excel

Comments 6

  1. Aidan


    I’m getting inconsistent results with this. I have multiple spreadsheets with line breaks. I’ve also created a few with line breaks myself, for testing.

    But the Ctrl+H function only finds some of them. It completely misses others. What might cause this? Could it be that something looks like a line break but is really something else?

    Thanks and regards,

    Aidan Sweeney

    • Henrik Schiffner

      Hi Aidan,

      sometimes people use a lot of space characters in order to achieve line breaks.
      If that’s not the case, can you try to copy the “line breaks” and search/ replace them?

      Best regards,

  2. Kåre Vergmann


    Nice article. Do you by chance, know how to insert a linebreak, where the cursor is positioned, just by using ENTER (and not ALT+ENTER).
    I know you have to use some vba-code, but I don’t succeed (Application.onkey and sendkey methods). Should you use the DLLs maybee?

    Regards Kåre

  3. Nelson

    Is it possible to use the conditional formatting when using a line break in its formula? I have a cell where the drop-down value is based on a text with a line break in it. How can I use the conditional formatting to recognize it? Thanks.

  4. A. Guy

    Ctrl-J does not work on Excel for Mac. Does anyone knows what’s the equivalent? Cmd-J is not the equivalent. It does nothing.

Leave a comment

%d bloggers like this: