I have to print (part of) an Excel sheet that has few lines and al lot of columns (so it’s not that height, but rather broad), so I want to print on a landscape-ed paper.
In regular macOS apps (like Preview, Keynote, etc.) I would do this by pressing [CMD]+[P] on my keyboard, so the printing window opens and I can switch the “Preview/Keynote/etc.”-dial to “Page Attributes”, so I can set the Paper Size (e.g. A4 or US Letter) and the Orientation (Portrait or Landscape).
If I do this in MS Excel, I get a similar printing window, but if I click the “Excel”-dial, the list of options doesn’t have “Page Attributes” listed… and I non of the other available options seems to have a setting to change the page orientation either…
Note : Yes, I know that Apple’s counterpart Numbers.app has a different type of printing window with the Page Orientation option listed near the top-right, but that’s to different from what I’m seeing in Excel that I see no way to lear in Numbers.app what I want to do in Excel…
What am I doing wrong ?
Yes, Excel is different from the regular macOS-apps regarding setting the page orientation (and it’s even more different from it’s competitor Numbers.app), but the option is hidden in plain sight !
To change the page orientation in Excel, press the [ALT]+[P] key-combo, and then the print window opens, just leave the Excel-dial as-is and look a little below it… there you will see the options “Print”, “Margins” and “Orientation”… That’s it !
Note : there is another option to set the page orientation in Excel : goto the top menu-bar, click on “File” (top-left) and from the pull-down menu select “Page Setup” (just above “Print”) and when the “Page Setup” window opens, make sure the “Page”-tab is selected and at “Orientation” you will see radio buttons for “Portraid” and “Landscape”… That’s it !