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.

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.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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 Google PlusVisit Us On Youtube