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

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

1) Text

• Change text to UPPER CASE Writing all words in capital letters
• Change text to lower case Writing all words in lowercase letters
• Start text with a capital letter Writing the first word with a capital letter and the rest of the words - in lowercase
• Start all words with a capital letter Change text so that each word starts with a capital letter
• First character with a capital letter Change the first character in the text to a capital letter, however, do not change the case of the rest of the characters
• Other case variants > 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 text
• Remove all digits in text Cleaning text by removing all digits in text
• Remove other characters > Other variants of removing letters, digits, word characters or sentence characters
• Remove trailing spaces in text Removing all spaces from the beginning and end of text
• Remove extra spaces in text Removing all spaces at the beginning and end of text, as well as extra spaces in the middle of text
• Delete leading characters Deleting a certain number of characters at the beginning of text
• Delete ending characters Deleting a certain number of characters at the end of 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 with red color
• Mark Cyrillic letters in text Mark Cyrillic letters with red color
• Google Translate Translate text using the "Google Translate" website

2) Number

• Apply extra calculations to selected cells Quick insertion of additional calculations into formula
• Change formulas to their calculated values Replacement of formula in selected cells with their calculated values
• Convert unrecognized numbers (text?) to numbers Changes numbers that appear as text and which Excel (Calc) does not recognize, to actual numeric 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 minus sign from end to beginning (e.g., 47- to -47) Corrects negative numbers that have a minus sign at the end
• Use significant number of digits after decimal point Performs rounding or applies appropriate format for numbers in cells, to display non-zero digits after the decimal point/comma
• Spelling number or amount as text Converts numbers or amount written in digits into text in English language

3) Date

• Convert/recognize dates Converts unrecognized dates in selected cells
• Remove time component Removes time from date in selected cells

4) Range

• Mark unique values Marking cells with non-repeating values with yellow color
• Mark distinct values Marking cells with distinct values with yellow color
• Mark duplicates Marking cells with repetitions with different colors
• Mark redundant values Marking cells with yellow color, which are repetitions of previous values in the selected range
• Rebuilding table Unpivoting table (unpivot) from crosstab - to flat
• Create drop-down list Allows easily to create interactive drop-down lists for selecting values in forms or program interfaces
• Create dependent drop-down list Allows to create 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 from selected cells Allows quickly to delete checkboxes from selected table cells, providing convenient clearing of marked items
• Make font color as background Changes font color so that it matches the background color, creating a hidden or merged text effect
• Convert conditional formatting to standard 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 cell formula in IFERROR function with alternative "empty" value
• Display "0" if error Wrapping cell formula in IFERROR function with alternative "0" value
• Show/hide formulas Toggling between formulas and values for all cells
• Insert YLC function Insert function from "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 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 to manage the display of authorship in comments, allowing to hide or show commentator names as needed
• Insert image Inserts image directly into comment, adding visual elements for better clarity and context

7) Worksheet

• Add sheets Insert new sheets into workbook, using names from selected cells
• Sort sheets Sort all sheets in alphabetical order (by ascending or descending)
• Save sheets as workbooks Save selected sheets into separate files
• Make 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 to change tab colors, helping easily visually distinguish and organize them in the document

8) Styles for tables

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

9) External data

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

10) Interface

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

11) File

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

12) Python

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