![]() Even if we unmerge all of the cells, this rarely solves the problem, as this action will assume that the merged cell contents should be placed in the top left cell of the unmerged range - which may not be where you want them to be. ![]() Fill down doesn't work if any of the cells in the range to be filled are merged.Copying and pasting ranges is restricted to those with cells merged in the same way.Data containing merged cells can not be treated like a normal data table - meaning that we can't use all of the tools that we might want to use for referring to a properly formatted data table, such as pivot tables, SUMIF, etc.Just to recap, the problems highlighted in that earlier post were: It became clear in some of the comments on forums that I had highlighted the problems but had been less than clear on alternatives. ![]() Today's post is a follow-up to an earlier post, " Do you really need to merge those cells?" where I highlighted the dangers of merging cells. So if you've been thinking about it, now's the time to do something about it, if you want to save some money. Before we get into today's post, just a little reminder that the 20% discount offer on Mynda Treacy's Excel Dashboards course expires on Thursday.
0 Comments
Leave a Reply. |