A normal Excel sheet has cells that are 8.43 points in width and 15 points in height. This is usually about 64 pixels wide và 20 pixels tall.

Bạn đang xem: Ms excel 2016: wrap text in a cell

If your text data is long, you can increase the cell width to fit the data length.

A better option might be khổng lồ wrap the text to lớn increase the row height so the data fits in the cell instead!

In this post you’ll learn 3 ways to lớn wrap your text data to fit it inside the cell.

What is Text Wrap?

This means that if text is too long khổng lồ fit inside its cell, it will automatically adjust to appear on multiple lines within the cell.

The data inside the cell will not change & no line break characters will be inserted. It will only appear khổng lồ be formatted on multiple lines.


*

The above example you can see the text inside cell B2 extends well past the width of the cell and spills over cell khổng lồ the right.


*

After the cell has had wrap text applied, you can see the row height has been adjusted to fit all the text.

Wrap Text from Ribbon

This is a very common action, so it can be found in the Home tab of the ribbon commands.


*

*

*

Wrap your text.

Select the cell or range of cells to lớn which you want khổng lồ apply the wrap text formatting.Go to the Home tab.Press the Wrap Text command found in the Alignment section.

This will apply the formatting khổng lồ your cells!

It’s a good idea lớn adjust the width of your cells khổng lồ the desired kích cỡ first as the height of the rows will be adjusted so all the text fits inside the cell.

Wrap Text Keyboard Shortcut

There is no dedicated keyboard shortcut for the wrap text formatting, but you can still use the Alt hotkeys for this.


Select the cells to which you want to apply wrap text then press AltHW.

Certainly a quick and easy way lớn apply the formatting.

Wrap Text in the Format Cells Dialog Box

The format cells dialog box contains all the formatting options you can apply lớn a cell in your spreadsheet, including the wrap text option.


You can open this menu with a right click on the cells then choose Format Cells or by using the Ctrl + 1 keyboard shortcut.

Go to the Alignment tab in the thực đơn ➜ kiểm tra the Wrap text option in the Text control section ➜ then press the OK button.


This is a great option when you want to apply wrap text and other formatting options at the same time.

Automatically Adjust Row Height to Fit Text


If your row height does not properly adjust lớn fit all the text and is either too small or too big, then you will need khổng lồ adjust it.

You can bởi this manually by clicking & dragging the row but there is an easy option lớn auto-adjust the height.

Xem thêm: Những Ảnh Chữ Đẹp Về Tình Yêu Đầy Tâm Trạng Cho Người Đang Yêu Hạnh Phúc Có Chữ


Go to lớn the Home tab ➜ select the Format options ➜ then select AutoFit Row Height from the menu. You can also bởi vì this by double clicking on the edge of the row heading.

The row height will adjust lớn the exact height needed khổng lồ show all the text.

Manually địa chỉ Line Breaks to Wrap Your Text

The wrap text option will automatically format your text with line breaks based on the available width of the cell.

If you want khổng lồ choose where the line breaks appear, then you can vày this by manually adding line break characters to lớn your text data.


Place the cursor in the text at the point where you want to địa chỉ a line break then hold the Alt key and press Enter.

This will showroom a line break character into your text data and the data will appear on multiple lines in the sheet.

Remove Wrap Text


It’s just as easy to lớn remove wrap text formatting as it is to apply it in the first place.

Remove Formatting

Select the cells from which you want to lớn remove the formatting & then perform any of these methods.

Go lớn the Home tab và press the Wrap Text command.Open the Format Cells menu and uncheck the Wrap text option in the Alignment tab.Use the AltHW keyboard shortcut.

The exact same commands used to lớn apply the formatting can be used lớn remove the formatting as well!

Remove Manually Added Line Breaks

If you’ve manually added line break characters to lớn your text lớn achieve a wrapping effect, then you will need lớn remove them using a find & replace method.


Press Ctrl + H to xuất hiện the find & replace dialog box.

Place the cursor in the Find what section & press Ctrl + J to add a line break character. Leave the Replace with section empty and then press the Replace All button.

This will replace all the line break character that you manually added by nothing thereby removing them.

Conclusions

Wrapping text is a great option for styling your spreadsheets & making them more readable.

It’s great too, because it’s very easy to do.

What’s your favourite method? Let me know in the comments!


About the Author


John MacDougall


John is a Microsoft MVP & qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, và most recently nguồn Platform consulting. He is a keen problem solver và has a passion for using giải pháp công nghệ to make businesses more efficient.
Subscribe

Related Posts


Browse All
7 Ways to Rename a Sheet in Microsoft Excel

Sep 25, 2021


Keeping your spreadsheet organized is important! A well organized spreadsheet...


read more
8 Ways to lớn Merge Cells in Microsoft Excel

Sep 8, 2021


Merged cells are one of the most popular options used by beginner spreadsheet...


read more
6 Ways to Count Colored Cells in Microsoft Excel

Sep 7, 2021


You have probably used màu sắc coding in your Excel data or seen it in a...


read more

Comments


1 Comment


My best method is the keyboard shortcut. Thank you for sharing.


Get the Latest Microsoft Excel Tips


Follow Us

Follow us on social truyền thông to stay up to lớn date with the latest in Microsoft Excel!