Rotate headers in Excel
While searching around for tips that I havent discovered yet, I came across an interesting article from Texxors, showing you how to rotate your Excel headers.
Using the same data set as above, let’s say that you want to make your table look a little fancier. Or maybe your column headers are waaaaaay wider than the rest of the data in that column. For either issue, you can rotate your text so that’s it on an angle, or even completely vertical! Here’s how:
1. Select the cells with the text you want to rotate.
2. Go to Format > Cells (keyboard shortcut: Ctrl 1).
3. Move to the Alignment tab.
4. See the Orientation area on the right? Grab the little red diamond and move it so that the text is oriented the way you want your text to be oriented.
5. Click OK. Voila!
Pretty nifty, never knew you could do this.
headers, rotate, excel, microsoft, office, tips
Leave a Reply