For those of you who work with many sheets, sometimes you feel quite inconvenient if you want to find a sheet, add a new sheet, sort sheets, etc. I’m sure with this feature the inconvenience will not happen again.
The following is Sheets Utilities dialog box.
All sheets in the active workbook are displayed. You can see the sheet’s status whether it’s Visible, Hidden, or Very hidden.
You can choose sheets by clicking Select All, Select None, or give tick marked-mark to the sheets you desired.
Here is a brief description of the tools provided.
1. Show Sheets
Make selected sheets Visible if currently is Hidden or Very Hidden.
2. Hide Sheets
When selecting this button, you will be asked the following question:
Answer Yes if you want the sheets to be Very Hidden or No if you just want the sheets to be Hidden.
3. Add Sheets
Add new sheets. Enter the number of sheets you want to add.
4. Delete Sheets
Delete the selected sheets.
5. Sort Sheets
Sort all sheets numerically / alphabetically
6. Make Index
Add an index sheet to your workbook with hyperlinks to all other sheets.
0 komentar