There is a way to get the look of Merge and Center without the inconvenience.
Select the cell containing the text you want centered and the adjacent cells across that you want centered. Using Ctrl+1 to access the Format Cells dialog box, click on the Alignment tab. You can also click on the dialog box launcher in lower right corner of the Alignment group on the Home tab. Click the dropdown arrow in the Horizontal field at the top and select Center Across Selection.
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/30006/excel-find-peace-with-merged-cells-and-calculations-two-natural-enemies "