How to merge cells after using "Format as Table" style

[1tane1]

In order my table look cool, I used "Format as Table" menu with a nice look. However, it divided all my merged cells and now I cannot merge cells again.

I just want format of this new style and I want to merge cells. Excel doesn't let me do it inside of this "formatted table". It protects its own rules.

[1tane1]

I found t finally!

After you format your table with excel "Format as Table" click on design. There you can remove "Header Row" which cannot be deleted in any other way. In addition, on the second section of design menu you will see "Convert to Range" if you click on that, that auto-table goes away but formatting stays and that is what I want.

You can also change the table colors by "Page Layout" menu and "Colors"

I wrote here because people can search from google and can read my comments in future in case they need

[nemunekoro]

Hi there!

thank you so much for sharing the solution you found!

I had exactly the same issue today and you saved me loads of time!

Have a nice day!

[CoffeeJunkie]

Thanks, solved my issue as well. Glad it didn't end like this: https://xkcd.com/979/