• UA
• RU
• EN
• ⯈
  ES JA DE HI AR CN PT FR IT KO PL RO TR

Complete list of utilities included in the "YLC Utilities" extension

1) Text

• Change text to UPPER CASE Capitalizing all words
• Change text to lower case Writing all words in small letters
• Start text with a capital letter Writing the first word with a capital letter and the rest of the words in small letters
• Start all words with a capital letter Change the text so that each word starts with a capital letter
• First character in capital letter Change the first character in the text to a capital letter, but do not change the case of the remaining characters
• Other case variations > Sentence case, title case, Pascal case, camel case, snake case, kebab case, and space case
• Remove all letters in text Cleaning text by removing all letters in the text
• Remove all digits in text Cleaning text by removing all digits in the text
• Remove other characters > Other options for removing letters, digits, word characters, or sentence characters
• Remove trailing spaces in text Removing all spaces from the beginning and end of the text
• Remove extra spaces in text Removing all spaces at the beginning and end of the text, as well as extra spaces in the middle of the text
• Delete leading characters Deleting a certain number of characters at the beginning of the text
• Delete ending characters Deleting a certain number of characters at the end of the text
• Delete text after a certain number of characters Deleting all text starting from a certain position
• Get word by specified delimiters Splitting text into parts by many delimiters simultaneously and getting the required element by occurrence number
• Mark Latin letters in text Mark Latin letters in red
• Mark Cyrillic letters in text Mark Cyrillic letters in red
• Google Translate Translate text using the "Google Translate" website

2) Number

• Apply additional calculations to selected cells Quick insertion of additional calculations into a formula
• Change formulas to their calculated values Replacing the formula in selected cells with their calculated values
• Converting unrecognized numbers (text?) to numbers Changes numbers that appear as text and are not recognized by Excel (Calc) to true numerical values
• Change values to text (by adding ' in front) Changes all numbers in selected cells to text values
• Fill cells with their formatted value Replaces the content of selected cells with their formatted value
• Change negative numbers to positive and vice versa Changes positive numbers to negative, and negative numbers to positive
• Move the minus sign from the end to the beginning (e.g., 47- to -47) Corrects negative numbers that have a minus sign at the end
• Use a significant number of decimal places Performs rounding or applies the appropriate format for numbers in cells to display non-zero digits after the decimal comma/point
• Spell out a number or amount in words Converts numbers or an amount written in digits into text in English

3) Date

• Convert/Recognize Dates Converts unrecognized dates in selected cells
• Remove time component Removes time from the date in selected cells

4) Range

• Mark unique values Marking cells with unique values in yellow
• Mark distinct values Marking cells with distinct values in yellow
• Mark duplicates Marking cells with repetitions in different colors
• Mark redundant values Marking cells in yellow that are repetitions of previous values in the selected range
• Restructure table Unpivoting a cross-tabulated table into a flat one
• Create a drop-down list Allows easy creation of interactive drop-down lists for selecting values in forms or program interfaces
• Create a dependent drop-down list Allows creating dependent drop-down lists where selecting one value automatically affects the available options in the next list
• Insert checkboxes into selected cells Automatically inserts checkboxes into selected table cells, providing a convenient way to mark selected items
• Delete checkboxes in selected cells Allows quickly deleting checkboxes from selected table cells, providing convenient clearing of marked items
• Make font color as background Changes the font color to match the background color, creating the effect of hidden or merged text
• Convert conditional formatting to direct Converts conditional formatting to standard formatting, preserving applied styles without dependence on conditions

5) Formula

• Convert formula to text Save cell formula as text value
• Convert text to formula Save cell value as formula
• Display 'empty' if error Wrapping the cell formula in an IFERROR function with an alternative value of 'empty'
• Display '0' if error Wrapping the cell formula in an IFERROR function with an alternative value of '0'
• Show/hide formulas Toggling between formulas and values for all cells
• Insert YLC function Insert a function from the "YLC Utilities" set

6) Comment

• Copy value to comment Copying cell result to comment
• Copy formula to comment Copying cell formula to comment
• Copy comment to cell Copying comment to cell formula
• Move comment to cell Moving comment to cell formula with simultaneous deletion
• Show/hide comments Display/hide all comments
• Show/hide indicators Displays/hides all indicators on cells (red corner)
• Show/hide authorship Allows managing the display of authorship in comments, allowing to hide or show commentator names as needed
• Insert image Inserts an image directly into a comment, adding visual elements for better clarity and context
• Copy image to object Copy image in cell comment as a graphic object
• Save image to folder Save image in comment to a separate file in the selected folder
• Generate QR-code Create a QR-code based on text in the cell and save it in the comment
• Generate barcode Create a barcode based on text in the cell and save it in the comment

7) Worksheet

• Add sheets Insert new sheets into the workbook using names from selected cells
• Sort sheets Sort all sheets in alphabetical order (ascending or descending)
• Save sheets as workbooks Save selected sheets to separate files
• Make a list of worksheets Automatically creates a list of all worksheets in the workbook
• Rename worksheets Quickly and conveniently renames worksheets, ensuring structured document organization
• Change tab colors Allows changing tab colors, helping to easily distinguish and organize them visually in the document

8) Table Styles

• Excel Table formatting according to standard Excel color templates
• YLC Table formatting according to the selected YLC color template

9) External Data

• Official currency exchange rates Obtaining currency exchange rates from official websites of national banks of countries
• Insert table from image Recognizes and converts a table from an image into an editable tabular format, simplifying data work

10) Interface

• Address style (R1C1) Change formula style from alphanumeric (A1) to numerical (R1C1)
• Hide grid Hide cell gridlines
• Change input direction (Right) Change cursor movement direction to the right after entering data into a cell
• Dark mode Apply 'Dark mode' to the interface of the Excel (Calc) program
• Crosshair highlighting Enables crosshair highlighting of the row and column of the selected cell for improved visual analysis

11) File

• Reopen current file Closes and reopens the current document with the option to save
• Open current folder Quickly opens the folder of the current document, providing convenient access to its contents without the need for manual searching
• Create new folders from selection Automatically creates new folders based on paths specified in selected cells, simplifying file organization and data structuring
• Insert list of existing files Inserts a list of existing files from the selected folder, providing convenient viewing and access to their metadata (name, extension, creation date, full path, etc.)

12) Python

• Open folder with Python scripts Opens the folder containing Python scripts, providing convenient access to files for editing
• Open folder with standard libraries Quickly opens the folder with standard Python libraries without the need for manual searching
• Open folder with imported packages Quickly opens the folder with imported Python packages without the need for manual searching
• Install 'PIP' package Installs the 'PIP' package, which helps download and install other packages
• Install Python package Installs additional Python libraries directly from the interface