How to prevent text from spilling over to next cell in Excel?
Prevent text form overlapping cells
|With Kutools for Excel's Split Cells, you can quickly split one single cell or a range cells into multiple rows/columns based on specific separator or fixed width.|
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To prevent text from overlapping cells, you can do as follow:
|Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.|
1. Select the cells you want to prevent cell contacts from spilling over and right click, then select Format Cells from the context menu. See screenshot:
2. In the Format Cells dialog, click Alignment tab, then select Fill in the drop down list of Horizontal. See screenshot:
|Kutools for Excel's Protect Worksheet function can quickly protect multiple sheets or the whole workbook at once.|
3. Click OK. Now the data in the selected cells will never spill over.