This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am having trouble rectifying an orientation issue. I have a workbook that has 10 sheets. I'm trying to set orientation to landscape, but Excel won't do it. It's weird, on 2 of the sheets, the orientation changes fine, but on the other 8 sheets, the print layout changes to orientation, but the last 2 columns don't show on print preview or when I print. However, the other 2 sheets print fine when I change to landscape. Basically I'm trying to print columns A-K, on 8 of the 10 sheets, columns J and K don't print or show on print preview.
All 10 sheets are exactly the same. Why isn't landscape working properly on the other 8 sheets? I've tried selecting "Fit all columns on 1 sheet" but that doesn't make them appear. I've looked at the printer properties and set it to landscape, the 8 sheets still don't show columns J and K in print preview. What is going on here? I'm getting pretty frustrated with this, a 10 minute task has turned into an all day ordeal. Any help here is appreciated.
-Eric
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Try a Google/Bing using: Excel landscape fails
This is one I found: http://h30434.www3.hp.com/t5/Other-Printing-Questions/Landscape-Printing-Doesn-t-work-anymore/td-p/362965
best wishes
In my situation, I had no printer sat as my default printer. Once I did this everything worked fine. How it got removed, I had no idea.
Follow the steps mentioned below to ensure each sheet orientation is set to ‘Landscape’:
If the issue still persists then create a new workbook then copy the contents of this workbook into new excel file then save it in a different name and check what happens.
This does not work. I have the same issue. When I use Portrait, it shows up as directed, printing on 1 page and showing up in Preview. When I select Landscape, it disappears and wants to print 63 pages. Is there a real solution for this?