Who else wants to know the secret to Excel Formulas?Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today
You might already know about a great feature in Excel 2007 called “Merge and Center”. Basically it allows you to create a cell that spans across multiple columns – great for headings for example.
But sometimes you want to merge the cells – but not centre the text. That is where “Merge Across” comes in handy. “Merge Across” does exactly the same as “Merge and Center”, except it keeps the text left justified!
How good is that! No more having to change the paragraph alignment!!!
To merge across a number of cells in Excel 2007, Excel 2010 or Excel 2013:
1) Select the cells you want to merge
2) Make sure you are on the “Home” tab of the ribbon
3) Look for the “Alignment” group
4) Click on the small arrow beside “Merge & Center”
5) Click on “Merge Across”
To unmerge, all you need to do is select the cell, and click on the “Merge & Center” button.
‘till next time!