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?
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!
Help, Tips, Tricks, and Tutorials for Word, Excel, Outlook, Office 365 and more