How To Use Center Across Selection in Microsoft Excel Tutorial | The Teacher

In this Microsoft Excel Tutorial, you will learn how to use Center Across Selection and when you should avoid using the Merge and Center and use Center Across Selection instead. ⭐ Download the Sample Center Across Selection Excel Workbook @ https://www.patreon.com/posts/71198419 ? Support For A Cause @ https://www.patreon.com/TheTeacher ✍ About Center Across Selection vs Merge and Center in Excel If I have to define the difference between the Center Across Selection and Merge and Center commands, then I will say that the Center Across Selection aligns your text to the center of the selected cells without merging them, whereas the Merge and Center convert the selected cells to a single cell. Sometimes, certain commands can cause problems, if your selection contains both the merged and unmerged cells, like the Sort command. The sort command in excel can display a message stating, "To do this, all the merged cells need to be the same size.", which means the list can't be sorted because the selection contains both the merged and unmerged cells. This is the time when you can use the Center Across Selection Text Alignment feature, which only works over the Horizontal Text but not vertical. It will center the text according to the width of selected cells, without actually merging those cells. ? Recommended Videos Using Sort Command in Excel https://www.youtube.com/watch?v=HNmERKJtlR0 ? Subscribe for more tutorials: https://www.youtube.com/TheTeacher?sub_confirmation=1 ? Learn More, Visit: https://www.theteacherpoint.com ✅ Recommend Playlists: ? More Microsoft Excel Tutorial http://bit.ly/Excel-2016-Playlist ? Follow Me : Twitter - https://www.twitter.com/TheTeacherPoint Facebook - https://www.facebook.com/TheTeacherPoint Instagram - https://www.instagram.com/TheTeacherPoint/ Pinterest - https://in.pinterest.com/TheTeacherPoint/ #excel #microsoftexcel #theteacher ? A Microsoft Excel Tutorial By The Teacher