# Excel make text vertical

**URL:** <https://forum.dynamobim.com/t/excel-make-text-vertical/84019>\
**Category:** Uncategorized\
**Created:** [December 11, 2022, 8:22am UTC](https://forum.dynamobim.com/t/excel-make-text-vertical/84019 "2022-12-11T08:22:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![vanman](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/vanman/32/20881_2.png) [@vanman](https://forum.dynamobim.com/u/vanman)\
**Post date:** [December 11, 2022, 8:22am UTC](https://forum.dynamobim.com/t/excel-make-text-vertical/84019/1 "2022-12-11T08:22:23Z")

</div>

Is it possible to make text vertical in an excel cell?

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/b/7b93c33f6a0c055db5517a95634070914b9c35d5.jpeg)

---

<div class="post-metadata">

**Author:** ![Mark.Ackerley](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mark.ackerley/32/79310_2.png) [@Mark.Ackerley](https://forum.dynamobim.com/u/Mark.Ackerley)\
**Post date:** [December 12, 2022, 8:50am UTC](https://forum.dynamobim.com/t/excel-make-text-vertical/84019/2 "2022-12-12T08:50:00Z")

</div>

Hey,

I’ve found it easiest to have a macro that I run in Excel after I’ve exported the data…

The VBA code is simple and runs extremely quickly… Particularly if you have lots of formatting across lots of sheets…

![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/9/49234ee747dc89b3ce8895c7f27e8bdde10196d2.png)

Hope that helps,

Mark

> **[Excel VBA to Rotate Text to 90 Degrees (4 Easy Examples) - ExcelDemy](https://www.exceldemy.com/excel-vba-to-rotate-text-to-90-degrees/#1_A_Simple_Excel_VBA_Code_to_Rotate_Text_to_90_Degrees)**
>
> In this article, we've shown how to rotate text to 90 degrees using Excel VBA with meaningful images and proper explanation.

---

<div class="post-metadata">

**Author:** ![vanman](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/vanman/32/20881_2.png) [@vanman](https://forum.dynamobim.com/u/vanman)\
**Post date:** [December 12, 2022, 6:15pm UTC](https://forum.dynamobim.com/t/excel-make-text-vertical/84019/3 "2022-12-12T18:15:27Z")

</div>

Thanks mark. Im really hopping to sort this all from dynamo. Finding out the method is great though! Might be able to adjust some of the BB excel nodes to do it

---

<div class="post-metadata">

**Author:** ![GavinNicholls](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gavinnicholls/32/190442_2.png) [@GavinNicholls](https://forum.dynamobim.com/u/GavinNicholls)\
**Post date:** [December 13, 2022, 6:22am UTC](https://forum.dynamobim.com/t/excel-make-text-vertical/84019/4 "2022-12-13T06:22:05Z")

</div>

This is the cell property to apply using the Microsoft Interop Excel library:

> **[CellFormat.Orientation Property (Microsoft.Office.Interop.Excel)](https://learn.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel.cellformat.orientation?view=excel-pia)**
>
> The text orientation. Can be an integer value from –90 to 90 degrees.

Having delved into it a bit myself, it’s a bit on the complex side and needs a good knowledge of Python and working with an API docs that isn’t of the Revit variety. Bumblebee is a bit difficult to repackage as it depends on a Python library that ships with the package, so if you use its code without Bumblebee available it will generally fail to run.

---

<div class="post-metadata">

**Author:** ![vanman](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/vanman/32/20881_2.png) [@vanman](https://forum.dynamobim.com/u/vanman)\
**Post date:** [December 13, 2022, 6:36am UTC](https://forum.dynamobim.com/t/excel-make-text-vertical/84019/5 "2022-12-13T06:36:37Z")

</div>

Good to know. That sounds like me out 😂 Ill still try tinker a bit with BB
