“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.
© 1999-2022 - 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:
