ASAP Utilities 9.2 + Free

да, там много прибамбасов, но денег просит, скуповатые создатели

рибамбаса - пакет макросов "Методичка" называется. Архиудобнейшая вещь, отвечаю

Подтверждаю, не запускается

Можно ли с помощью данного плагина снимать защиту от редактирования?

можно ли здесь рассчитать объём горизонтального цилиндра

http://www.asap-utilities.com/faq-questions-answers-detail.php?m=271

Supported Excel versions
Excel 2000
Excel 2002/XP
Excel 2003
Excel 2007
Excel 2010 (32-bit version)
Excel 2013 (32-bit version)

на эксель 2010 надстройка не смогла запуститься, всё жалуется на отсутствие файла и пишет:
"Sorry, ASAP Utilities cannot be started. The file '' doesn't seem to exist. Please reinstall ASAP Utilities (or make sure the xlam file exists in the subfolder \resources\)."

New features and improvements:
Range > Advanced sorting: We've added a new sort option: "Value, ignore minus sign (-) in numbers"
Range > Advanced sorting: We've added a new sort option: "Reverse order"
NEW: Count and color unique duplicate values via ASAP Utilities Options > New tools in development (English only)
NEW: Insert a space before Capital Letters (e.g. 'BigBearLake' > 'Big Bear Lake') via ASAP Utilities Options > New tools in development (English only)
Import > Merge and/or import multiple files: New option to choose if the data should be copied/pasted as 'values' or 'formulas'.
Text > Replace accented characters (?, ?, ? etc.): Greek accented characters have been added.
Web > Decode all URL and HTML encoded text: Now also supports (all) Unicode characters (except when you run Excel in Windows 2000).
Setup, Trusted Publishers: During the setup you can now have our company (A Must in Every Office BV) automatically added to the List of Trusted Publishers in Excel
Customization, add tools to the Ribbon: The tools from ASAP Utilities are now easier to add to the QAT (Quick Access Toolbar) from Excel 2013/2010/2007
General: A few small improvements and a few spelling corrections.
Bug fixes and improvement:
Export > Export worksheets as separate files: The combination of a filtered table and excluding hidden rows/columns from the export could result in an error. This is now fixed.
Sheets > Change name of selected sheets to selected cell's value: Didn't work if the specified cell on the sheet was hidden. This is now fixed.
Formulas > Change formula reference style (e.g. A1 to $A1 etc.): Formulas that referenced to a cell with an error were skipped. Such formulas are now updated too.
Range > Find and/or replace in all sheets: The combination of "Find/replace in: Range" and "Look in: Formulas", didn't replace anything. This is now fixed.
Formulas > Change formula reference style (e.g. A1 to $A1 etc.): Formulas that referenced to a cell with an error or resulted in an error were skipped. These formulas are now updated too.
Copy to clipboard in Windows 8 x64: Due to a bug in the Windows 8 64-bit edition (only this edition), copying to the clipboard didn't work.
Information > Report the formulas used in the worksheets in your workbook: If you had a formula with a large number which was formatted as a date, then this could result in an "overflow" error. This is now fixed.
Web > Remove all HTML tags in the selected cells: Any text after the % character was decoded or removed. This is now fixed so that it only gets decoded and for example SQL statements that use % are now preserved.
Fill > Insert current date and time with seconds: The applied number format now shows the seconds too.
Text > Delete leading and trailing spaces: If a zero (0) was left as the result in a cell, then it was entered as "text". This is now corrected so that it is entered as a number.
Range > Fill cells with their formatted value is now also listed in the Numbers & Dates submenu: Numbers & Dates » Fill cells with their formatted value
Information > Fast calculation on selected cells: If you choose to "Create a workbook with these results" then the calculation results of the "Unique values" and "Values that appear only once" were switched.
Import > Merge and/or import multiple files: Speed improvement. In version 5.0 copying/preserving the row height on import was added, but it was slow for files with many rows. This is now fixed.
Columns & Rows > The paper saver (split columns): Didn't remember your last used settings. This is now fixed.
Language: The English term "wildcards" in the tools, has been replaced with the text "wildcard characters".
Speed improvement for editing data in Tables in Excel 2010 and Excel 2013: In Excel 2010/2013 some tools that edited data in a defined Table (a Table as via "Home > Format as Table" or "Insert > Table") on a worksheet with many formulas didn't run at the usual speed (sometimes it was even painfully slow). The speed difference could be huge compared to earlier Excel versions and compared to editing the same data when it was not in a defined Table*.
General: A few small bug fixes and improvements. When Excel 2013, 2010 or 2007 is doing something in the background and the running tool from ASAP Utilities has to wait for this, then this message is shown in the status bar "Waiting for response from Excel...".