2 Simple Alternatives to Merging Cells in Excel

2 Tips that will get your spreadsheet looking nice without the use of the evil merged cells feature.

The goal here is to have text that looks nice across multiple columns without having to use the merge cells feature that wreaks havoc with formulas, sorting, filtering, and more.

Resources:

#msexcel #tutorial #exceltips #freetutorial #exceltips #excel

[kentstephen]

Excellent alternatives to Merged Cells and the endless annoyance they cause! The Narrator also speaks very clearly and punches his pronunciation of It sure captures my attention!

[jd]

I’ve been using merge cells for 4-5 years, this is a great alternative

[Patrick-gezn]

This is just what I've been needing . Sorted problem, many thanks. 👍

[antoniusjody]

Thank you for sharing the good practices! It would help me a lot in the future

[LizaBaconguis]

Hello how about vertically. How to do it in excel?

[smb]

Great Technique! Thanks for telling us!!

[rjbanavar]

Awesome ❤🎉 loved it. Being an extensive user of excel nvr used this.

[mkk]

Great tip, didn't know this... keep up the good work 👍🏻

[BenDieselBasicAutomotive]

Thank you for sharing the technique...

[allenbennett]

I have CP (cerebral palsy) and keep going to a different row, so this should help immensely (although far from exact).

[GSS-exky]

Fantastic. I need to learn more of excel. Could you guide me?

[faustinaparagoso]

Hallo thank for this tricks. But I have a question, is it possible to use center across selection in combination with rows and columns? I don't want to use merging. Is there any other way for it. Thank you in advance ☺️

[howtomasterexcel]

Great video. Thank you very much for sharing. Is there any alternative for merging cells if the text is in two (or more) cells vertically? E.G. "Parts" in A1:A2 (rather then in A1:B1 as shown in the video). I hope it makes sense. Thank you.

[staceystephens]

About time someone lets people know to NOT MERGE CELLS IN EXCEL...

[salamander]

Hi, I didn't knew that.... But what are potential problems, when you ARE using it? Like me :P

[mosheslonim]

Thanks for the video. However -
I have a wrapped text that is merged on a few columns. The number of lines in the merged cells changes according to a formula.
I wish to auto-adjust the row height according to the number of lines, but I understand it is impossible to do on merged cells.
Is there a way to do it?

[AlThePal]

Are businesses using Excel as much anymore

[BenDC]

This doesn't seem to work with numbers? Only works with text. Numbers don't extend into the next cell and just become