How to Wrap Text across Multiple Cells without Merging in Excel

Method 1 –  Using the Format Cells Feature


  • Highlight the cells 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

  • The Format Cells window opens up.
  • Choose the Alignment section.
  • Select Cross Across Selection as Horizontal Text alignment.
  • Choose any option (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.


If you highlight the data to cross-check whether they are wrapped text, you see only the Wrap Text option and the vertical position Center are enabled. Excel spreads out the data across multiple cells.


Method 2 – Custom Cell Style to Wrap Text without Merging


  • Go 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

  • The Style dialog box opens up.
  • In the dialog box, assign a name in the Style Name command box.
  • Click on Format.

Style window

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

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

  • Highlight the cells you want to wrap the texts across.
  • Go to the Home tab > Click on the Cell Styles.

Selecting column

In the Cell Styles 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.


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

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

Download the Excel Workbook

Related Articles

<< Go Back to Wrap Text | Text Formatting | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF