The Display tab in the Canvas ribbon provides various options to control the visibility and arrangement of elements in your Canvas. These tools help you customize your workspace by managing panes, hiding or revealing components, and optimizing the display of information for better navigation and usability.
Basic Display Management
Save
Ensures that any changes made to the Canvas display settings are preserved, maintaining the preferred view setup.
View Arrangement
Arrange All
Organizes multiple open workbooks or sheets into different layouts for easier comparison. Common arrangements include:
-
Tiled: Evenly distributes all open windows.
-
Horizontal: Stacks windows from top to bottom.
-
Vertical: Places windows side by side.
-
Cascade: Overlaps windows for easy switching.
Hide / Unhide
Manage the visibility of different elements within the Canvas:
-
Hide: Temporarily removes selected worksheets, columns, or rows from view.
-
Unhide: Restores previously hidden worksheets, columns, or rows.
Open Documents
Displays a list of all open documents, enabling quick navigation and access between different Canvases.
Checkboxes for Display Customization
Customize the visibility of specific interface components to enhance usability:
-
Status Bar: Toggles the status bar at the bottom of the Canvas, which provides information about selected data and calculation modes.
-
Hidden Objects: Shows or hides objects such as charts, images, or shapes embedded in the Canvas.
Updated June 13, 2025