Forum Discussion
Table tools missing
I have excel 2013. I am trying to split cells in a formatted table. I looked it up on the help website and they said to go to the Table Layout tab and the function is on that tab. This table Layout t...
Can you not take it out of the "formatted table" status to make the change, and then restore that status?
- No I cannot. I tried that and it reverted back to non-merged cells when I put it back in table format.
- I can see what that would happen with merged cells, especially if they were the exception (if the other cells in those columns remained distinct).....
And the same for splitting cells only in selected rows.
If that's what you're trying to do, you're basically going against the very concept of the formatted table, in ways that would render it incapable of offering the advantages of Tables.
