If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.

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.

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 a …

Under Orientation on the right side, in the Degrees box, use the up or down arrow to set the exact number of degrees that you want to rotate the selected cell text.

Use the Tab key until the focus is on Rotation angle spin button and enter the desired number of degrees to rotate the object or image in the clockwise direction and then press Enter.

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 click Format Cells. …

By default, Microsoft Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape to print it sideways.

Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to columns, select the …

Rotate a shape or picture by dragging, selecting a preset angle, or setting the exact degree.

Adding shading to a table can help make certain rows, columns, or cells—or the entire table—stand out in your document. The easiest way to add colored shading to a table is to use the Shading menu.