How to do the Preventing Text from Spilling Over in Excel

In this article we will learn about how to prevent the text from spill over in Excel 2010.

To adjust the text into a cell according to width height we use the “Justify” option in Microsoft Excel 2010/2013. It is a part of format cells, just select the option of “Justify”, text spill over accordingly.

Let’s take an example and understand.

Enter a statement in to cell A2 without the text spilling over into cells outside the area of the report (the report goes from Column D).

To prevent text from extending beyond the report width:

 

  • First ensure that the typed text was only entered in cell A2.
  • Select the cell A2:D2.
  • Go to “Home” tab from menu bar. In the group of “Editing” click on “Fill” from the drop down list select “Justify.

img1

  • The following message appears: Text will extend below selected range. (Before clicking ok, ensure that the cells below 3 are empty.)

img2

img3

Another way by which you can do it, press the Ctrl+1 key on your keyboard, Format cells dialog box will get appear. Go to Alignment tab, Click on Justify in Vertical drop down list, click on ok.

img4

img5

This is the way by which you can prevent the text from spilling over in Microsoft Excel 2010 and 2013.

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel

How to use the SUMIF Function in Excel

Comments

  1. Either use the merge cells option by clicking on the cell and going to cell format.
    Or click on cell format and change “centre”to justify

  2. BY the way, setting the cell horizontal alignment to "Fill" works for the long cells, but any short cells have their text repeated until the cell is filled. Seems like a dumb function. I can't think of a good use for that. But it messes up the short cells.

    Luckily it's only a view function and doesn't actually fill the cell itself with the repeated value. So changing the horizontal alignment to something else (like shrink) gets rid of that extra text.

  3. It's still spilling over, only now it's spilling downward. Is there a way to keep text from spilling over at all without shrinking or word wrap?

      • That's not always a good solution. I'm looking for an answer to the same question. In my case, I want to keep the spreadsheet view-able in one window. Some of the long cells are so long that it would bump other columns I'm interested in out of view. And having those cells bleed over into other cells makes the spreadsheet look confusing.

        I had to go with "shrink to fit", as I haven't found a workable solution.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.