![]() So these are some of the ways you can quickly rotate text in Excel. Or you can use the Alignment dialog box (the second method covered in this tutorial) and set the orientation degrees to 0. If you want to remove the rotated text and get back the regular horizontal text, you need to go back and disable the current setting (which you can do by clicking on the same option in the ribbon again).įor example, if you have the text in the Angle Counterclockwise setting, go to the same option and click on it again (it works as a toggle). Change the Text Orientation Back to Horizontal (Default State) It’s a long keyboard shortcut, but still, the fastest way if you need to use this setting regularly. If rotating the text is something you need to do a lot often, getting used to the shortcut to do this could save you some time.īelow is the keyboard shortcut to rotate text in the selected cells ALT + H + F + Q + O (press one after the other) Keyboard Shortcut to Rotate Text in Excel You can also click on the red dot in the Orientation option and use the mouse to get the desired alignment. In the orientation section, enter the degrees by which you want the text to be rotated.In the options that show up, click on the ‘Format Cells Alignment’ option.This is a slightly longer method (takes a few extra clicks), but gives you a lot more control. Rotate Text Using Ribbon Format Cells Dialog Box You can do that as well, but for that, you need to use the next method covered in this tutorial. For example, what if you want the angle of the rotation a little more than 45 degrees (say 60 degrees). While this is a quick way to rotate text in a cell, it gives you limited options. While there are some other options as well, I don’t use them (and not sure if anyone does). You can also choose the options such as Angle Clockwise or Rotate Text Up. The above steps would rotate the text in the selected cells by 45 degrees. ![]() In the options that show up, click on the ‘Angle Counterclockwise’ option.Apply or remove the italic format to a cell or range of cells. Apply or remove the bold format to a cell or range of cells. In the Alignment group, click the ‘Orientation’ icon Toggle on and off the vertical interior border while in the Format Cells dialog box on the borders tab. Press the arrow keys to select the Text box that you want, and then press ENTER.Select all the cells (that has the headers). ![]() Suppose you have a dataset as shown below and you want to rotate the headings in the first row.īelow are the steps to rotate the text in the cells: Rotate Text Using Ribbon Alignment Options
0 Comments
Leave a Reply. |