How to perform Text Orientation in Excel

Microsoft Excel has a very interesting formatting support that lets you change the way you want to show your data. You can align your data which is provided in cell(s) of excel file. It can be aligned in all possible directions in 2-Dimensions form. It provides options like Angle Counterclockwise, Angle clockwise, Vertical text, Rotate text up, Rotate text down, Format cell alignment.

Do you have idea of such functionality? No problem, by the end of this article, you will understand this feature of Microsoft Excel very well.

 



 

Let’s take a very simple example with records of sport event participants from various schools. Student’s records are available with following columns:

  1. Sport
  2. Name
  3. Class
  4. School

Now, let’s start formatting of data based on below criteria(s):

 




 

Rotate text in a row or column

  1. Select complete row or column by clicking on number mentioned on left side or alphabets mentioned on top i.e. A, B, C etc.
  2. Now, select orientation tool under Alignment in ribbon. Refer an screenshot below.
  3. Now, select any of the required option as per your need. For example, I’ve selected Angle Counterclockwise.  
  4. If you want, you can group same school name in a single cell. To do this, select three cells with common school name and select Merge and Center in ribbon.
  5. Now, again select cell containing “BBPS School” and click Middle Alignment tool
  6. Finally, it will change to as below:

 




 

Rotate text in a cell

Similarly, you can select any single cell instead of selecting entire row or column and perform above mentioned steps to see effects within cell .

 



 

Like, Subscribe & Share!

Be Connected…

Satyendra

, , , , ,

About Satyendra Mishra

Satyendra is a Technical Project Manager with 12+ years of experience on Project Management, Microsoft Technologies including ASP.NET, ASP.NET MVC, C#, SharePoint (On premises & Office 365), JavaScript Framework (AngularJS) and related technologies. He is a person with belief, sky is limit for a hard working and dedicated individual. That’s why he devoted himself to field of Software Development and now both are growing with each other. Every year for him turned out to be best year and he received enormous support and love from his companies and his clients from around the world. Now with vast knowledge of software development and its outsourcing process, he decided to move himself into knowledge sharing. Keep a fact in your mind about the comfort level of your clients and this will make you king/queen of your area.
View all posts by Satyendra Mishra →