Home » Merging

Tag: Merging

Excel – How do I merge cells within a range that is formatted as a Table?

PROBLEM: when I use “Format as Table” to format a range the “Merge and Center” button becomes inactive and I can no longer merge cells.  Why?
SOLUTION: the Table format will stop the merging of cells.  However there is a work-around.

The Format as Table command can be used to quickly apply a professional format to a selected range.  However, in applying the format you are also applying the functionality that Tables offer.  As a result you will no longer be able to merge cells. Read more

Excel – Working with merged cells (merging and fixing problems)

Ever tried to centre a heading over the top of a number of columns? It can be a little frustrating, especially when you can’t quite get it to sit as you would like. Last month saw me running multiple Stage 1 Excel courses and it reminded me that this problem frustrates so many. I love hearing the “oh wows” when I show the class how the Merge and Center command allows you to easily centre headings over tables of data. Read more