Tip Printed from ExcelTip.com

---

Preventing Text from Spilling Over


In this example, enter a statement into cell A59, without the text spilling over into cells outside the area of the report (the report goes from column A to D).

To prevent text from extending beyond the report width:

1. First, ensure that the typed text was only entered into cell A59.
2. Select cells A59:D59.
3. From the Edit menu, select Fill and then Justify.
4. Click OK. The following message appears: Text will extend below selected range. (Before clicking OK, ensure that the cells below row 60 are empty.)