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

Full list of utilities that are included in the extension "ylc_utilites.xlam"

1) text

• Change the text to uppercase Writing all words in capital letters
• Change the text to lower case Writing all words in small letters
• To start the text with a capital letter Writing the first word in capital letters and the rest of the words - from a small
• To start all words with a capital letter Change the text so that each word begins with a capital letter
• The first symbol of capital letters Change the first character in the tete to the capital letter but the register of the rest of the characters do not change
• Other register options> Register of sentences, headline register, Pascal Register, camel register, snake register, kebab Register and space register
• Remove all letters in the text Cleaning the text by deleting all letters in the text
• Delete all the numbers in the text Cleaning the text by deleting all digits in the text
• Remove other characters> Other options for deleting letters, numbers, characters of a word or symbol of a sentence
• Remove extreme blanks in the tete Remove all spaces from the beginning and end of the text
• Remove excess blanks in the tete Removing all spaces at the beginning and end of the text as well as excess spaces in the middle of the text
• Remove initial characters Deleting a certain number of characters at the beginning of the text
• Remove end characters Deleting a certain number of characters at the end of the text
• Delete text after a certain number of characters Removing the whole text starting from a particular position
• Get a word on the specified separators Cutting text into parts by many separators at the same time and obtaining the required item by the entry number
• Mark Latin letters in the text Denote Latin letters in red
• Mark the Cyrillic letters in the text Mark Cyrillic letters in red
• Google translator Translate the text with Google Translator site

2) Number

• Apply additional calculations to highlighted cells Fast insert additional calculations into a formula
• Change formulas to their calculated values Replacing the formula in selected cells by their calculated values
• Transforming unrecognized numbers (text?) Into numbers Changes numbers that lo calc not recognized and which are displayed as a text to real numeric numbers
• Change the value to text (adding 'in front) Changes all numbers in selected cells to textuals
• Fill the cells with their formatted value Replaces the contents of the selected cells by their formatted value
• Change the negative numbers on positive and vice versa Changes positive numbers to negative and negative numbers - on positive
• Move sign minus from end to beginning (eg 47- on -47) Corrects negative numbers that have a minus sign at the end
• Use a significant number of comma characters Performs rounding or applies the appropriate format for numbers in cells to display non -zero discharges after decimal coma/dot
• Writing a number or amount with words in words Converts numbers or sum written in numbers into text in English

3) Date

• Turning/recognition of dates Converts unrecognized dates in selected cells
• Remove time in the selected Removes time from the date in the selected cells

4) range

• Mark unique values Marking cells with unique values of yellow
• Mark different values Marking cells with different values of yellow
• Mark the duplication Marking cells with repetitions of different colors
• Mark excess values Marking cells in yellow color that is a repetition of previous values in the highlighted range
• Restructuring the table Unfolding of the table (unpivot) from cross -in - in flat
• Create a raising list Allows you to easily create interactive drop -down lists to select values in forms or interfaces of programs
• Create a linked listing list Allows you to create associated drop -down lists where one value selection automatically affects available options in the next list
• Insert the boxes into the selected cells Automatically inserts the boxes into the selected table cells, providing a convenient way to designate the selected items
• Remove the boxes in the selected cells Allows you to quickly delete the flags from the selected cells of the table, providing convenient cleaning of the marked items
• Make the font color as a background Changes the font color so that it matches the color of the background, creating the effect of hidden or fused text
• Turn a conditional formatting into a normal Converts conditional formatting into standard formatting, keeping the styles applied without the conditions

5) formula

• Turn the formula into text Save the cell formula as a textual value
• Turn the text into a formula Save the cell value as a formula
• Display "empty" If the error Wrapping the cell formula into an IFERROR function with an alternative value "empty"
• Display "0" if error Wrapping the cell formula into an IFERROR function with an alternative value "0"
• Show/hide formulas Switching between formulas and values for all cells
• Insert ylc feature Insert a feature from the YLC Utilities set

6) Comment

• Copy the value in a comment Copy the cell result to the comment
• Copy the formula in a comment Copying cell formula in a comment
• Copy the comment in the cell Copying a comment to the cell formula
• Move a comment in a cell Moving a comment to a cell formula with simultaneous deleting it
• Show/hide comments Display/hide all comments
• Show/hide indicators Displays/hides all indicators on cells (red corner)
• Show/hide authorship Allows you to manage a display of authorship in the comments by allowing to hide or show the names of commentators as needed
• Insert the image Inserts the image directly into a comment by adding visual items for better visual and context

7) Sheet

• Add the sheets Insert new sheets into a book using the names from the selected cells
• Sort the sheets Sort all sheets in alphabetical order (by growth or descending)
• Save sheets as books Save the selected sheets to separate files
• Make a list of worksheets Automatically creates a list of all worksheets in the book
• Rename the work sheets Quickly and conveniently renames work sheets, providing a structured document organization
• Change the color of the bookmarks Allows you to change the color of bookmarks by helping easily visually distinguish them and organize in the document

8) Styles for tables

• Excel Table formatting according to standard excel colors patterns
• Ylc Table formatting according to the selected YLC Color Template

9) external data

• Official currency exchange rates Obtaining currency rates from official national banks' websites
• Insert data from the image Recognizes and converts the table from the image into a edited tabular format by simplifying the work with data

10) interface

• Address style (R1C1) Change formula style from lettering (A1) to digital (R1C1)
• Hide the grid Hide the lines of the cells of cells
• Change the direction of input (right) Change the direction of moving the cursor to the right after entering the data into the cell
• Dark mode Apply 'Dark Mode' for the Excel program interface
• Cross -backlight Turn on the cross -backlight of the line and the column of the selected cell to improve visual analysis

11) File

• Open the current folder Quickly opens the current document folder, providing convenient access to its contents without the need for manual search
• Open the Python script folder Opens a folder containing Python scripts, providing convenient access to files to edit them
• Create new folders from the selected Automatically creates new folders based on prescribed ways in the selected cells, simplifying the organization of files and data structuring
• Insert a list of existing files Inserts a list of available files from the selected folder, providing convenient viewing and accessing their meta-data (name, extension, date of creation, full way, etc.)