Change Excel formula reference types

Formula Ref Changer and Sheet Index Creator in detail

Formula Reference Changer

Extremely handy add-in that will instantly change your formulae references from Absolute to Relative and vice versa. Works on Selection, Active sheet or the entire Workbook.

Formula Reference Changer

Sheet Index Creator

Have a workbook with a large number of Worksheets? Find it hard and too time consuming navigating through all the sheets? This option allows you to easily create an Index Sheet that has click-able links to all sheets. It also has the option of placing a "Back to Index" link on all the sheets.

Sheet Index Creator

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Name Splitter - Split names into several Excel cells.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..