Preventing Text from Spilling Over in Excel 2010

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.


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



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.



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

Users are saying about us...

  1. 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?

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube