<div>
As per my knowledge there is no other option rather than merging the cells.
</div>


<div>
What do you want to do with the multi cells?
</div>


<div>
It's just like in Word where a single cell in a table can be split into multiple cells.
</div>


Untitled.jpg

<div>
as a range if you mean for a reference<br />
or concatenate to merge text.<br />
<br />
It would depend on how you plan to use the &quot;multi-cells&quot;
</div>


<div>
<div class="content wysiwyg-content">
Is there any way multi cells in excel can be treated as one cell but not having to merge the cells?
</div>
</div>


Is there any way multi cells in excel can be treated as one cell but not having to merge the cells?

As per my knowledge there is no other option rather than merging the cells.

What do you want to do with the multi cells?

It&#39;s just like in Word where a single cell in a table can be split into multiple cells.

as a range if you mean for a reference
or concatenate to merge text.

It would depend on how you plan to use the &quot;multi-cells&quot;

Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.