Workbook Item Print Orientation

You can access the Workbook Item Print Orientation function in the following ways:
  • Ribbon bar: Select the Workbook tab and in the Items group, click Print Orientation to display the Workbook Item Print Orientation dialog box.
  • Classic menus: From the Workbook menu, select Item Print Orientation to display the Workbook Item Print Orientation dialog box.
You can also right-click on an item in a workbook and select Print Orientation from the short-cut menu to display the Workbook Item Print Orientation dialog box.
Element Name Description
Orientation When a workbook is created, all print orientations are Default, which means that each item inherits its orientation from its parent node. But you can specify the print orientation of each item in a workbook individually.

If an item is specified as Portrait or Landscape, it is printed as a portrait or landscape irrespective of the setting of the parent node. If this item has child nodes, this same specification have an effect on how the child nodes are printed (portrait or landscape).

If a child node has default orientation it is printed with the same orientation as its parent node. If a child node has been modified to Portrait or Landscape, the item is printed with the portrait or landscape orientation irrespective of the print orientation of the parent node.

Default This option button is selected by default. If it is not cleared, the item is printed with the same orientation as the parent node.
Portrait Select this option button to print the workbook item with the portrait orientation.
Landscape Select this option button to print the workbook item with landscape orientation.
OK After specifying print orientation, click OK to close this dialog box.
Cancel Click Cancel to close this dialog box without changing the print orientation.