Use Quick Access Toolbar through 4 how-to topics in WPS Spreadsheet on macOS; 4 are available without membership and 0 are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Use default commands | Free |
| 2 | 2. Open the Quick Access Toolbar menu | Free |
| 3 | 3. Adjust toolbar display options | Free |
| 4 | 4. Add or remove custom commands | Free |
How-to Guide
1. Use default commands
Entry: Quick Access Toolbar below the title bar
- Open WPS Spreadsheet and go to the workbook you want to edit.
- Find Quick Access Toolbar below the title bar.
- Click Save to save the current file quickly.
- Click Undo to reverse the previous action.
- Click Redo to restore an undone action.
Success Criteria
- Interface result: The Save, Undo, and Redo buttons on the toolbar can be clicked normally.
- Next action: You can continue editing, and undo or redo takes effect immediately.
Tips While Using
- Common mistake: If the file has not changed, Undo or Redo may have nothing to apply.
2. Open the Quick Access Toolbar menu
Entry: The drop-down arrow on the right side of Quick Access Toolbar
- Open WPS Spreadsheet and locate Quick Access Toolbar.
- Click the drop-down arrow on the right side of the toolbar.
- Review the menu options that appear.
- Choose the next display or customization action you need.
Success Criteria
- Interface result: The drop-down menu opens successfully.
- Next action: You can see options related to display controls and custom commands.
Tips While Using
- Common mistake: If you click outside the arrow area, the menu may not open.
3. Adjust toolbar display options
Entry: The drop-down menu on the right side of Quick Access Toolbar
- Click the drop-down arrow on the right side of Quick Access Toolbar.
- Review the display-related options in the menu.
- Choose whether to show or hide the ribbon.
- Choose whether to show or hide ribbon group names.
- Turn ribbon centering or automatic ribbon collapse on or off as needed.
Success Criteria
- Interface result: The ribbon or group-name display changes, and the layout updates based on your selection.
- Next action: You can continue editing the spreadsheet with the updated interface layout.
Tips While Using
- Common mistake: If you switch several display options in a row, the interface may change a lot, so it helps to confirm each change one by one.
4. Add or remove custom commands
Entry: Custom command options or More Commands in the Quick Access Toolbar drop-down menu
- Click the drop-down arrow on the right side of Quick Access Toolbar.
- Find the command you want to show or hide.
- Select the command to add it to or remove it from Quick Access Toolbar.
- If you need more options, click More Commands for additional settings.
- Return to the spreadsheet and confirm that the toolbar buttons have updated.
Success Criteria
- Interface result: The new command appears on Quick Access Toolbar, or the unwanted command is removed.
- Next action: The updated commands can be clicked directly.
Tips While Using
- Common mistake: Removing a frequently used command can interrupt your routine, but you can add it back from the menu.