

Your table will appear flipped.Ĭlick on the top left cell of your flipped table, then drag your mouse to the bottom right cell.

Click the arrow under the "Paste" button on the ribbon and choose the "Transpose" option. Select an empty cell below your pasted table. Click the "Match Destination Formatting" button from the menu that appears.Ĭlick and hold on the top left cell from your pasted table, then drag the mouse to the bottom right cell and release the mouse button. Press "Ctrl+C" to copy the table.īring up your Excel spreadsheet and click on cell "A1." Click the "Home" tab, then click the arrow under the "Paste" button on the far left end of the ribbon. Click the "+" in the upper left corner of your table to select the entire table. Then open a new Microsoft Excel 2010 spreadsheet.īring up your Word document. Open the Microsoft Word 2010 document that holds the table you want to flip. Move the mouse to the left or right to rotate the text box until the table is aligned as you like it. Press "Ctrl+V" to copy the table to the text box.Ĭlick on the green circle above the text box and hold down the mouse button. Click in the text box and press "Delete" to erase the default text. Drag your mouse away from the box until the text box is the same size as your table.Ĭlick the "+" at the top left corner of the table again and press "Ctrl+C" to copy the table. Choose "Simple Text Box" from the list of options that appear.Ĭlick and hold the mouse button on any of the corners of the text box.

Click the "Text Box" button in the "Text" area of the ribbon. Select the "Insert" tab at the top of the Word window. Align the text to the right if you want to make the bottom row into the first column when you flip the table. Align the text to the left if you want to make the top row into the first column when you flip the table. Click the "Text Direction" button to cycle through having the text rotated to the table's left or right. Click the "Layout" tab at the top of the Word window.
