Figure 1. Excel table

Excel has a huge number of tools for customizing text and tools to count data. So, one of useful things is to rotate text on any angle. It can be useful for customizing table headers.

To rotate text on any angle, you should select the cell and make right click, in context menu select "Format Cells" item (Figure 1).

Figure 1. Select Format Cells

Figure 1. Select Format Cells

 

 

In the opened windows select tab "Alignment" and set the degrees value according to your tasks (Figure 2). Press Ok.

Fig.2. Direction of text in the cell

Fig.2. Direction of text in the cell

After this, fix cell size to fit text (Fig.3).

 

Fig.3. Text with 45 degrees angle

Fig.3. Text with 45 degrees angle

 

You can apply text direction not only for single cells, but for merged also. To cancel text direction you should set value to "0 degrees".

Поворот текста можно применять не только для отдельных ячеек, но и для объединенных. Для отмены наклона нужно установить значение "0 градусов".