XLplus Add-On: Goto Sheet
Use Goto Sheet, in order to conveniently activate a worksheet or chart.
Tip: Use the lower right corner of the dialog in order to change its size.
First choose the workbook of which to activate a sheet or chart. Next specify the sheet or chart.
Click on the column header of the list of sheets in order to sort its direction. Click again, to change the sort direction.
Especially in case of complex spreadsheets with a lot of charts included the sorted list of sheets or charts eases up selection of a desired sheet or chart.
Use OK in order to activate the selected sheet or chart.
Comment:
MS Excel offers an acceptable method of selecting a sheet from a bunch of sheets but this still gets hard having a great amount of sheets to select from. It gets even more complicated when trying to differentiate sheets from charts, too. It is the same as
zooming a special set of sheets from within a great number of sheets given using MS Excel build-in functionality - up from a given amount of sheets to work with a sortable list can´ t be bet.
See also:
XLplus Delete Hyperlinks
XLplus Save All Workbooks
XLplus Close Workbooks
XLplus Delete Worksheets
XLplus Insert Sheets
XLplus Show Hidden Sheets
XLplus Hide Sheets
XLplus Manage Hidden Cells
XLplus Sort Sheets
XLplus View Special Cells
XLplus Number To Text
XLplus Rename Worksheets
XLplus Convert Characters
XLplus Work with Shapes
XLplus Regional Settings
XLplus Set Zoomfactor of Worksheets