
Transpose (rotate) data from rows to columns or vice versa
You can convert the table to a range first, or you can use the TRANSPOSE function to rotate the rows and columns. Here’s how to do it: Select the range of data you want to rearrange, …
Transpose data from rows to columns (or vice versa) in Excel for Mac
You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE function to rotate the rows and columns. If you want to rotate …
TRANSPOSE function - Microsoft Support
Sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type …
Align or rotate text in a cell - Microsoft Support
Rotate text to a precise angle. Select a cell, row, column, or a range. Select Home > Orientation > Format Cell Alignment. Under Orientation on the right side, in the Degrees box, use the up or …
Rotate or flip a text box, shape, WordArt, or picture
Under Drawing Tools (or Picture Tools if you're rotating a picture), on the Format tab, in the Arrange group, click Rotate, and then: To rotate the object 90 degrees to the right, click Rotate …
Fit more text in column headings - Microsoft Support
Rotate text and borders in column headings. You can angle text to fit long headings into small columns. Select the cells that you want to format. On the Home tab, click Format, and then …
Change the display of a 3-D chart - Microsoft Support
Change the display of a 3D chart in Office apps. You can change format, rotation, and scaling of 3D charts in Excel, Word, Outlook, and PowerPoint.
Print an Excel worksheet in landscape or portrait orientation
By default, Microsoft Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape to print it sideways.
Apply color to alternate rows or columns - Microsoft Support
To format alternate rows or columns, you can quickly apply a preset table format. By using this method, alternate row or column shading is automatically applied when you add rows and …
Change the display of chart axes - Microsoft Support
Display or hide axes, or change other aspects of a chart axes in Excel, Word, Outlook, or PowerPoint.