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

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

1) Text

• Change text to UPPERCASE Writing all words in capital letters
• Change text to lowercase 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 with small letters
• Start all words with a capital letter Change text so that each word starts with a capital letter
• First character uppercase Change the first character in the text to a capital letter, but do not change the case of the remaining characters
• Other cases > Sentence case, title case, Pascal case, camel case, snake case, kebab case, and space case

---

• Remove all letters in the text Cleans text by removing all letters
• Remove all digits in the text Cleans text by removing all digits
• Remove other characters > Other options for removing letters, digits, word characters, or sentence characters

---

• Remove trailing spaces in the text Removes all spaces from the beginning and end of the text
• Remove extra spaces in the text Removes all spaces from the beginning and end of the text, as well as extra spaces in the middle of the text

---

• Delete leading characters Deletes a specified number of characters from the beginning of the text
• Delete ending characters Deletes a specified number of characters from the end of the text
• Delete text after specified characters Deletes all text starting from a specified position

---

• Add characters to existing text Adds characters to the beginning and end of the text

---

• Get word by delimiters Splits text into parts by multiple delimiters simultaneously and retrieves the desired element by its occurrence number
• Remove words from text Removes words according to specified delimiters

---

• Mark Latin letters in text Marks Latin letters in red
• Mark Cyrillic letters in text Marks Cyrillic letters in red
• Convert similar letters in text Converts similar letters in different languages
• Fill alphabet Fills selected cells with letters from the chosen alphabet

---

• Reverse text Reverses the text in selected cells

---

• Show/Hide non-printable characters in text Makes characters that are not displayed on the monitor visible
• Show Unicode for each character in text Shows the Unicode code for each character in the text
• Replace private data Replaces private data with special characters to hide it from external observers

---

• Google Translate Translate text using the "Google Translate" website

2) Number

• Apply extra calculations to selected cells Quickly insert additional calculations into a formula
• Change formulas to their calculated values Replaces formulas in selected cells with their calculated values

---

• Convert unrecognized numbers (text?) to numbers Changes numbers displayed as text that Excel (Calc) does not recognize into actual numerical values
• Change values to text (by adding ' at the beginning) 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) Fixes negative numbers that have the minus sign at the end

---

• Use significant decimal places Rounds or applies the appropriate format to numbers in cells to display non-zero digits after the decimal point
• Hide numeric values Replaces all numeric values in the selected range with asterisks

---

• Spell out number or amount Converts numbers or amounts written in digits to text in English

3) Date

• Convert/Recognize dates Converts unrecognized dates in selected cells
• Automatic date conversion Automatically recognizes various date formats that may have been entered as text
• Quick date recognition Quickly converts text entries into actual dates based on a selected date pattern

---

• Remove time component Removes the time from dates in selected cells
• Mark weekends Marks dates in red according to user-selected days of the week

---

• Quick date formatting Offers a set of common date formats
• Fill dates Quickly fills start or end dates for each year, quarter, month, or week

4) Range

• Mark unique values Marks cells with unique values in yellow
• Mark distinct values Marks cells with distinct values in yellow
• Mark duplicates Marks cells with duplicates in different colors
• Mark odd values Marks cells in yellow that are repetitions of previous values in the selected range

---

• Unpivot table Unpivots a table from a cross-tabulated format to a flat format

---

• Create drop-down list Allows easy creation of interactive drop-down lists for selecting values in forms or program interfaces
• Create dependent drop-down list Enables the creation of dependent drop-down lists, where selecting one value automatically affects the available options in the next list

---

• Insert checkboxes in selected cells Automatically inserts checkboxes into selected table cells, providing a convenient way to mark selected items
• Delete checkboxes from selected cells Allows quick deletion of checkboxes from selected table cells, providing a convenient way to clear marked items

---

• Make font color as background Changes the font color to match the background color, creating an effect of hidden or merged text
• Convert conditional formatting to direct Converts conditional formatting into standard formatting, preserving applied styles without condition dependency

5) Formula

• Convert formula to text Saves the cell's formula as a text value
• Convert text to formula Saves the cell's value as a formula

---

• Display "empty" if error Wraps a cell's formula in the IFERROR function with an alternative value of "empty"
• Display "0" if error Wraps a cell's formula in the IFERROR function with an alternative value of "0"

---

• Show/Hide formulas Toggles between formulas and values for all cells

---

• Insert YLC function > Inserts a function from the "YLC Utilities" set

6) Comment

• Copy value to comment Copies the cell's result to a comment
• Copy formula to comment Copies the cell's formula to a comment

---

• Copy comment to cell Copies a comment into a cell's formula
• Move comment to formula Moves a comment into a cell's formula and deletes it simultaneously

---

• Show/Hide comments Displays/hides all comments
• Show/Hide indicators Displays/hides all indicators on cells (red corner)
• Show/Hide authorship Allows control over the display of authorship in comments, enabling hiding or showing 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 Copies an image from a comment to a cell as a graphic object
• Save image to folder Saves an image from a comment to a separate file in a selected folder

---

• Generate QR code Creates a QR code based on the text in a cell and saves it in a comment
• Generate barcode Creates a barcode based on the text in a cell and saves it in a comment

7) Worksheet

• Add sheets Inserts new sheets into a workbook using names from selected cells
• Sort sheets Sorts all sheets alphabetically (ascending or descending)
• Save sheets as workbooks Saves selected sheets into separate files

---

• Make worksheet list Automatically creates a list of all worksheets in a 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 within a document

8) Table Styles

• Excel Formats a table according to standard Excel color templates
• YLC Formats a table according to a selected YLC color template

9) Import

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

10) Export

• Export range as CSV Quickly exports data from a selected range to a CSV file
• Export range as XML Quickly exports data from a selected range to an XML file
• Export range as JSON Quickly exports data from a selected range to a JSON file
• Export range as SQL Quickly exports data from a selected range to an SQL file
• Export range as HTML Quickly exports data from a selected range to an HTML file

---

• Create Pandas DataFrame Creates a Pandas DataFrame
• Create Jupyter Notebook Creates a Jupyter Notebook
• Create Openpyxl template Creates an Openpyxl template
• Create Xlwings template Creates an Xlwings template

11) Interface

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

12) 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 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 a selected folder, providing convenient viewing and access to their metadata (name, extension, creation date, full path, etc.)

13) Python

• Open Python scripts folder Opens the folder containing Python scripts, providing convenient access to files for editing

---

• Open standard Python libraries folder Quickly opens the folder with standard Python libraries without manual searching
• Open imported Python packages folder Quickly opens the folder with imported Python packages without manual searching

---

• Install 'PIP' package Installs a 'PIP' package, which helps download and install other packages
• Install Python package Installs additional Python libraries directly from the interface

---

• Run Python script Executes any external Python script

14) Power Query

• Create Power Query worksheet Creates a new Power Query worksheet
• Duplicate column Creates a copy of a column
• Transform data Applies defined formulas to the selected column
• Remove outer function Automatically removes the outer (wrapper) function