![]() ![]() The settings have been removed from the Print dialog and should now be set on the Page Layout tab of the ribbon for each specific worksheet by clicking the Orientation button and clicking either Portrait or Landscape. This meant that if you had one sheet to print in Portrait, and another in Landscape, you had to print them separately, otherwise they would both print in the same orientation. Up until now, orientation and paper size settings on individual worksheets were being overridden by the setting in the Print dialog. Select Unprotect Sheet or Unprotect Workbook. If you are the owner of the file, or you know the password for it, you can unprotect the file by following these steps: Select the Review tab. When you have worksheets with different (or mixed) orientation in the same workbook, you can now set the first worksheet, which may be a summary or table of contents, to print in Portrait mode while the rest of worksheets can be printed in Landscape page to accommodate the width of the content. If you don’t have access to such a device, you can edit the cells in Excel for Mac if the worksheet or workbook is unprotected. ![]() ![]() We heard you and are happy to let you know that you can, once again, set the print orientation at the worksheet level. Some of you have been quite vocal about wanting a capability that was available in Excel 2011 for Mac, but was removed from subsequent versions. Today we want to share with you another example of how your feedback shapes Office. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |