To flip an Excel page from portrait to landscape for printing, open the worksheet and choose Page Layout > Orientation > Landscape. Check File > Print to preview the result before printing. In Excel, this changes the printed page orientation; it does not turn the worksheet cells or mirror their contents.
People use “flip a page” to mean different things: switching between portrait and landscape, printing on the reverse side of a sheet, or turning the contents sideways. This guide covers changing page orientation, preparing the print layout, and the limits of what Excel can flip. The steps are for Excel for Microsoft 365 on Windows; Mac and Excel for the web notes are included where the process differs.
What You’ll Need
- An Excel workbook with the worksheet you want to print.
- A printer, or access to Print Preview, to check the layout. You can use Print Preview without sending anything to a printer.
- Optional: a selected print area or a known paper size, such as Letter or A4, if the worksheet should include only certain cells or must fit a specific sheet.
Step-by-Step
- Open the right worksheet. Select the worksheet tab containing the data you want on the printed page. Orientation is a page setup setting for the current worksheet, so check that you have not selected a different tab by mistake. If you intend to print several sheets, review each one: changing orientation for one sheet does not automatically set up every other sheet in the workbook.
- Choose landscape or portrait. On the ribbon, select Page Layout > Orientation. Choose Landscape to make the page wider than it is tall, which is usually helpful for tables with many columns. Choose Portrait to make the page taller than it is wide, which often suits a narrow list. This setting changes the printable page shape, not the direction of the text or the position of cells in the worksheet.
- Set the paper size if needed. Go to Page Layout > Size and choose the paper that will actually be loaded in the printer, such as Letter or A4. A mismatch between the workbook’s selected paper size and the printer’s paper can cause unexpected scaling or margins. Available sizes can depend on the selected printer and its driver. If your required size is not listed, check the printer selection and its properties.
- Decide which cells should print. If the whole worksheet is intended, leave the print area unset. To print only a section, select the cells and choose Page Layout > Print Area > Set Print Area. Excel will then use that selection as the printable area for the sheet. To remove it later, choose Page Layout > Print Area > Clear Print Area. A print area can make a page look empty if it was set on the wrong range, so check it when the preview does not show the cells you expect.
- Control how the content fits. In Page Layout, look for the Scale to Fit controls. To keep all columns on one page wide, set Width to 1 page and leave Height as Automatic. This can create multiple pages vertically while preventing columns from spilling onto an extra page. Setting both Width and Height to 1 page forces the entire print area onto one page, but may shrink text until it is difficult to read. Use scaling only when the preview remains legible.
- Check page breaks and margins. Choose View > Page Break Preview to see where Excel divides the worksheet into printed pages. Return to Normal view when finished. If the content is too close to an edge or a page breaks through an awkward place, adjust Page Layout > Margins or review the scaling and print area. You can also open the Page Setup dialog using the small dialog launcher in the Page Setup group on the Page Layout tab for additional settings.
- Preview before printing. Select File > Print. Review the preview pages, orientation, page count, and any scaling. If the preview looks correct, choose the printer and click Print. If it does not, return to the worksheet, change the layout settings, and reopen Print Preview. On Windows, Ctrl+P opens the print screen; on Mac, use Command+P. In Excel for the web, use File > Print and check the available print settings and the browser or system print dialog, since options can differ from desktop Excel.
On Excel for Mac, the main page setup choices are also on the Page Layout tab, including Orientation, Size, and Print Area. Ribbon placement can vary slightly with window size and Excel version. If a setting is not visible, widen the Excel window or look in the Page Layout ribbon rather than assuming the worksheet itself must be rotated.
Common Mistakes
- Changing the view instead of the print orientation. Rotating your monitor, changing workbook zoom, or scrolling sideways does not change the printed page. Use Page Layout > Orientation for the sheet’s print setup.
- Expecting landscape to rotate the cells. Landscape makes the page wider, but text remains upright and the columns stay in their worksheet order. If you want text turned sideways, that is a separate cell formatting choice and may not be suitable for a whole printed worksheet.
- Trying to print too much on one page. Forcing a large worksheet onto a single page often makes its contents unreadably small. Use one page wide with automatic height, or divide the data into sensible sections.
- Forgetting a print area or hidden content. A previously saved print area can exclude rows and columns. Hidden rows and columns are generally not printed, either. Clear an unintended print area and unhide any data that needs to appear.
- Assuming orientation applies to the entire workbook. Page layout settings are associated with worksheets. Check each sheet that will be printed, especially if you select multiple sheets or print the workbook.
Tips
- Choose landscape based on the number and width of columns, not just because the worksheet looks wide on screen. A wide table may still need a larger paper size, smaller margins, or more than one printed page.
- Use Print Preview as the final check. It shows the page layout more reliably than judging the worksheet grid on screen, where zoom and window dimensions can be misleading.
- If column headings should appear again on each printed page, use Page Layout > Print Titles. In the Page Setup dialog, set rows to repeat at the top or columns to repeat at the left. This is useful for long reports that span multiple pages.
- Save the workbook after adjusting its layout if you want the page setup to remain with the file. For a one-time print, still review the preview before sending it, because printer paper and driver settings can affect the result.
- If you need paper printed on both sides, look for duplex or two-sided printing in the printer’s settings. Choose the binding or flip edge that suits the document there; Excel’s Landscape choice alone does not control how a printer turns the sheet over.
Troubleshooting
The preview is still portrait. Return to the worksheet you intend to print, select Page Layout > Orientation > Landscape, then open File > Print again. If you selected multiple sheets, check the orientation of each one. Also verify that you are looking at the intended worksheet in the print settings.
Columns are split across pages. First confirm that the print area includes the full table. Then set Scale to Fit Width to 1 page and Height to Automatic. If text becomes too small, do not force all rows onto one page; instead consider narrower margins, a larger paper size, or separate pages. Check Page Break Preview to see which columns are crossing a page boundary.
The printout is missing cells or has blank pages. Choose Page Layout > Print Area > Clear Print Area to remove a restrictive range, then set a correct area if necessary. Check for hidden rows or columns and review page breaks. In File > Print, use the print selection or active-sheet options that match what you want to print rather than printing the entire workbook unintentionally.
The printer ignores the selected orientation or uses the wrong paper. Confirm the printer selected in File > Print, then check its properties or preferences for paper size and orientation. Printer drivers can apply their own settings, and some printers do not offer every paper size. Match the Excel Page Layout > Size choice to the paper loaded in the printer, and reopen the preview after changing printer settings.
The page is landscape but the text is not sideways. That is expected: landscape changes the shape of the printed sheet, not the rotation of its contents. If you mean that cell text should run vertically, select the cells and use Home > Orientation to choose a text orientation. This affects cell text only, can change row height and readability, and is not the same as rotating the whole page.
Excel for the web does not show the same controls. Use File > Print and inspect the print options offered by the browser or system dialog. The web version and available printer settings may not expose every desktop page setup control. If you need precise page breaks, repeat-print titles, or more complete scaling controls, open the workbook in the Excel desktop app and set them there.
Frequently Asked Questions
How do I flip an Excel page to landscape?
Open the worksheet and choose Page Layout > Orientation > Landscape. Then use File > Print to confirm that the preview is wider than it is tall.
Can I flip just one page in a worksheet?
Orientation is a worksheet page setup setting, not a simple toggle for one page within a continuous printout. For a section that needs a different orientation, put it on a separate worksheet and set that sheet to the desired orientation. You can then print the sheets separately or combine the output outside Excel.
Can I print an Excel sheet on both sides?
Often, yes, if the printer supports duplex printing. Turn on two-sided printing in the printer settings in the print screen or printer properties. The exact wording and choices depend on the printer; select the appropriate flip edge for how the pages will be bound or read.
How do I make Excel print on one page?
Set the Scale to Fit Width and Height to 1 page, or use the scaling choice in the print screen if available. Check the preview carefully: a large worksheet may be reduced to text that is too small. For a readable report, fit the columns to one page wide and allow the rows to continue onto further pages.
Can I flip or mirror a worksheet so it prints backward?
Excel’s page orientation setting does not mirror a worksheet. A printer may provide a mirror-image or transfer-print option for particular printing tasks, but the option is printer-specific. Check the printer documentation and preview a test page before printing important material.
Why does landscape look different on my screen than on paper?
The worksheet grid is not a faithful picture of the printed page. Zoom, paper size, margins, scaling, the selected printer, and its driver can all affect the output. Use File > Print to inspect the final page layout and correct any unexpected breaks or shrinking before printing.
Related
- Enable Scroll Lock in Excel: Keyboard and On-Screen Methods
- How to Enable the Share Option in Excel for Collaboration
- Link Quantities in Excel: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Labels in Excel and Word: Mail Merge Step-by-Step GuideTo create a sheet of address or product labels, organize each recipient or item in a separate row…
- Nested IFs in Google Sheets: Formulas and AlternativesTo create nested IFs in Google Sheets, put another IF inside the first one’s result: for example, with…
- Free Meal Planner Spreadsheet: Plan Meals in ExcelYes—you can make a free meal planner spreadsheet in Excel by laying out a week of meals, adding…
- How to Find Exact Duplicate Names in ExcelTo find names that match exactly—including capitalization and spaces—in Excel for Microsoft 365, put your names in column…
- Excel Insert Page Break Based on Cell Value?Excel has no built-in setting or worksheet formula that automatically inserts a page break when a cell contains…
- Google Sheets Habit Tracker: Build One That WorksA Google Sheets habit tracker is a spreadsheet for recording whether you completed habits on particular days; the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.