Sitemap
- Home
- Tools
- Downloads
- Pricing
- Support
- Company
- Product
- Legal
- Contact
- Complete Tool Catalog
- My Tools & Shortcuts
- Display & Navigation...
- Select
- 1. Advanced Criteria-Based Cell Selection...
- 2. Select, Hide, or Delete Rows or Columns Based on Custom Criteria...
- 3. Move, Extend, or Shrink Range Selections...
- 4. Deselect Cells...
- 5. Invert Range Selection...
- 6. Merge Contiguous Range Selections
- 7. Select Adjacent Matching Cells Below the Active Cell
- 8. Select Adjacent Matching Cells in the Column
- 9. Extend Selection to the Lowest Used Row
- 10. Extend Selection to the Rightmost Used Column
- 11. Jump to the First Different Value in a Selection
- 12. Select Cells Containing the Lowest Value
- 13. Select Cells Containing the Highest Value
- 14. Select All Cells Where Formulas Return an Error
- 15. Select All Sheets
- 16. Select All Objects
- 17. Print Preview Selection
- 18. Print Selection
- 19. Apply Current Range Selection to All Worksheets
- Sheets
- 1. Quickly Insert a Named Worksheet...
- 2. Insert Multiple Sheets Using Cell Values as Names...
- 3. Rename Active Sheet...
- 4. Quickly Rename Multiple Sheets at Once...
- 5. Rename Selected Sheets Using a Cell's Value
- 6. Insert Sheet Names Across Selected Sheets
- 7. Sort All Sheets...
- 8. Create an Index Page (TOC) with Clickable Links to All Sheets...
- 9. Split Selected Range into Worksheets Based on Column Value or Row Count...
- 10. Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
- 11. Remove All Empty Worksheets
- 12. Unhide All Sheets at Once
- 13. Hide Selected Sheets
- 14. Hide Selected Sheets as xlVeryHidden
- 15. Protect Multiple Sheets at Once...
- 16. Unprotect Multiple Sheets at Once...
- 17. Print Multiple Sheets at Once...
- 18. Copy Page Setup and Print Settings to Other Sheets...
- 19. Set Print Area on Selected Sheets
- 20. Clear Print Area on Selected Sheets
- 21. Reset All Page Breaks on Selected Sheets
- 22. Freeze Panes on Multiple Sheets at Once
- 23. Unfreeze Panes on Multiple Sheets at Once
- 24. Copy and Stack Rows or Columns from Multiple Sheets...
- 25. Remove Unused Styles from All Worksheets
- 26. Delete and Reset Empty Ending Rows and Columns on Selected Sheets
- 27. Reset Last Cell to Fix Ctrl+End Behavior...
- Range
- 1. Advanced Find and Replace...
- 2. Advanced Sorting...
- 3. Sort in Random Order
- 4. Sort Values Inside Each Cell...
- 5. Flip Selected Cells
- 6. Scroll to Selection (Align to Top-Left)
- 7. Scroll to Selection (Align in Center)
- 8. Replace Formula Errors with a Custom Message...
- 9. Paste Special with Combined Options...
- 10. Paste Values and Formatting
- 11. Paste Values Without Formatting
- 12. Copy Visible Cells and Paste to Visible Cells in Target Range...
- 13. Replace Values with Their Formatted Value
- 14. Freeze Conditional Formatting as Static Formatting in Selected Cells
- 15. Copy Formulas Without Changing Their Cell References...
- 16. Cut and Paste as Values (Keeping Dependents Unchanged)...
- 17. Copy and Paste Multiple Ranges at Once...
- 18. Copy and Transpose Without Changing Formula References...
- 19. Split Selected Range into Worksheets Based on Column Value or Row Count...
- 20. Clear Duplicate Values in Selection (Keep One Original)
- 21. Count Duplicate Values in Selection (Optional Coloring)...
- 22. Highlight Each Set of Duplicates with a Different Color
- 23. List All Named Ranges in Workbook
- 24. Replace Named Ranges in Formulas with Cell References
- 25. Delete All Defined Range Names in Selection
- 26. Delete All Defined Range Names in Workbook
- 27. Delete Named Ranges with Invalid Cell References (#REF!)
- Fill
- 1. Fill Blank or Empty Cells with a Specific Value...
- 2. Overwrite Filled Cells with a Specific Value...
- 3. Fill Blank Cells with Value from Above
- 4. Add Leading Zeros to Reach Specific Length...
- 5. Add Text to Beginning and/or End of Selected Cells...
- 6. Fill Vertical with Linear Trend Series (Columns)
- 7. Fill Horizontal with Linear Trend Series (Rows)
- 8. Auto Numbering and Labeling of Selected Cells...
- 9. Insert Unique Random Numbers
- 10. Insert Current Date and Time with Seconds
- 11. Insert Current Time with Seconds
- 12. Insert Date Using a Calendar Popup...
- 13. Insert Workbook's File Path and Name in Header, Footer or Cell...
- 14. List File Names and Properties from Folder...
- 15. Insert Sheet Names Across Selected Sheets
- Columns & Rows
- 1. Select, Hide, or Delete Rows or Columns Based on Custom Criteria...
- 2. Advanced Sorting...
- 3. Color Every nth Row or Column in Selection...
- 4. Insert Visual Breaks Between Groups in a Column...
- 5. Join Selected Values Horizontally with a Delimiter...
- 6. Join Selected Values Vertically with a Delimiter...
- 7. Join Selected Values Vertically with a Line Break Separator
- 8. Insert Blank Rows or Columns Between Every Row or Column...
- 9. Insert a Specified Number of Empty Rows at Once...
- 10. Choose and Unhide Hidden Rows and Columns...
- 11. Delete All Hidden Rows, Columns, or Both...
- 12. Delete All Empty Rows
- 13. Delete All Empty Columns
- 14. Fix Autofit Row Height with Merged Cells and Hidden Columns
- 15. Clean Up Data and Formatting...
- 16. Set Cell Size in Centimeters, Inches, or Pixels...
- 17. Reshape Single Column into Table Form (Transpose in Steps)...
- 18. Split Long Dataset to New Sheet for Printing in Fewer Pages...
- 19. Copy and Stack Rows or Columns from Multiple Sheets...
- 20. Delete and Reset Empty Ending Rows and Columns on Selected Sheets
- 21. Reset Last Cell to Fix Ctrl+End Behavior...
- Objects & Comments
- 1. Edit, Extract, and Manage Comments and Notes...
- 2. Add Cell's Value or Formula to Comment...
- 3. Select All Objects
- 4. Delete All Objects in Selected Worksheet(s)
- 5. Delete All Form Buttons in Selected Worksheet(s)
- 6. Resize Pictures and OLE Objects (% of Original Size)...
- 7. Remove Border Line from Selected Shapes and Pictures
- Format & Layout
- 1. Copy Page Setup and Print Settings to Other Sheets...
- 2. Insert Workbook's File Path and Name in Header, Footer or Cell...
- 3. Clear All Headers and Footers in Selected Sheets
- 4. Insert Visual Breaks Between Groups in a Column...
- 5. Reshape Single Column into Table Form (Transpose in Steps)...
- 6. Split Long Dataset to New Sheet for Printing in Fewer Pages...
- 7. Wrap Text in Selected Cells
- 8. Unwrap Text in Selected Cells
- 9. Set Cell Size in Centimeters, Inches, or Pixels...
- 10. Add a Border Around the Data on Each Printed Page
- 11. Remove All Inside Borders in Selection
- 12. Show a Significant Number of Non-Zero Decimals...
- 13. Subscript Numbers in Chemical Formulas
- 14. Unmerge Selected Cells
- 15. Center Horizontally Across Selection Without Merging
- 16. Clean Up Data and Formatting...
- 17. Remove Unused Styles from All Worksheets
- 18. Remove All Data Validation from Selected Cells
- 19. Remove All Conditional Formatting from Selection
- 20. Freeze Conditional Formatting as Static Formatting in Selected Cells
- 21. Count Duplicate Values in Selection (Optional Coloring)...
- 22. Highlight Each Set of Duplicates with a Different Color
- 23. Copy and Apply Certain Cell Formatting Settings...
- 24. Reset Formatting to Normal Style in Selected Cells
- Numbers & Dates
- 1. Apply Calculation to Selected Cells...
- 2. Convert Formulas in Selection to Static Values
- 3. Convert Numbers Stored as Text to Real Numbers
- 4. Insert Leading Apostrophe to Store Numbers as Text
- 5. Replace Values with Their Formatted Value
- 6. Change Number Signs: Reverse or Make All Positive or Negative...
- 7. Fix Trailing Minus Sign: e.g., Convert 50- to -50
- 8. Show a Significant Number of Non-Zero Decimals...
- 9. Convert Percentages to Numbers (e.g., 5% to 5)
- 10. Spell Numbers or Amounts in Words...
- 11. Permanently Round Numbers Without Using Formulas...
- 12. Add Leading Zeros to Reach Specific Length...
- 13. Auto Numbering and Labeling of Selected Cells...
- 14. Insert Unique Random Numbers
- 15. Convert Text Dates to Usable Excel Dates...
- 16. Convert Julian Dates (yyddd, yyyyddd, or cyyddd) to Standard Excel Dates
- 17. Insert Date Using a Calendar Popup...
- Text
- 1. Add Text to Beginning and/or End of Selected Cells...
- 2. Change to UPPERCASE
- 3. Change to lowercase
- 4. Change to Capitalize First Letter Only
- 5. Change to Capitalize First Letter and Lowercase the Rest
- 6. Change to Capitalize Each Word (Title Case)...
- 7. Change Text Case with Multiple Capitalization Options...
- 8. Spell Numbers or Amounts in Words...
- 9. Convert Text Dates to Usable Excel Dates...
- 10. Remove Leading and Trailing Spaces
- 11. Remove Leading, Trailing, and Extra Spaces Between Words
- 12. Remove Leading and Trailing Line Breaks
- 13. Clean Up Data and Formatting...
- 14. Advanced Find and Replace...
- 15. Remove or Replace Unwanted Characters...
- 16. Remove Accents from Letters (e.g., é → e, ñ → n)...
- 17. Remove All Letters (A-Z)
- 18. Remove All Numbers (0-9)
- 19. Remove Trailing Line Breaks (e.g., Alt+Enter)
- 20. Remove First X Characters...
- 21. Remove Last X Characters...
- 22. Keep Only the First X Characters...
- 23. Subscript Numbers in Chemical Formulas
- 24. Apply Superscript Formatting to Last Character
- 25. Apply Subscript Formatting to Last Character
- 26. Reverse Text
- 27. Sort Values Inside Each Cell...
- Formulas
- 1. Convert Formulas in Selection to Static Values
- 2. Apply Calculation to Selected Cells...
- 3. Replace Formula Errors with a Custom Message...
- 4. Copy and Transpose Without Changing Formula References...
- 5. Copy Formulas Without Changing Their Cell References...
- 6. Change Formula Reference Style (A1, $A1, A$1, $A$1)...
- 7. Replace Named Ranges in Formulas with Cell References
- 8. Reapply CSE (Ctrl+Shift+Enter) Array Formulas
- 9. Convert Formulas in Selected Cells to Text by Inserting an Apostrophe
- 10. List All Formulas Used in Workbook
- 11. Insert US English Formula and Convert to Local Format...
- 12. Insert Function from the ASAP Utilities Library...
- 13. Fix Broken Links to ASAP Utilities Worksheet Functions
- Web Data
- 1. Clean Up Data and Formatting...
- 2. Remove All HTML Tags in Selected Cells...
- 3. Decode URL and HTML Encoded Text in Selected Cells
- 4. Extract Hyperlink Addresses from Cells and Shapes...
- 5. Create Hyperlinks from Cell Values...
- 6. Convert Hyperlinks to =HYPERLINK() Formulas in Selected Sheets
- 7. Remove All Hyperlinks from Selected Cells
- 8. Copy Selection as HTML Table (for Web Pages)...
- 9. Visit our Website for Helpful Tips, Tools, and Resources
- Info & List
- 1. Analyze Selected Cells: Count, Sum, and More...
- 2. Workbook and Selection Details...
- 3. Copy Full File Path of Workbook to Clipboard
- 4. Find the Printed Page Number of the Active Cell
- 5. Count Duplicate Values in Selection (Optional Coloring)...
- 6. Highlight Each Set of Duplicates with a Different Color
- 7. Count Distinct Values in Selection
- 8. Count Characters in Selected Cell...
- 9. List Document Properties from Workbook (Title, Author, etc.)
- 10. List All Named Ranges in Workbook
- 11. List All Sheet Names in Workbook
- 12. List All Formulas Used in Workbook
- 13. Create a Visual Map of Cell Types in a New Workbook
- 14. List File Names and Properties from Folder...
- 15. Display VBA Selection Type (Range, Chart, Picture, etc.)
- 16. Count All Worksheets, Chart Sheets, and Macro Sheets
- 17. Find #REF! Formula Errors (Broken References)
- 18. Find Columns Showing #### Errors (Too Narrow)
- 19. Display Screen Resolution and Working Area
- 20. Display Regional Settings Used by Excel (Separators & Date Format)
- 21. Create a List of Installed Excel and COM Add-ins
- 22. List Available Fonts in New Workbook
- File & System
- 1. Save File and Create Backup Copy with Timestamp...
- 2. Open Save As Dialog with First Cell as Suggested File Name...
- 3. Rename Current File...
- 4. Reopen Current File Without Saving Changes
- 5. Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...
- 6. Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
- 7. Find and Remove External References (Data Links) in Formulas...
- 8. Change Excel's Default Local File Location (Easier with Browse)...
- 9. Set Temporary Default File Location to Current Folder
- 10. Show Folder Paths and File Names in Title Bar
- 11. Display File Name in Title Bar
- 12. Close and Delete Current File
- 13. Close All Unchanged Files (Keep Unsaved Files Open)
- 14. Close Multiple Files at Once...
- 15. Close All Open Files Without Saving Changes
- 16. Add Current File to Recent Files List
- 17. Clear Multiple Files from Recent Files List...
- 18. Remove All Macros (VBA Code) from Current Workbook
- 19. Open Workbook's File Location in File Explorer
- 20. Resize Excel Window to Standard Screen Sizes...
- 21. Force Save Workbook (Ignore Workbook_BeforeSave Event)...
- 22. Create a List of Installed Excel and COM Add-ins
- 23. Reload Installed Excel Add-ins (Refresh Menus and Commands)
- 24. List File Names and Properties from Folder...
- 25. Create Folder Structure in a Destination Folder from Cell Values...
- Import
- 1. Import Excel File into Workbook...
- 2. Import Data From Delimited Text File (Custom Options)...
- 3. Import Data from dBASE (.dbf) File...
- 4. Import Data From Space-Delimited Text File...
- 5. Import Data From Tab-Delimited Text File...
- 6. Import Data from Comma-Delimited (CSV) File...
- 7. Import Data From Pipe-Delimited (|) Text File...
- 8. Import Data from Exclamation-Delimited (!) Text File...
- 9. Import Data From Text File Using Wizard...
- 10. Merge and Import Multiple Files (TXT, CSV, Excel, etc.)...
- 11. List File Names and Properties from Folder...
- Export
- 1. Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...
- 2. Copy Selection as HTML Table (for Web Pages)...
- 3. Export Selected Chart or Range as Image (PNG, JPG, EMF, etc.)...
- 4. Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
- 5. Copy Selection as Values to Clipboard
- 6. Copy Sum of Selected Cells to Clipboard
- 7. Copy Average of Selected Cells to Clipboard
- 8. Copy Selection as Bitmap Picture (As Shown on Screen)
- 9. Copy Selection as Picture (As Shown on Screen)
- 10. Copy Selection as Picture (As Shown When Printed)
- Start
- ASAP Utilities Options
- 1. Settings, Language, and Contact Information...
- 2. Manage My Tools & Shortcuts...
- 3. Enter License...
- 4. Buy ASAP Utilities License
- 5. View Pricing, License Benefits, and Discounts on Our Website
- 6. Contact Us
- 7. Start the Last Used Tool Again...
- 8. Find and Run a Tool...
- 9. Open the ASAP Utilities User Guide (English, PDF)
- 10. View the Tip of the Day on Our Website
- 11. Check for News and Updates on Our Website
- 12. Open the FAQ and Support Page on Our Website
- 13. Check if a New Version is Available on Our Website
- 14. Try Fully Usable Tools in Development (English Only)...
- 15. Close and Unload ASAP Utilities from Excel
- 16. See How Much Time and Money You Saved with ASAP Utilities
- Find and Run a Tool...
- Start the Last Used Tool Again...
- About...
More Pages and Resources
Some pages below still use our previous website design while we continue improving and expanding the new website.
- Tip of the Day
- Yesterday's Tip of the Day
- Tomorrrow's Tip of the Day
- News
- Alternative download options
- About the author of ASAP Utilities
- Receive our newsletter
- Tips on our blog
- Excel keyboard shortcuts overview
- Links to interesting websites
- Recommended Excel books
- Get Support: How to Provide Details
- Debug information for support
- Home&Charity Edition required upgrade
- License Benefits: Professional vs. Home & Charity
- For reference: Step by step installation
- Download versions covered by your license.
- Top 10 Reasons to use ASAP Utilities in Excel
- Use ASAP Utilities in the language most comfortable to you
- Upgrade to the latest version
- Compare version changes
- Setup Information for the IT department
- ASAP Utilities setup commandline parameters