Workbook Explorer | Favorites & Formulas Manager | Workbook Utilities
The Spreadspeed Favorites tool offers two ways to increase your productivity with Excel. First, you can bookmark a worksheet (down to the range level), so you can quickly open the file and navigate to a sheet, table, or cell. Second, the favorite Formulas tab lets you save custom formulas for later re-use.
When you add a new favorite, you can specify the title, workbook, worksheet, and range, as shown in the Add to Favorites image below. You can also organize the favorites by groups, so that they will display in a tree outline in the favorites panel, as shown below right.
In addition to favorite Excel files, you can also save favorite formulas. After creating a formula, you can add it to your favorites via the Spreadspeed ribbon or via the favorites task pane (side panel). You will be prompted with the Add Formula form show below. The formula is captured in R1C1 format, which is a formula format with relative range references. The formula listing is shown in the image below right. To reuse a formula, simply select a cell on the worksheet and click the Insert button.
Workbook Explorer | Favorites & Formulas Manager | Workbook Utilities