To rotate an Excel table in Word, copy the cells from Excel, paste them into Word as a picture, then select the picture and choose Picture Format > Rotate > Rotate Right 90°. Word cannot rotate a live table as a single object, so pasting as a picture is the practical way to turn the whole table. If you need to keep the cells editable, use a landscape page instead; that changes the page orientation, not the table’s angle.
What You’ll Need
- Microsoft Excel and Word for Microsoft 365 on Windows, with the workbook containing the table.
- A Word document where you can insert the table as a picture. Keep the original Excel workbook if you may need to edit the data later.
- Enough page space for the rotated image. A wide table may need a landscape section or a smaller image size.
The steps below make a static picture: the visible layout is preserved, but you cannot edit individual values as Word table cells. If that trade-off does not suit your document, skip to the landscape-layout option in Step 5.
Step-by-Step
-
Prepare the table in Excel. Open the workbook and check that the range contains only the rows and columns you want in Word. Include column headings, remove temporary notes or unused columns, and adjust column widths so labels are readable. If the table uses filters, decide whether you want filter arrows visible in the picture. Set the zoom to a comfortable level for checking the layout; zoom does not determine the final picture size in Word, but it can help you inspect the selection.
-
Select and copy the cells. Drag across the table range, including its header row, then press Ctrl+C on Windows. If the data is a formatted Excel table, selecting its cells is usually more predictable than copying the whole worksheet. Avoid selecting entire worksheet rows or columns unless that is genuinely what you intend to show. On a Mac, use Command+C.
-
Paste the range as a picture in Word. Click where the image should go in the document. On Word for Microsoft 365 on Windows, open Home > Paste ▼ > Paste Special. In the dialog, select Picture (Enhanced Metafile), if available, and choose OK. This format usually keeps text and grid lines crisp when resized. The ordinary Paste command may create an editable table instead, which cannot be rotated as one complete table. If the Picture (Enhanced Metafile) choice is missing, use another picture option offered in the dialog, or paste the cells normally and use the landscape method instead.
-
Select the pasted picture and rotate it. Click the picture once so the sizing handles appear and the Picture Format tab is available. Choose Picture Format > Rotate > Rotate Right 90° to turn it clockwise. Choose Rotate Left 90° for the opposite direction. You can also drag the circular rotation handle above the picture for a custom angle, but a 90-degree command gives a precise quarter-turn. On Word for Mac, select the picture and look for Picture Format > Rotate; ribbon labels or placement can vary slightly by build.
-
Make room for the rotated image. A quarter-turn swaps the picture’s apparent width and height. If the result extends past the page margins, click in the section containing it and choose Layout > Orientation > Landscape. To make only the table page landscape, insert a section break before the table with Layout > Breaks > Next Page, change the orientation in that section, then insert another Next Page section break after the table and restore Portrait for the following section. Confirm that the cursor is in the intended section before changing orientation.
-
Fit the image without distorting it. Select the picture and drag a corner handle inward or outward to resize it proportionally. Avoid pulling a middle handle, which can stretch the rows or columns and make text look unnaturally wide or narrow. If it is too large, adjust the page orientation or margins before reducing it so much that the text becomes difficult to read. Use the Word print preview to check the whole page, not just the editing view.
-
Position and check the final result. For a simple page, keep the picture in line with text and use the paragraph alignment controls to center it. If you need more precise placement, choose Picture Format > Wrap Text and select a layout option such as Square, then reposition the image. Check that the rotated table is not clipped, that the top of the table faces the intended direction, and that the printed page is readable. Save the document and retain the Excel workbook as the editable source.
If you need editable cells instead: leave the table as a Word table and put it on a landscape page. Copy the range from Excel, paste it as a table, then use section breaks and Layout > Orientation > Landscape as described above. The table remains editable, but its text will read normally across a wider page rather than sideways. This is often the better choice for reports and documents that readers may need to revise.
Common Mistakes
- Expecting Word to rotate a live table. Word can change text direction in table cells, but that is not the same as rotating the whole table. To turn the full grid as one unit, paste it as a picture; to keep it editable, use landscape orientation.
- Using ordinary Paste and then looking for a rotate command. Standard paste often creates a Word table. Select the cells and use Paste Special with a picture format if you need a rotated image.
- Changing the orientation of the whole document by accident. Orientation applies to the current section. Without section breaks around the table, other pages in that section may also switch to landscape. Add breaks before and after the table when only that page should change.
- Resizing from a side handle. This can distort the table and make letters hard to read. Resize with a corner handle, then check the print preview.
- Assuming the pasted picture updates when Excel changes. A picture is a snapshot. If the numbers or formatting change, copy the updated range and replace the old image in Word.
- Making the image too small to fit portrait paper. A rotated wide table may technically fit but become unreadable. Use a landscape section, split the table across pages, or keep it editable in landscape rather than shrinking it excessively.
Tips
- Keep a source copy. Save the workbook and, if useful, keep an unrotated copy of the table elsewhere in the document. That makes future corrections much easier than trying to recreate data from an image.
- Choose the direction for reading. Rotate right and rotate left produce opposite orientations. Before finalizing, imagine turning the page to read it and confirm the table heading will be at the expected edge.
- Use a landscape section for wide data. Readers generally find a normal landscape table easier to read than sideways text. Reserve image rotation for cases where the entire table must be displayed on its side, such as a particular page design.
- Check legibility at actual size. A picture can look clear while zoomed in on screen but be too small in print. Review Word’s print preview or print a test page, especially when the table has small numbers or footnotes.
- Consider accessibility. A picture does not provide the same access to cell contents as a live table. Add useful alternative text through the picture’s context menu and keep the underlying Excel data available. For a document that must be navigable as data, prefer an editable Word table in landscape layout.
- Use the desktop app for the rotation step. Word for the web may offer a different set of picture controls from the Windows desktop app. If you cannot find the Rotate command, open the document in desktop Word and make the change there.
Troubleshooting
There is no Picture Format tab. The tab appears when a picture is selected. Click once on the pasted image, not inside a table cell or beside it. If the selection handles outline individual cells, you pasted a live table; undo, then paste again using Home > Paste > Paste Special and choose a picture format.
The image rotates but is cut off. The page or margins may not provide enough room. Try Layout > Orientation > Landscape for the image’s section, reduce the margins if the document allows it, or resize the picture proportionally. Check that text wrapping is not pushing part of the image outside the printable page area. Print preview is a useful final check.
The picture looks blurry or text is hard to read. If offered, use Picture (Enhanced Metafile) in Paste Special rather than a low-resolution bitmap. Avoid enlarging a small screenshot, because enlargement cannot restore detail. Instead, copy the cells again at their original size using a vector picture option, or use an editable table on a landscape page.
Paste Special does not offer a picture format. Available choices can depend on what was copied and the Office build. Copy the cell range again, then reopen Paste Special. On Word for Mac, the menu and available formats can differ; try Edit > Paste Special if present. If no suitable picture format is offered, use a screenshot of the selected range or export the relevant Excel content as a PDF and insert a suitable image, then rotate that image in Word. Inspect the result for readability before relying on it.
Every page changed to landscape. The table is probably in the same section as the rest of the document. Insert a Next Page section break before the table and another after it. Click within the table’s section and set that section to Landscape; click in the later section and set it back to Portrait. Section breaks can change headers, footers, or page numbering behavior, so review those details too.
The image moves when text is edited. If you chose a wrapping style, Word positions the image relative to surrounding text or the page. Select the image and choose Picture Format > Wrap Text > In Line with Text for the most predictable flow, or use a wrapping option and its layout settings if the image needs to float. Recheck the page after editing nearby paragraphs.
Frequently Asked Questions
Can I rotate a Word table without converting it to a picture?
No. Word does not provide a command to rotate an entire live table as one object. Keep it editable by using a landscape section, or paste it as a picture when a sideways orientation is essential.
Can I rotate only the text inside the table?
Yes. Select the relevant cells and use Table Layout > Text Direction to change the direction of their text. This affects text within cells; it does not turn the table grid or rotate all its contents as one image.
Will the rotated picture update if I edit the Excel table?
No. A pasted picture is static. After changing the workbook, copy the revised range and replace the picture in Word. Keep the source workbook so the data remains available for editing.
Can I rotate the table 180 degrees?
Yes. Select the picture, choose Picture Format > Rotate > Rotate Right 90° twice, or use Rotate Left 90° twice. Check the orientation and page fit afterward.
Is landscape orientation the same as rotating the table?
No. Landscape turns the page to give a wide table more room; the table itself stays upright and editable. Rotating a pasted picture turns the table sideways on the page and makes its cell contents non-editable.
What is different on a Mac?
The basic approach is the same: paste the Excel range as a picture and rotate the selected picture. Use Command+C and Command+V for copying and pasting. Paste Special choices and ribbon placement can vary, so use the picture format options available in your Word for Mac version.
Related
- How to Paste an Image in an Excel Cell
- Password Protect an Excel File so It Requires a Password
- How to Password Protect an Excel File from Opening
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Markdown Table Merge Cells? What You Can DoNo: standard Markdown table syntax has no way to merge cells across rows or columns. If your Markdown…
- Excel Conditional Formatting: Highlight Entire RowsTo highlight an entire row in Excel, select the data range, choose Home > Conditional Formatting > New…
- How to Double Space in Microsoft Word for APA FormatTo double-space an APA paper in Microsoft Word, select the document text, then choose Home > Line and…
- Guest List Excel Template: What to Include and How to UseA guest list Excel template is a workbook for recording invitees, invitation status, RSVPs, attendance details, and seating…
- Excel Freeze Panes: How to Lock Rows and Columns in PlaceYes. In Excel for Microsoft 365 on Windows, you can freeze rows and columns at the same time:…
- How to Merge Cells in Excel: Steps, Options, and FixesTo merge cells in an XLS workbook in Excel for Microsoft 365 on Windows, select the adjacent cells,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.