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:
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.
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.