Count & Sum by Color
Advanced select, search, and replace
Another way to select, search, and replace cells and values
Maintain data accuracy in your Excel worksheets with our little helpers. Leverage handy at-a-glance options to find and fix broken links, fuzzy matches, typos, and similar entries. Use the advanced find capabilities to search and replace in several workbooks at a time. Detect cells with the same data and cells that contain formulas, comments, pictures, or conditional formats. Filter a list by value in a selected cell or filter multiple values in one column.
Look for typos in your text cells
Search in values, formulas, hyperlinks, comments
Perform search in the chosen area or sheets
Replace in all found cells or in the selected only
Find and inspect broken links
Get cells with conditional formatting selected
Select cells with text, numeric, or logical data
Find cells with errors, comments, or objects
Synchronize selection in all open workbooks
Filter tables by the selected values in a click
Manage your workbooks
Utilities for columns, comments, and watermarks
Ultimate Suite was designed to address the needs of all users that work with Excel on a daily basis. So, why don't we add a few more tools to make your life a little easier and your work a bit more comfortable? Just think of them as a nice bonus to help you manage your workbooks, watermarks, comments, and tables.
Create new watermarks and use text in them
Turn a picture into a watermark
Insert, move, delete, autofit columns on the fly
Quickly find and select any column
Convert cell contents to notes and vice versa
Move, insert, or rename sheets across workbooks
Merge and consolidate
Combine data from different sources in no time
If you deal with large worksheets, hundreds or thousands of rows in each, matching and merging data is always a nightmare… unless you have a few specialized wizards at your fingertips. From joining individual cells to consolidating multiple workbooks, Ultimate Suite covers all of the merging tasks you perform in Excel.
Pull matching data from another table
Add missing rows or columns to the main table
Join several cells keeping all data
Combine or aggregate rows by duplicate values
Consolidate and summarize worksheets
Copy several sheets into one
Create VLOOKUP formulas as an Excel expert
Use INDEX/MATCH when VLOOKUP is inutile
Dedupe and compare
Elegant solutions to...
BBEdit 是一款運行於蘋果作業系統的強大專業HTML文字編輯器，專門為Web作者和軟體開發人員的需求而製作，為編輯，搜尋和處理文字提供了豐富的高效能功能，具有強大的智慧搜尋、程式碼摺疊、FTP上傳等功能，是程式開發不可缺少的程式碼編輯器。智慧介面提供方便應用的最好的特徵包括grep模式匹配，搜尋和替換多個檔案，功能導航和語法著色的大量原始碼語言，FTP，SFTP開啟和儲存，AppleScript，Perl和OS X的UNIX指令碼支援，詞彙的支援，和一套完整的HTML工具。
Here are just a few of the things that are new or improved in BBEdit 14:
Notes - We know that many of our customers create a lot of untitled documents for quick note-taking, and rely on BBEdit's legendary stability and robust crash recovery to protect their work. We've added a new "Notes" feature in BBEdit 14, which provides a large variety of ways to create notes that automatically save themselves, and, perhaps more important, automatically title themselves so that you don't end up wondering which of your 305 "untitled text" documents is the one you're looking for.
Anaconda Virtual Environments - Anaconda is particularly popular with data scientists, as well as with others who need to rapidly switch between different tooling and library configurations. BBEdit 14 will use conda or miniconda to detect your virtual environments, and provides a mechanism for switching the active environment for use when running Unix tools and scripts from within BBEdit.
Enhanced Developer Features - BBEdit 14 enables several new features and significant improvements to its built-in coding aids for developers, including:
Enhanced language-specific text completions;
Improved Find Definition;
Assistance for specifying function parameters;
New code-navigation features;
In-window highlighting of syntax and semantic issues;
Language-specific document reformatting.
These feature improvements are the result of new built-in support for the Language Server Protocol ("LSP") by which user-installed local "language servers" implement key language-sensitive behaviors. Specific available features may vary by language and by server.
We've written extensive notes about the new and improved features, what they look like, and how they work.
New Built-In Languages - BBEdit 14 adds built-in syntax coloring and function navigation support for Go, R, Rust, Lisp-family languages (Common Lisp, Scheme, Clojure), and Pixar Universal Scene Description (USD) text files.
Pattern Playgrounds - This was actually new in BBEdit 13, but is way too cool not to mention it again here. The "Pattern Playground" window provides an interactive interface for experimenting with the behavior of Grep patterns (regular expressions). This makes the process of creating complicated patterns much less trial-and-error, since you can see exactly what will match, and how, before committing to any irreversible actions.
Repeat Last Command -...
顯示 InDesign 和 InCopy 管理文字檔案的更改結果
CtrlChanges 是一個Adobe InDesign和Adobe InCopy插件，可讓使用者即時看見設計文字檔案的更改結果，節省寶貴的時間。因為它可以追蹤到所有的設計方案中修改過程，然後顯示出來讓您一目瞭然；在瀏覽工具裡，有添加和刪除文字檔案的功能。
Keep track of all text changes in a document
Display added text in Layout view
Display removed text in Layout view
Keep track of who made which changes
Keep track of when changes were made
Include changes in PDFs
Filter on user, layer or date (time frame)
Localized language support: Swedish, English, German, Frensch, Japanese and Italian
CtrlChanges - Mouse over tip showing editor, time and deleted text
The best tool for inserting text templates 插入文本模板的最佳工具
Fixed: Bug with accent characters when abbreviations are used.
Added:"Copy\Paste as plain text" and "Type in" functions now work for all items (text, rtf, clips).
Improved: Window for %List()% macro now dynamically adjust own size.
Added: Japanese localization.
Improved: A few of other small bug-fixes and improvements.