Automatically set the height of a line for wrap text

Page updated :

Overview

Describes how to automatically adjust the height of a row of text in a cell when it is displayed in a wrap view.

折り返しテキストに対して行の高さを自動的に設定する

Confirmed version of the operation

Supported Excel version

  • 2007

Make sure Excel version

  • 2007

Contents

隣のセルにテキストがはみ出る

If you type more text in a cell than the column width, the text is displayed beyond the next cell by default.

折り返して全体を表示する

If you want the text to wrap without going beyond the next cell, click the Wrap to Whole button from the Home tab to activate it.

テキストが折り返され、行の高さが自動的に設定される

The text will then wrap and appear as shown on the right. The height of the line is also automatically set by the number of lines of text that have been folded.

セルの書式設定

By the way, the folding setting is also possible in another way.

Right-click the cell and choose Format Cells from the menu.

配置 - 折り返して全体を表示する

Select the Alignment tab from the dialog that appears and check Wrap to Show Whole.

行の高さを手動で設定する

When you wrap text, the height of the line is automatically adjusted so that you can see the entire text, but you can change the height of the line by dragging the line boundary, as shown on the right.

行の高さが自動で設定されなくなる

However, once you change the height of a line, changing the text does not automatically adjust the height of the line.

ホーム 行の高さの自動調整

If you want to automatically adjust the height of a row, first select the row. Then select the Home tab, click Format, then choose Auto-Adjust Row Height from the menu.

テキストの折り返し行数によって行の高さが自動調整される

Then, the height of the line is automatically adjusted according to the number of lines that the text wraps.