文本溢出(Text overflow)可能会破坏电子表格的外观,因为从单元格中溢出的文本可能看起来很尴尬。如果您有一个存在此问题的电子表格,您可以修复Microsoft Excel中的文本溢出问题,使其看起来更好、更干净。
什么是Microsoft Excel中的文本溢出(Microsoft Excel)
顾名思义,如果文本超出单元格,则称为文本溢出。单元格的默认宽度可能并不总是符合整个文本的宽度。Excel单元格的默认宽度是 8.43mm,这是最小的,大多数人经常会遇到问题。在这样的时刻,文本被右侧的单元格隐藏,一旦完成编辑就无法阅读。
无论(Whichever)您使用的是哪个版本的Microsoft Office,您都可以在每个Excel电子表格中遇到相同的问题。此外,Excel Online也会发生这种情况。有几种方法可以处理这个问题。但是,您应该知道,每种方法都可以让您一次增加整列的宽度。如果一列中有十个单元格,并且您尝试增加第一个单元格的宽度,则相同的内容将应用于整个列,而不仅仅是一个单元格。
如何在Excel中停止或隐藏(Excel)文本溢出(Text Overflow)
要修复Microsoft Excel中的文本溢出问题,请遵循以下建议-
- 手动增加列宽
- 使用自动调整列宽选项
- 更改单元格的默认宽度
要详细了解这些步骤,请继续阅读。
1 ] 手动(] Manually)增加一列的宽度
这可能是摆脱这个问题的最简单方法。虽然这是一种老派的方法,但效果很好。无论单元格的宽度是 10 毫米还是 100 毫米,您都可以手动更改,无需任何专业知识。首先,打开电子表格,将鼠标悬停在分隔两列的线上。您应该看到一个双向箭头。一旦你得到它,单击并按住鼠标并向右侧拖动。
2]使用(Use)自动调整列宽(AutoFit Column Width)选项
这是一个方便的选项,可让您自动设置列的宽度。它检测单元格的最大宽度并将其应用于整个列。您不需要使用鼠标拖动方法。这个技巧的好处是你可以一次增加所有列的宽度。要开始,请选择所有需要更改的列,然后单击“格式(Format )”菜单,该菜单应在“主页”(Home )选项卡中可见。之后,单击AutoFit Column Width选项。
应立即更改宽度。
3]更改(Change)单元格/列的默认宽度
如果您已经确切知道需要多少宽度,则可以更改列的默认宽度。为此,在 Excel 中打开格式菜单并选择(Format)默认宽度(Default Width )选项。现在,您需要选择一个宽度。
默认情况下,它应该带有毫米单位,这是Excel的默认单位。如果您之前更改了它,则需要相应地设置宽度。
我希望这个简单的教程能帮助您解决Microsoft Excel中的文本溢出问题。
How to stop or hide Text Overflow in Excel
Text overflow can break the appearance of a spreadsheet as it might look awkward with overflowing texts coming out of a cell. If you have a spreadsheet with this problem, you can fix the text-overflow issue in Microsoft Excel so that it looks better and clean.
What is text overflow in Microsoft Excel
As the name defines, if the text is going outside of a cell, it is called text-overflow. The default width of a cell might not always be complying with the width of the whole text. The default width of an Excel cell is 8.43mm, which is minimal, and most of the people often get problems. At such a moment, the text gets hidden by the right-side cell, and it is not accessible for reading once you are done with the editing.
Whichever version of Microsoft Office you are using, you can get the same issue in every Excel spreadsheet. Also, it happens with Excel Online too. There are several ways to deal with this issue. However, you should know that every method lets you increase the width of the whole column at once. If there are ten cells in a column and you try to increase the width of the first cell, the same will be applied on the whole column – not just one cell.
How to stop or hide Text Overflow in Excel
To fix the text-overflow problem in Microsoft Excel, follow these suggestions-
- Manually increase the width of a column
- Use the AutoFit Column Width option
- Change the default width of a cell
To know the steps in detail, keep reading.
1] Manually increase the width of a column
It is probably the easiest way to get rid of this problem. Although it is an old-school method, it works perfectly. No matter if the width of a cell should be 10mm or 100mm, you can change it manually without any expert knowledge. At first, open the spreadsheet, and hover your mouse over the line that divided two columns. You should see a two-way arrow. Once you get that, click and hold your mouse and drag towards the right side.
2] Use the AutoFit Column Width option
It is a handy option that lets you set the width of a column automatically. It detects the maximum width of a cell and applies that to the whole column. You do not need to use the mouse-dragging method. The advantage of this trick is that you can increase the width of all columns at once. To get started, select all the columns that need to be changed, and click the Format menu, which should be visible in the Home tab. After that, click on the AutoFit Column Width option.
The width should be changed immediately.
3] Change default width of cell/column
If you already know how much width you need precisely, you can change the default width of the column. For that, open the Format menu in Excel and select the Default Width option. Now, you need to choose a width.
By default, it should carry the millimeter unit, which is the default unit of Excel. In case you changed it earlier, you need to set the width accordingly.
I hope this simple tutorial will help you fix the text-overflow issue in Microsoft Excel.