This document has really come a long way since we started building it. It used to just be a blob of numbers out there, just black text floating inside this Excel worksheet. We have really started to spice it up with colors and borders and background colors, Formatting this document.
Now, I want to take this a step further. Our title, big and bold there at the top of the screen. What I would like to do now is take that title and center it along the top of my spreadsheet. I want to put monthly budget right in the middle of the width of the spreadsheet.
Now, we have 1 2 3 4 5 6 columns there (B,C,D,E,F,G).
Right about here and between D and E is the middle of my spreadsheet, that is between two cells though. I cannot put monthly budget where there is no cell that is in the middle of two cells right.
I would have to insert another one inside of there to be able to create that center.
Now to fix this Microsoft Excel has got a feature called merge and center. the merge center feature will take a group of cells like B3 to G3, that 6 set of cells there and merge them all into one cell and center the contents one button press.
Now, I am going to highlight cells B3 to G3 different cells, with that highlighted I will go to Home tab underneath alignment I have got Merge and Center. I will give that a click one button press, and I am now taking those six individual cells merged them together, created one big master cell out of those six and centered my title, merge and center a very neat feature.
Now it is a clickable button it is a toggle, if I could get Again it all on merge them take me back to six individual cells and leave it as is cause. now I may go up and change the color or make it blue, I mean it change the font color, I will give it a border at the bottom. And now I have got a nice title up there at the top of the screen.
Try it out.