Working with Sheets¶
OpenSheets supports multiple sheets within a single workbook. Each sheet has its own independent grid of cells, formatting, and data. Sheet tabs appear at the bottom of the application window.
Switching Between Sheets¶
- Click a sheet tab to switch to that sheet.
- Alt+Shift+Right -- move to the next sheet.
- Alt+Shift+Left -- move to the previous sheet.
When you switch sheets, the selection resets to cell A1 on the target sheet.
Adding a Sheet¶
Click the + button at the end of the sheet tab bar. A new sheet is created with an auto-generated name (Sheet2, Sheet3, etc.) and becomes the active sheet.
You can also right-click any sheet tab and select Insert sheet from the context menu.
Renaming a Sheet¶
Double-click a sheet tab to rename it. A prompt appears where you can type the new name. Sheet names must be unique within the workbook; if you enter a duplicate name, an error message is shown and the rename is cancelled.
You can also right-click the tab and select Rename from the context menu.
Deleting a Sheet¶
Right-click a sheet tab and select Delete from the context menu. A confirmation dialog appears before the sheet is removed.
The last remaining sheet in a workbook cannot be deleted. If only one sheet exists, the delete option will show an alert and take no action.
Keyboard Shortcuts¶
| Action | Shortcut |
|---|---|
| Next sheet | Alt+Shift+Right |
| Previous sheet | Alt+Shift+Left |
Cross-Sheet References¶
You can reference cells on other sheets in formulas using the syntax:
For example, =Sheet2!B5 references cell B5 on the sheet named "Sheet2".