The ASAP Utilities menu in Excel (English)
“Range” utilities
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語In the Excel menu choose: ASAP Utilities › 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!)
Submenu screenshot
Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu
Excel 2003, 2002/XP or 2000 with ASAP Utilities in its menu
« Return to the list of tools.