New Line Character in Excel Custom Format

Home Forums Tech Windows New Line Character in Excel Custom Format

This topic contains 2 replies, has 2 voices, and was last updated by  Karl Schmitd 3 years, 11 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #2330

    Karl Schmitd

    Very short:

    One way I found to force a new line into Excel custom format is to press Ctrl+J while typing the format. I will write later more to explain.

    This method has two major disadvantages:


    – Excel doesn’t recalculate the column width;

    – Only the first line of custom format string is visible while editing the format.


    Mr. Mangus

    On I found a very clever suggestion on how to solve the column width problem.

    – Select the cells in question

    – Uncheck Wrap text

    – Check Shrink to fit

    – Check Wrap text once again

    This allows you to narrow the column to a perfect width

    Problem remains for Auto-Resizing rows:

    if you try to Auto-resize rows, your second line of your formatting will be hidden.

    Any suggestion how to fix that?


    Karl Schmitd

    One more trick to enter a multi-line format is to insert “Enter” character:

    “Hold down the Alt key while you press 0010 on the numeric keypad”


Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.