The Design tab in the Canvas ribbon provides a comprehensive set of tools for formatting and structuring your spreadsheet. It enhances the visual presentation of data while offering efficient navigation and customization options.
Below is an overview of the available features in this tab:
Basic Editing Functions
Save
Ensures that any changes made to the Canvas are saved. Regularly saving your work prevents data loss.
Undo & Redo
Allows users to revert or reapply recent actions:
-
Click the Undo or Redo arrows to navigate through previous changes.
-
Use the dropdown menu beside these icons to selectively undo or redo specific actions, including changes made to particular cells.
Formatting Tools
Format Painter
Copies the formatting of a selected cell or range and applies it to another area, ensuring consistency in design.
Copy Options (Dropdown: Cut, Paste, Paste Special)
-
Copy: Duplicates the selected content.
-
Cut: Moves the selected content.
-
Paste: Inserts copied or cut content.
-
Paste Special: Provides additional paste options, such as pasting only values, formulas, or formatting.
Advanced Design Features
Variables
Manage dynamic placeholders in formulas for easier adaptability. Variables simplify formula updates and avoide hardcoding values.
Designer Preview
Provides a real-time preview of the spreadsheet layout. This option helps in reviewing formatting changes before applying them.
Screen adjustments
Preview your Canvas at different screen sizes to ensure responsive design. The "Responsive" option automatically adapts the view to match the properties of your current monitor.
Deletion Tools
Delete
Removes a component that is no longer needed.
Updated June 13, 2025