This is also helpful if you use merged cells. You can rotate the text up or down to be read sideways. Maybe you like the vertical alignment but don’t want the characters displayed from top to bottom. This places the characters below each other and can be read from top to bottom. Your merged cell will then display the text or characters vertically.
Go to the Home tab and click the Orientation button. Select the cell(s) containing the text you want to display vertically. The text in the group of cells now resides in a single cell. Choose either Merge & Center or Merge Cells per your preference. Go to the Home tab and click the Merge button in the Alignment section of the ribbon. You can optionally merge the cells and then apply the alignment we’ll show you how to do both. This can be helpful if you use row headers that cover several rows. In the screenshot below, we angled our column headers clockwise.ĭisplaying your text vertically may not be an orientation you use often but can be useful in certain circumstances. You’ll then see your sheet immediately update with your newly aligned text. Choose one of the top two options for Angle Counterclockwise or Angle Clockwise. Go to the Home tab and click the Orientation button in the Alignment section of the ribbon. This can be a column, row, cell, or range of cells. 
Select the cells containing the text you want to angle.You can quickly rotate the text to an angle counterclockwise or clockwise. Using an angle for your text can be visually pleasing, especially for column and row headers. Here, we’ll show you how to use these settings to display your text in Microsoft Excel to fit your preference.
0 kommentar(er)
