How to Rotate Text by 180 Degrees in Excel

Excel provides some functionality to rotate text within limits. But do you want to rotate your text 180 degrees in excel and can’t find any solutions available? Follow this guide and hopefully, it will help you through the process.


Download this Workbook

Try downloading and practicing this workbook as you go through the article.


Is it Possible to Rotate Text by 180 Degrees in Excel?

Long story short, no, Excel doesn’t exactly provide any way to rotate text 180 degrees in a cell. Text in an Excel cell can be rotated from a range of -90 to 90 degrees. But there are still possibilities if you want the visuals of a 180 degree rotated text in an Excel sheet. We can achieve that by either using a text box or pasting the text as an image.


Rotate a Text Box by 180 Degrees in Excel

Using a text box (or a word art) is one way to get the visuals of a 180 degree rotated text in Excel. To do exactly that follow these steps.

Steps:

  • In the tools ribbon, select Text under the Insert tab.

  • Then, click on Text Box under that.

inserting text box to rotate text 180 degree in excel

  • Click and drag the box to where you want to put it.
  • You can also resize and move the box, preferably in the size of a cell and on it.

  • Type your text value in it.

  • If you don’t have the Text Box selected, select it. Then go to the Shape Format tab, select Rotate and click on More Rotational Options. A Format Box will pop up.

rotating text box 180 degrees from options in excel

 

  • In the Format Shape box, select Shape Options, then go to Size and Properties. Under the Size header, you can find the Rotation.

changing shape option to rotate text 180 degrees in excel

  • Put the value to 180 and press Enter. You will have your text box rotated by 180 degrees.

180 degree rotated text in excel

Read More: Excel VBA to Rotate Text to 90 Degrees (4 Easy Examples)


Rotate an Image by 180 Degrees in Excel

In addition to using a text box, we can also rotate text 180 degrees by using it as a picture. For this method, follow this procedure.

Steps:

  • First, type out the text you want to rotate in a spreadsheet cell.

  • Copy the cell.
  • Then go to the cell you want to paste the rotated text.
  • In the tools ribbon, under the Home tab, select the downward-facing arrow under Paste. Select Picture under Other Paste Options.

pasting image before rotating 180 degrees in excel

  • The text is now copied and pasted as a picture. If the picture isn’t selected, select it.

  • Then go to the Picture Format tab from the ribbon, select Arrange, then under Rotate select More Rotate Options.

rotation options in excel

  • A new Format Shape box will appear. Now select Size & Properties from it.
  • Under Size, change the Rotation to 180 degrees, and press Enter.

format picture options in excel

Now you will have a 180 degree rotated picture of the text but as an image.

How to Rotate Text in Excel ( 3 Easy Techniques)how to rotate text 180 degrees in Excel

Read More: How to Rotate Text in an Excel Chart (2 Methods)


Conclusion

These are the ways you can mimic 180 degrees rotated text, despite the lacking of such features in Excel released to date. Hopefully, this was helpful to you and you had a good read.

Explore Exceldemy for more helpful guides.


Related Articles

Abrar Niloy

Abrar Niloy

Hi! my name is Abrar-ur-Rahman Niloy. I have completed B.Sc. in Naval Architecture and Marine Engineering. I have found my calling, if you like, in Data Science and Machine Learning and in pursuing so, I have realized the importance of Data Analysis. And Excel is one excel-lent tool do so. I am always trying to learn everyday, and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo