Technology

Step-by-step guide: How to rotate text in Excel: Horizontal, vertical, diagonal or reverse – any style is possible!

Are you looking for ways to rotate text in Excel to make your spreadsheets more visually appealing, professional, and impressive? Look no further! In this article, FPT Shop will guide you through some simple and easy-to-follow methods for rotating text in Excel. Let's dive in and explore!

Administrator

27 December, 2023

152

Excel is a useful and widely used office tool for data processing. However, to use Excel effectively and create beautiful spreadsheets, users need to master many skills in working with the software. One of those skills is rotating text in Excel. That’s why in this article, FPT Shop will share with you some popular, effective, and easy-to-use methods for rotating text.

Benefits of rotating text in Excel

Rotating text in Excel is an interesting trick. It allows you to format text in the spreadsheet in different directions, such as horizontal, vertical, diagonal, and even upside down. This brings many benefits to users when designing and formatting tables, such as:

Utilizing vertical and diagonal space in the spreadsheet, saving space, especially for spreadsheets with multiple rows and columns of data.
Creating impressive, unique labels, charts that attract the attention of viewers and readers.
Contributing to expressing your creativity and professionalism in creating and designing spreadsheets.

03 simple and popular ways to rotate text in Excel

To rotate text in Excel, you can apply one of the following three methods:

Rotate text in Excel using Format Cells

Format Cells is a tool used to format cells in Excel. Therefore, you can use it to rotate text in cells.

Step 1: In the spreadsheet you want to rotate text, select the range of data you want to rotate > Right-click > Select Format Cells.

Step 2: The Format Cells dialog box will appear, click Alignment > Select the angle you want to rotate in the Degrees section > Click OK.

Step 3: After clicking OK, you will see that the previously selected data range has been rotated according to the angle you chose.

Rotate text in Excel using Orientation

If you don’t want to access the Format Cells dialog box, you can use the Orientation function available in Excel to rotate text.

Step 1: First, select the cells you want to rotate text in the spreadsheet.

Step 2: Then, click on the Home tab > Select Orientation > Choose the desired orientation and rotation angle of the text.

Here, you have 5 options, each option represents a different way of rotation, depending on your needs, choose the appropriate rotation style.

Angle Counterclockwise: Rotate the text counterclockwise by 45 degrees.

Angle Clockwise: Rotate the text clockwise by 45 degrees.

Vertical Text: Display text vertically with individual characters, let them fall from top to bottom.

Rotate Text Up: Rotate the text vertically upward at a 90-degree angle.

Rotate Text Down: Rotate the text vertically downward at a 90-degree angle.

Rotate text in Excel using WordArt

In addition to the above two methods of rotating text in Excel, you can use WordArt – a tool for creating artistic text to add uniqueness to your spreadsheet.

Step 1: First, click on the Insert tab on the toolbar > Select WordArt in the Text section > Choose the desired text style.

Step 2: Enter the content into the Text Box.

Step 3: After entering the text, you can rotate it directly by clicking and holding the circular arrow, then rotate the text as desired.

Alternatively, you can also click on Rotate in the Format section, choose the desired rotation angle.

Rotate Right 90^o: Rotate the text to the right by 90 degrees.
Rotate Left 90^o: Rotate the text to the left by 90 degrees.
Flip Vertical: Flip the text vertically.
Flip Horizontal: Flip the text horizontally.

More Rotation Options: Customize the rotation angle by entering the rotation coordinates in the Rotation box.

Conclusion

In this article, FPT Shop has shown you 3 methods to rotate text in Excel. Hopefully, through these instructions, you will be able to choose a suitable method to create impressive and professional spreadsheets. Excel has many tricks, so be sure to follow us regularly for more useful information.