• 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 lowercase letters
• Start text with a capital letter Capitalizing the first word and lowercase for the rest of the words
• Capitalize all words Change the 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 case options > Sentence case, title case, pascal case, camel case, snake case, kebab case, and space case

---

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

---

• Remove leading and 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 inside the text

---

• Delete leading characters Deleting a certain number of characters at the beginning of the text
• Delete trailing 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

---

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

---

• Get word by specified delimiters Splitting text into parts by multiple delimiters simultaneously and getting the required element by occurrence number
• Remove words from text Removes words according to specified delimiters

---

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

---

• Reverse text Reverses text in selected cells

---

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

---

• 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
• Convert formulas to their calculated values Replacing formulas in selected cells with their calculated values

---

• Convert unrecognized numbers (text?) to numbers Changes numbers displayed as text and unrecognized by Excel (Calc) into actual numeric values
• Convert 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 (for example, 47- to -47) Fixes negative numbers that have a minus sign at the end

---

• Use significant number of decimal places Performs rounding or applies the appropriate format for numbers in cells to display non-zero digits after the decimal point
• Hide numeric values Replaces all numeric values in the selected range with asterisk characters

---

• Spell number or amount in words Converts numbers or amounts written in digits into English text

3) Date

• Convert/recognize dates Converts unrecognized dates in selected cells
• Automatic date conversion Automatically recognizes different date formats that might have been entered as text
• Quick date recognition Quickly converts text entries into real dates based on the selected date template

---

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

---

• 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 Highlighting cells with non-repetitive values in yellow
• Mark distinct values Highlighting cells with distinct values in yellow
• Mark duplicates Highlighting cells with duplicates in different colors
• Mark redundant values Highlighting cells in yellow that are repetitions of previous values in the selected range

---

• Restructure table Unpivoting a table from cross-tab to flat

---

• Create drop-down list Allows you to easily create interactive drop-down lists for selecting values in forms or program interfaces
• Create dependent drop-down list Enables you to create 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 in selected cells Allows you to quickly delete checkboxes from selected table cells, providing a convenient way to clear marked items

---

• Make font color same as background Changes font color to match background color, creating a hidden or merged text effect
• Convert conditional formatting to regular formatting Converts conditional formatting to standard formatting, preserving applied styles independently of conditions

5) Formula

• Convert formula to text Save cell formula as a text value
• Convert text to formula Save cell value as a formula

---

• Display "blank" if error Wrapping the cell formula in the IFERROR function with an alternative value of "blank"
• Display "0" if error Wrapping the cell formula in the IFERROR function with an alternative value of "0"

---

• Show/hide formulas Switching 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 the cell result into a comment
• Copy formula to comment Copying the cell formula into a comment

---

• Copy comment to cell Copying a comment into the cell formula
• Move comment to cell Moving a comment into the cell formula with its 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, enabling 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 the image from the cell comment as a graphic object
• Save image to folder Save the image in the comment to a separate file in the selected folder

---

• Generate QR code Create a QR code based on the text in the cell and save it in a comment
• Generate barcode Create a barcode based on the text in the cell and save it in a comment

7) Worksheet

• Add worksheets Insert new sheets into the workbook using names from the selected cells
• Sort worksheets Sort all sheets in alphabetical order (ascending or descending)
• Save worksheets as workbooks Save selected sheets to separate files

---

• Make list of worksheets Automatically creates a list of all worksheets in the workbook
• Rename worksheets Quickly and conveniently renames worksheets, providing structured organization of the document
• Change tab colors Allows changing the color of tabs, helping to easily distinguish and organize them visually in the document

8) Table Styles

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

9) Import

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

10) Export

• Export range as CSV Quick export of data from the selected range to a CSV file
• Export range as XML Quick export of data from the selected range to an XML file
• Export range as JSON Quick export of data from the selected range to a JSON file
• Export range as SQL Quick export of data from the selected range to an SQL file
• Export range as HTML Quick export of data from the selected range to an HTML file

---

• Create Pandas DataFrame Create Pandas DataFrame
• Create Jupyter notebook Create Jupyter notebook
• Create Openpyxl template Create Openpyxl template
• Create Xlwings template Create Xlwings template

11) Template

• Annual calendar Generation of a calendar with dates for any year
• Event calendar (yearly) Creating a yearly calendar showing selected events
• Event calendar (monthly) Creating a monthly calendar showing selected events

---

• Stock watchlist Creating a stock watchlist for a selected exchange or index
• Company data overview Creating a worksheet with detailed company details

12) Interface

• Address style (R1C1) Change formulas style from alphabetical (A1) to digital (R1C1)
• Hide grid Hide cell gridlines
• Change input direction (Right) Change the cursor movement direction to the right after entering data into a cell
• Dark mode Apply 'Dark Mode' to the Excel (Calc) application interface
• Crosshair highlighting Enables crosshair highlighting of the row and column of the selected cell to improve visual analysis

13) 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 the specified paths 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.)

14) 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 libraries for Python without manual searching
• Open folder with imported packages Quickly opens the folder with imported packages for Python without manual searching

---

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

---

• Run Python script Run any external Python script

15) Power Query

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