How to Wrap Text across Multiple Cells without Merging in Excel

Excel by default displays long entries without merging if there is no content in the adjacent right-side cells. However, sometimes we need Excel to wrap text across multiple cells without merging to offer a better representation of data. Because merging cells pose various calculation discrepancies. Excel’s Format Cells and Custom Cell Style features allow users to wrap text across multiple cells without merging.

Let’s say we have a dataset where Customer Infos are stored with respective Customer IDs. We want to wrap the Infos across multiple cells without applying Merge & Center.

Dataset-Excel Wrap Text Across Multiple Cells Without Merging

In this article, we demonstrate wrapping text across multiple cells without merging in Excel using Format Cells and Custom Cell Style features.


Download Excel Workbook


2 Ways to Wrap Text across Multiple Cells without Merging in Excel

Excel offers the Wrap Text option to fit cell contents within a single cell by increasing the cell’s length or width. Also, Merge & Center option wraps text across multiple cells but merging poses issues while executing Excel operations. That’s why we can’t use these two options as a solution for text wrapping without merging. Instead, we use Format Cells and Custom Cell Style to wrap texts without merging along with multiple cells. Follow the below description to know about the mentioned feature’s execution.


Method 1: Wrap Text across Multiple Cells Using Format Cells Feature

We can access the Format Cells using the Font Setting icon (CTRL+SHIFT+F) in the Font section Home tab. The Format Cells window holds multiple options to choose from. We can use keyboard shortcuts CTRL+1 to access the Format Cells window.

Step 1: Highlight the columns along with the text you want to wrap text across. Go to the Home tab > Click on the Font Setting icon (as shown in the below image).

Format Cells-Excel Wrap Text Across Multiple Cells Without Merging

Step 2: The Format Cells window opens up. In the window,

⇒ Choose the Alignment section.

Select Cross Across Selection as Horizontal Text alignment.

⇒ Choose any of the options (i.e., Center) as Vertical Text alignment.

⇒ Tick Wrap Text as Text Control.

Click on OK.

Format Cells window

🔄 Clicking OK takes you to the worksheet. Furnish the data and you see a similar depiction as the picture below.

Outcome

🔄 If you highlight the data to cross-check whether they are wrapped text or not, you see only the Wrap Text option is enabled along with vertical position Center. Also, you see Excel spread out the data across multiple cells.

Cross-check


Method 2: Custom Cell Style to Wrap Text without Merging

Excel allows users to make a custom cell style of their own and apply it whenever they want. Therefore, we can pick our desired options to insert a custom cell style.

Step 1: Move to Home > Click on Cell Styles. Excel displays the offered Cell Styles.

Click on New Cell Style.

Custom cell styles-Excel Wrap Text Across Multiple Cells Without Merging

Step 2: The Style dialog box opens up. In the dialog box,

Assign a name in the Style Name command box.

Click on Format.

Style window

Step 3: Excel brings up the Format Cells window. In the window,

⇒ Choose the Alignment section.

In the Horizontal Text alignment command box, Choose Center Across Selection.

⇒ Select any of the options (i.e., Center) in the Vertical Text alignment command box.

⇒ Enable the Wrap Text option as Text Control.

Click on OK.

Format Cells window

🔄 Again, Excel takes you to the Style dialog box. In the dialog box, you can apply other options such as Border, Shading, etc.

Click on OK.

Style window

Step 4: Now, highlight the cells you want to wrap the texts across. Go to the Home tab > Click on the Cell Styles.

Selecting column

Step 5: In the Cell Styles fetched window, there is a Custom option as Wrap Text Across. You can recall you earlier created the custom cell style in Steps 1, 2, and 3.

Click on the Wrap Text Across option.

Selecting custom cell style

🔄 After applying the custom cell style (i.e., Wrap Text Across), Excel takes you to the worksheet and you see Excel wrap text all the data across multiple cells without merging.

Outcome

🔄 In case you want to verify the texts, just highlight the text; you see only the Wrap Text option is enabled. And Excel highlights all the column indicators as proof of wrap text across the selection.

Cross-check-Excel Wrap Text Across Multiple Cells Without Merging


Conclusion

In this article, we demonstrate how in Excel, you can wrap text across multiple cells without merging using features. Both Format Cells and Custom Cell Style are efficient to wrap text across multiple cells without merging them. Hope these methods excel in their purposes in your case. Comment, if you have further inquiries or have anything to add.

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo