In fact, two conditions can cause the Merge and Center tool to become unavailable. First you need to check if your table is protected. … If you disable sharing (if enabled) and disable protection (if the table is protected), the tool should be available again.
How to enable merge cells in Excel?
If you are using change tracking and have deleted rows in the table, the deleted cells may not be merged and may be greyed out. This is because cell merging is not tracked, so Word would have no way of saving deleted rows if you could use it to merge cells that are above and below.
Why is the Merge Cells option grayed out?
If you are using change tracking and have deleted rows in the table, the deleted cells may not be merged and may be greyed out. This is because cell merging is not tracked, so Word would have no way of saving deleted rows if you could use it to merge cells that are above and below.
Why won’t Excel let me merge cells?
In fact, two conditions can cause the Merge and Center tool to become unavailable. First you need to check if your table is protected. … If you disable sharing (if enabled) and disable protection (if the table is protected), the tool should be available again.
Why are cells grayed out in Excel?
If you are using change tracking and have deleted rows in the table, the deleted cells may not be merged and may be greyed out. This is because cell merging is not tracked, so Word would have no way of saving deleted rows if you could use it to merge cells that are above and below.
Why won’t Excel let me merge cells?
In fact, two conditions can cause the Merge and Center tool to become unavailable. First you need to check if your table is protected. … If you disable sharing (if enabled) and disable protection (if the table is protected), the tool should be available again.