Home
Screenshots
10 Languages
Why use it?
Download
Purchase
Contact Us
Blog
Download
License Agreement (EULA)
Download ASAP Utilities (recommended)
Upgrade to the latest version
Version history
Compare version changes
Alternative download options
System requirements
Upgrade once a year (Home&Student ed.)
Buy license
Order your license(s)
Payment Methods
Pricing and volume discounts
Sales, upgrades and Refunds Policy
When to buy a license, when is it free?
License Agreement (EULA)
Example of the ordering process + help
What is it?
What is ASAP Utilities
Screenshots of ASAP Utilities
The primary goals of ASAP Utilities
About the author of ASAP Utilities
System requirements
Nederlands: Makkelijker werken in Excel
Examples of how to use ASAP Utilities
Why use it?
Top reasons to use ASAP Utilities
Examples of how to use ASAP Utilities
Features
Descriptions of all tools in ASAP Utilities
Search within the ASAP Utilities tools
Added worksheet functions
Fully expanded list of all menu items
Some screenshots of ASAP Utilities
Examples of how to use ASAP Utilities
Testimonials
Testimonials, feedback from users
Reviews from the press
Clients, who uses ASAP Utilities?
User Guide
Download the User Guide
How to install ASAP Utilities
Detailed step by step installation
How to uninstall ASAP Utilities
Examples of how to use ASAP Utilities
News
Latest news
RSS Feed
Receive our Newsletter
Unsubscribe from our Mailing List
Excel tips
Excel tips
Excel keyboard shortcuts overview
Headlines from the best Excel weblogs
Links to interesting websites
Recommended Excel books
Excel version screenshots
Support
1. FAQ: Questions and answers
2. Search within our website
3. Version history
4. Bug report guidelines
5. Sitemap
6. Contact us
Home
Features
"Range" utilities
List of tools
A
description of all tools
in ASAP Utilities
Find a utility
Search in the descriptions
of all tools in ASAP Utilities
“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 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
.
Follow ASAP Utilities on Facebook
Home
Sitemap
Search
List of all utilities
Printer friendly page
^ Back to Top
© 1999-2019 -
Bastien Mensink
-
ASAP Utilities
-
A Must in Every Office BV
- The Netherlands
Connect with us and receive our tips that show you how to
benefit from the tools
in ASAP Utilities at: