Tuesday, February 4, 2014

Excel: Don't Use Merge and Center

I hate title creators in Excel who use "Merge & Center".  Yeah, I know you can insert columns and rows now but there are still too many issues.  The sad thing is that this is just the lazy man's option.

There is a much better solution to centering your titles.  Simply select the group of cells you would like your title to be and then right click selecting the format cells option.  Click the "Alignment" tab then in the "Horizontal:" drop down box select "Center Across Selection".  If you have a bunch of titles that need to be centered use F4 after you have gone through the process once.  F4 repeats your last action..  You can also use "Paste Special" and select "Formats".

So if you follow these simple step you will no longer annoy me when you design templates and report in Excel.

Post a Comment