“Range” utilities
Language:
In the Excel menu choose: ASAP Utilities » Range
- Find and/or replace in all sheets...
- Advanced sorting...
- Sort the data in random order
- 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
- Fill cells with their formatted value
- Copy formulas without changing their cell references...
- Move selected data (only values)...
- Copy multiple selected ranges...
- 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...
- 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 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.
Follow ASAP Utilities on Facebook
© 1999-2013 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands 
Connect with us and receive our "tip of the week" at:
