The ASAP Utilities menu in Excel (English)
“Format” utilities
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語In the Excel menu choose: ASAP Utilities › Format
- Copy a sheet's page and print settings...
- Insert workbook's path and name in header, footer or cell...
- Empty all headers and footers
- Detect and visualize adjacent data/group changes...
- Transpose column in multiple steps...
- The paper saver (split columns)...
- Wrap text
- Unwrap text
- Drawing paper...
- Place a border around each page
- Delete all borders inside selection
- Use a significant number of decimals...
- Subscript the numbers in Chemical Formulas
- Unmerge cells in selection
- Center across selection (without merging)
- Clean data and formatting...
- Remove all unused styles on every sheet
- Remove all validations in selected cells
- Remove all conditional formatting in selection
- Replace conditional formatting with static formatting in selection
- Count and/or color duplicates in selection...
- Count duplicates and give each set of duplicates its own color
- Copy and apply cell's formatting settings...
- Apply standard format to selected cells
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.