Merging cells button is disabled in table format (Microsoft 2016)

Question

Hi,I'd like to section my tables by merging cells, but that button is disabled in table format. It works fine whenever I am not working in a table format, but it becomes unclickable whenever I try to do it in a table.&nbsp;I have already added the toolbox add-ins, but nothing changes.Can anybody help me with this?&nbsp;Thanks in advance!

lookingforhelp · Answer

I have found it:https://www.extendoffice.com/documents/excel/4488-excel-merge-cells-in-table.html

riny_van_eekelen · Answer

lookingforhelp&nbsp;I was going to reply "Very good. Do not use merged cells. They are often the cause of trouble".&nbsp;You discovered that you can't use merged cells in structured tables, because merging cells makes the date unstructured and that is not recommended when you still need (or intend) to analyze, sort, filter or summarize the data. Though, merged cells do little harm in a final reporting lay-out.&nbsp;The link you found merely describes how to remove the structure from the data set and turn the table into a "flat" range, permitting the merging of cells.

sergeibaklan · Answer

lookingforhelp&nbsp;
Even with ranges, forget about merging cells. Your life will be much easier in future.
If necessary, use

Forum Discussion

Merging cells button is disabled in table format (Microsoft 2016)

3 Replies

Resources