When using Hide Worksheet, the most common questions fall into 3 areas: whether data stays in place, what collaborators can see, and why at least one sheet must remain visible. This section includes 3 common answers and a glossary.
FAQ
Does the data stay after I hide a worksheet?
- Yes. After you hide a worksheet, its data remains in the current workbook.
- Hiding only removes the worksheet tab from the tab bar.
- After you use Unhide from the All Sheets list, you can view the original content again.
Can other collaborators see a worksheet that I hid?
- The hidden state affects how the same file is displayed, so other collaborators do not see that worksheet directly in the tab bar when they open the file.
- If they need to view it again, they need to unhide it in a supported environment.
- For shared presentations of results, you can hide intermediate worksheets and keep result sheets visible.
Why can’t I hide every worksheet in the workbook?
- A workbook must keep at least one worksheet visible.
- When only one worksheet remains visible, that worksheet cannot be hidden.
- If you need to rearrange visibility, unhide another worksheet first and then adjust which sheets stay hidden.
Glossary
| Term | Definition |
|---|---|
| Worksheet tab | The named tab used to switch between worksheets in a spreadsheet. |
| All Sheets | The list entry that shows all worksheets in the current workbook, including hidden ones that can be restored. |
| Unhide | The action that restores a hidden worksheet so it appears again in the tab bar. |