ASAP Utilities – Utilitário para Excel
O ASAP Utilities é um add-in para Excel que adiciona mais de 300 funções e fórmulas, preenchendo algumas lacunas no Excel e que permitem poupar imenso tempo. São tantas que demora um pouco até se conseguirem explorar.
É um excelente suplemento para quem passa muito tempo com o Excel e quem me dera a mim tê-lo encontrado mais cedo.
Só a possibilidade de exportação de tabelas de Excel para HTML poupa-me imensas horas de trabalho e abre nova possibilidades neste site, ao facilitar a publicação de muita coisa, especialmente na área dos preços.
Menu Sheets
- Add new worksheet (fill in a name)…
- Insert multiple sheets (uses the cell values as sheet names)…
- Rename current sheet…
- Quickly rename multiple sheets at once…
- Change name of selected sheets to selected cell’s value
- Insert sheet(s) name in selected cell(s)
- Sort all sheets…
- Create an index page with links to all sheets (clickable)…
- Split the selected range into multiple worksheets…
- Export worksheets as separate files…
- Remove all empty worksheets
- Unhide all sheets
- Hide selected sheets
- Hide selected sheets extra (xlVeryHidden)
- Protect multiple sheets at once…
- Unprotect multiple sheets at once…
- Print multiple sheets at once…
- Copy a sheet’s page and print settings…
- Set print area on selected worksheets
- Clear the print area on selected sheets
- Remove all page breaks on the selected worksheets
- Freeze panes on multiple sheets at once
- Unfreeze panes on multiple sheets at once
- Put together rows or columns from several sheets…
- Remove all unused styles on every sheet
- Delete unused empty ending rows/columns
- Reset Excel’s last cell
Menu range
- Find and/or replace in all sheets…
- Advanced sorting…
- Sort the data in random order
- Sort values inside each cell in selection…
- Flip selected cells
- Move screen (place selection in top-left of screen)
- Show selection in center of screen
- Custom formula error message…
- Paste special (with combinations)…
- Paste values and formatting
- Paste values only
- Copy selection and paste into only the visible cells…
- Fill cells with their formatted value
- Replace conditional formatting with static formatting in selection
- Copy formulas without changing their cell references…
- Move selected data (only values)…
- Copy and paste multiple selected ranges at once…
- Transpose data with formulas…
- Split the selected range into multiple worksheets…
- Clear duplicated values in selection (leave one original)
- Count and/or color duplicates in selection…
- Count duplicates and give each set of duplicates its own color
- Create a list of all range names in the workbook
- Replace the range names used in formulas with their cell references (on selected sheets)
- Delete all range names in selection
- Delete all range names in the entire workbook
- Delete all range names with an invalid cell reference (#REF!)
Menu Columns & Rows
- Conditional row and column select, hide or delete…
- Advanced sorting…
- Color each n’th row or column in selection…
- Detect and visualize adjacent data/group changes…
- Merge column data (join cells)…
- Merge row data (selected cells)…
- Merge row data, separate cells by a line break
- Insert empty rows or columns in between…
- Insert multiple empty rows at once…
- View and manage hidden rows and columns…
- Delete all hidden rows and/or columns…
- Delete all empty rows
- Delete all empty columns
- Autofit row height (also on merged cells)
- Clean data and formatting…
- Drawing paper…
- Transpose column in multiple steps…
- The paper saver (split columns)…
- Put together rows or columns from several sheets…
- Delete unused empty ending rows/columns
- Reset Excel’s last cell
Menu Numbers & Dates
- Apply formula/calculation to selected cells…
- Change formulas to their calculated values
- Convert unrecognized numbers (text?) to numbers
- Change values to text values (adding ‘ in front)
- Fill cells with their formatted value
- Change negative numbers to positive and vice versa…
- Move minus sign from back to front (e.g. 65- to -65)
- Use a significant number of decimals…
- Convert percentages to numbers (e.g. 5% to 5)
- Spell/write out numbers or amounts (EN, DE, FR, NL)…
- Round numbers (not formatting, but changing)…
- Fill up with leading zeros…
- Quick numbering of selected cells…
- Random numbering of cells (without duplicates)
- Convert/recognize dates…
- Change Julian dates to normal dates
Menu Text
- Insert before and/or after each cell in your selection…
- Change to UPPERcase
- Change to lowercase
- Start first word with Uppercase
- Make first character Uppercase, the rest lowercase
- Start Each Word With Uppercase
- Change Case (with options)…
- Spell/write out numbers or amounts (EN, DE, FR, NL)…
- Convert/recognize dates…
- Delete leading and trailing spaces
- Delete leading, trailing and excessive spaces
- Clean data and formatting…
- Find and/or replace in all sheets…
- Advanced character remove or replace…
- Replace accented characters (á, ë, ñ etc.)…
- Delete all text characters (a-z) in selected cells
- Delete all numbers in selection
- Remove ending carriage return (Alt+Enter)
- Delete number of leading characters…
- Delete number of ending characters…
- Delete all after a given number of characters…
- Subscript the numbers in Chemical Formulas
- Make last character superscript
- Make last character subscript
- Reverse text in selected cells
- Sort values inside each cell in selection…
Menu Formulas
- Change formulas to their calculated values
- Apply formula/calculation to selected cells…
- Custom formula error message…
- Transpose data with formulas…
- Copy formulas without changing their cell references…
- Change formula reference style (e.g. A1 to $A1 etc.)…
- Replace the range names used in formulas with their cell references (on selected sheets)
- Rebuild array formulas
- Insert an apostrophe (‘) in front of each formula in the selected cells
- Report the formulas used in the worksheets in your workbook
- Insert “international” formula…
- Insert function from the ASAP Utilities library…
- Correct the link to the ASAP Utilities worksheet functions
Menu Fill
- Fill empty cells in selection…
- Overwrite filled cells in selection…
- Copy values to empty cells below filled cells in selection
- Fill up with leading zeros…
- Insert before and/or after each cell in your selection…
- Fill ‘between values’ linear in selection (vertical)
- Fill ‘between values’ linear in selection (horizontal)
- Quick numbering of selected cells…
- Random numbering of cells (without duplicates)
- Insert current date and time with seconds
- Insert current time with seconds
- Insert workbook’s path and name in header, footer or cell…
- Create a list of filenames and properties in a folder…
- Insert sheet(s) name in selected cell(s)
Menu System
- Save file and create backup…
- Save file as… and use the first cell as the suggested filename
- Rename current file…
- Reopen current file without saving changes
- Export selection or active sheet as new file…
- Export worksheets as separate files…
- Find and/or remove external links…
- Change Excel’s default file location (browse)…
- Set default path to current file
- Display the full path and file name in the titlebar
- Display file name in titlebar
- Close and delete current file
- Close all saved files
- Close multiple files at once…
- Close all open files without saving changes
- Add current file to recent files list
- Clear recently used files list in the Excel menu
- Remove all macros (VBA code) from current file
- Macro/VBA information (beta, English)…
- Resize the Excel window to standard screen resolutions…
- Save current file (developers)…
- Create a list of all add-ins
- Reload all installed add-ins (rebuilds the menu)
- Create a list of filenames and properties in a folder…
- Easily create a lot of folders based on the values in selected cells…
Menu Import
- Insert Excel file…
- Insert (delimited) text file…
- Insert dBASE file…
- Insert text file separated by space…
- Insert text file separated by tab…
- Insert text file separated by comma (csv file)…
- Insert text file separated by “|” (pipe/bar)…
- Insert text file separated by “!” (exclamation mark)…
- Insert text file (with options)…
- Merge and/or import multiple files…
- Create a list of filenames and properties in a folder…
Menu Export
- Export selection or active sheet as new file…
- Export selection as HTML table to clipboard…
- Export selected chart or range as image (file)…
- Export worksheets as separate files…
- Copy selection as values to clipboard
- Copy sum of selection to clipboard
- Copy average of selection to clipboard
- Put the selection as bitmap-image on the clipboard (as on screen)
- Put the selection as image on the clipboard (as on screen)
- Put the selection as image on the clipboard (as on printer)