• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Alternative to Merge and Center in Excel

by on
in The Office Tech Pro

Do you ever get merged cells errors? While merged cells can give your table and worksheet titles a nice appearance, they can cause problems with calculations if they appear within your tables and ranges. There is an alternative that will give you the same look, but without the complications of merged cells. Just as you would with merged cells, select the title and all the cells that span across the top of the table or range. Then, instead of clicking the Merged Cells button, click the dialog box launcher on the Alignment group. In the Text Alignment section at the top, in the Horizontal: field, choose Center Across Selection. The result looks just like you had done a Merge and Center, but all the cells remain separate. Your text is technically still in the cell in which it was originally entered. It just appears to be centered. If your data is a mix of both and you want to apply this solution, select the complete range, click on that dialog box launcher in the Alignment group in the Home tab and clear the Merge cells check box.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/28723/alternative-to-merge-and-center-in-excel "

Comments on this entry are closed.