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
Wonder how your favourite accountant/analyst/spreadsheet guru makes those cool looking headings that go across a number of columns and rows?
Chances are they are using a great feature of Excel 2007 called "Merge and Center". What does merge and center do? Exactly that – it merges all the cells you have selected, and then centres the text!
So how do you do it?
- Select the cells you want to merge
- In the ribbon menu (the one at the top) make sure you are on the "Home" tab, and then look in the "Alignment" section
- Select "Merge & Center"
Simple as that!
Have you selected multiple rows? Well you will notice that whilst the text will be horizontally centered… it will not be vertically centered. How do you fix that? Just near the "Merge & Center" button in the menu there are three buttons. One that has lines at the top, one that has lines in the middle, and one that has lines at the bottom (the one with lines at the bottom will be selected). Select the one with the lines in the middle – that will center the vertical alignment of your selection.
’till next time!