Cookies tgħinna jagħti servizzi tagħna. Bl-użu tas-servizzi tagħna, inti taqbel li l-użu tagħna ta 'cookies.
Tip: Lingwi oħra huma tradotti minn Google. Tista 'żżur il - English verżjoni ta 'din ir-rabta.
log in
x
or
x
x
reġistru
x

or

Kutools - Jikkombina aktar minn 300 Advanced Functions and Tools għal Microsoft Excel

Kutools for Excel is a handy Excel add-in with more than 300 advanced features to simplify various kinds of complicated tasks into a few clicks in Excel. For example, Excel users can easily combine worksheets with several clicks, merge cells without losing data, paste to only visible cells, and so on. Undoubtedly, this powerful and user-friendly add-in will save Excel users a mass of working time and greatly improve working efficiency.

KTE 125x125
  • 110,000+ Excel users’ choice. Full feature free trial 60-day, no credit card required!
  • Combine multiple worksheet or workbooks into one workbook
  • Count and sum cells based on background/font color
  • Split cell contents into multiple rows/columns by space/comma/delimiter
  • Batch Remove leading spaces in cells

Ara kif Kutools għal Excel tiffranka l-ħin tiegħek f'Exittu 2019 / 2016 / 2013 / 2010 / 2007 / Uffiċċju 365

The software is described below, arranged by the Ribbon groups in which they appear.

Kutools tab

shot kutools tab narrow 002
shot kutools tab narrow 03
shot kutools tab narrow 04
shot kutools tab narrow 05
View Grupp Ranges & Cells Group Editjar tal-Grupp Grupp tal-Formula

Kutools Plus tab

shot kutools plus tab narrow 02
shot kutools plus tab narrow 03
shot kutools plus tab narrow 04
shot kutools plus tab narrow 05
shot kutools plus tab narrow 06
Workbooks & Sheets Group Grupp ta 'Sigurtà Mailings Group Grupp Iffiltrat u Statistiku

Tab tad-Disinn

shot design tab 02
shot design tab 03
shot design tab 04
shot design tab 05
Protect Group View Grupp Monitor Group Options Group

Nota: Il- disinn tab is turned off by default. Excel users can toggle it by Kutools Aktar > Disinn tax-xogħlijiet.

View Grupp

Panew ta 'Navigazzjoni:

Contain 5 panes: Workbook & Sheet pane, AutoText pane, Name Manager pane, Column list pane, and Advanced Find and Replace pane.

Il-Paġni tan-Navigazzjoni mhux biss jelenka l-kotba, worksheets, kolonni u ismijiet f'kamra integrata għalik, iżda wkoll iżżid l-Excel b'karatteristika affaxxinanti li tħallik tagħti ħarsa fil-kotba kollha, worksheets, u taqleb bejn kollha kemm huma. U x'hemm aktar? Tista 'tagħżel minnufih u mur il-kolonna u l-isem speċifiku fil-kotba tax-xogħol tiegħek. Tista 'ttawwal u tinżel il-Pane tan-Navigazzjoni għal kwalunkwe pożizzjoni fiż-żona tax-xogħol tiegħek, u tista' tiġi attivata biex taħbi jew turi klikk waħda.

Żona tal-Area tax-Xogħol:

This utility has embodied 3 types of working area settings in your Excel as follows:

  • 1. To minimize the ribbon and hide the status bar;
  • 2. To minimize the ribbon, hide the status bar and the formula bar;
  • 3. To minimize the ribbon, hide the status bar, the formula bar, and the ribbon.

Qari ta 'Displej View

Automatically highlight the entire row or column of the active cell.

It is inevitable that lines or columns will be misread when we check for formulas or data in a worksheet with a large number of rows and columns. Reading Layout will highlight the line and column of the current cell. That will make it easier to check for data or enter data.

Snap (Backup Current Workbook)

Take snapshots of the current workbook for restoring the workbook easily.

This utility can take a snapshot of the current workbook with one click at any time, and click on the snapshot item will restore the workbook to the snapshot. Please note that this utility will only keep the snapshot available before closing the workbook, if the workbook has been closed, all snapshots of the workbook will be cleaned.

icon ColumnVisible

Kolonni

One click to toggle hidden columns visibility in the used range.

B'din l-utilità, tista 'malajr toggle viżibilità tal-kolonni moħbija b'xi klikk. Wieħed ikklikkja se juri l-kolonni moħbija kollha fil-medda użata, ikklikkja għal darb'oħra se jistabbilixxi l-kolonni kollha moħbija biex ikunu inviżibbli.

Worksheets

Quickly toggle all hidden sheets visibility in the current workbook.

One click will toggle all hidden sheets to be visible, click again will toggle all hidden sheets to be invisible in the current workbook.

Show / Hide

A collection of tools allow you to quickly show or hide the workbooks, worksheets and ranges, Excel window settings, etc.

Żona Skrollja Issettjata:

Huwa mod meraviljuż li tiffissa jew tillimita ż-żona ta 'scrolling fil-ktieb tax-xogħol tiegħek. Jekk tiċċaqlaq ħafna mill-worksheet tiegħek, jew jekk ikollok dejta li ma tridx li l-qarrejja jesploraw, din l-għodda hija konvenjenti għalik biex tillimita ż-żona viżibbli tal-worksheet tiegħek biss għal dik li għandha data attwali.

Għolli l-firxiet kollha:

Tista 'malajr tivverifika l-firxiet kollha moħbija fil-worksheet attiv.

Hide Unselected sheets:

Dan jippermettilek li taħbi malajr il-folji mhux attivi kollha (mhux magħżula) fil-ktieb tax-xogħol attiv (kurrenti) b'xi klikk.

Unhide All Hidden Sheets:

Unhide all hidden sheets of the active workbook with one click. Normally you have to unhide all hidden worksheets one by one in Excel.

Aħbi l-Windows Inattiv:

Jekk fetħet kotba multipli fl-Excel, din l-għodda tippermettilek li taħbi l-kotba inattivi kollha b'ħin wieħed.

Unhide All Hidden Windows:

Żur il-kotba moħbija kollha b'xi klikk. Normalment ikollok biex taraw il-kotba moħbija kollha wieħed wieħed f'Excel.

Hide/Unhide Workbooks and Sheets:

Oħloq jew żżur b'mod interattiv kotba u worksheets multipli f'ħin wieħed. Normalment għandek taħbi jew ma żżidx il-ktieb tax-xogħol u l-worksheet wieħed wieħed f'Excel. Din hija għodda utli għalik biex timmaniġġa ktieb ta 'ħidma kbir b'ħażna ta' worksheets.

Għażliet ta 'View:

With this utility, you can quickly toggle any of the following settings: gridlines, horizontal scrollbar, vertical scrollbar, row and column headers, page breaks, formula view, sheet tabs, status bar, formula bar, full-screen display, comment visibility, and object visibility. Save your time from looking for where to toggle any of the above settings. It's all done interactively, so you can see the preview before you commit to it.

Ranges & Cells Group

Medda

Ġabra ta 'utilitajiet jippermettulek tipproċessa malajr l-operazzjonijiet li ġejjin fil-firxiet u ċ-ċelloli.

Merge Same Cells

Merge adjacent cells that contain the same value in each column with one click. Please select columns, and click "Merge Same Cells", then all vertically adjacent cells with the same value will be merged in bulk.

Unmerge Cell

This utility will unmerge the merged cells in a range with one click, and auto-fill each unmerge cell with the corresponding content from the original merged cell.

Flip Range orizzontali

Flip all cells in the selection horizontally with one click. For example, if you have a row data, such as: 1, 2, 3, you can quickly reverse its order horizontally to 3, 2, 1.

Firxa Vertikali Flip

Flip all cells in the selection vertically with one click. For example, if you have selected a column, containing the number 1, 2 and 3, this utility will reverse the order vertically to 3, 2, and 1.

Traspożizzjoni tad-Dimensjonijiet tat-Tabella:

B'din l-utilità tat-Traspożizzjoni tad-Dimensjoni tat-Tabella handy, inti tista 'tikkonverti b'mod konvenjenti tabella (twila-dimensjonali) għal waħda ċatta (waħda dimensjonali) darba u viċi versa.

Firxa ta 'Trasformazzjoni:

Quickly transform a vertical column into rows with multiple columns. For example, you may have a single column of data which contains your customer's information, and each customer consists of 5 rows information (such as, name, sex, Tel, Email, and Address). With this tool you can transform the single-column of data into a five-column data table.

Firxiet ta 'Swap:

Quickly swap ranges, columns, rows, and cells in your workbook. The ranges for swapping must be identical in the same size. For example, you can't swap two columns with one column. You can quickly swap the cells or ranges on the same worksheet, on different worksheets or different workbooks. The formatting of cells will also be swapped, and the swap operation does not affect the formulas in the two ranges, and they continue referring to the original cells.

Sort Range Għażla:

B'din l-utilità, tista 'tgħaġġel malajr iċ-ċelloli f'firxa saltwarjament, biex issolvi ċ-ċelloli bbażati fuq kull ringiela jew kolonna saltwarjament, biex issolvi ringiela jew kolonna kollha saltwarjament, biex tagħżel b'mod każwali ċelluli, ringieli jew kolonni sħaħ.

Pejst għal Firxa Viżibbli

This feature enables to paste the copied data into visible cells only, ignoring all of the filtered cells and hidden cells.

Żona ta 'Scroll Set

Huwa mod meraviljuż li tiffissa jew tillimita ż-żona ta 'scrolling fil-ktieb tax-xogħol tiegħek. Jekk tiċċaqlaq ħafna mill-worksheet tiegħek, jew jekk ikollok dejta li ma tridx li l-qarrejja jesploraw, din l-għodda hija konvenjenti għalik biex tillimita ż-żona viżibbli tal-worksheet tiegħek biss għal dik li għandha data attwali.

Unhide all Ranges

Tista 'malajr tivverifika l-firxiet kollha moħbija fil-worksheet attiv.

Qabbel iċ-Ċelloli

Quickly compare two columns of cells, find out, and highlight the exactly same cells between them or the differences. It supports case-sensitive comparison.

icon PreventTyping

Il-prevenzjoni tat-tipografija

Prevent duplicate data from being typed in, prevent certain characters from being typed in, and only allow to enter specified characters in a range of cells.

Prevenzjoni Duplikata

Din l-utilità tista 'tipprevjeni d-dħul ta' dejta duplikata f'kolonna waħda b'xi klikk. Din l-utilità tilħaq l-istess funzjoni bħall-karatteristika ta 'validazzjoni tad-Data ta' Excel, iżda inti biss għandek tagħżel kolonna waħda u mbagħad tapplika din l-utilità, allura ma tistax ttajpja valuri doppji fl-istess kolonna.

Il-prevenzjoni tat-tipografija

Tipprevjeni faċilment karattri speċjali jew ċerti milli jiġu ttajpjati fiċ-ċelloli

Jippermettu biss li karattri speċifiċi jiddaħħlu f'firxa ta 'ċelloli

icon CopyRanges

Kopji tal-Kopja:

Normally Excel does not allow you to copy multiple selected ranges, but with this utility, you can copy multiple selected ranges at once.

kontenut

Ġabra ta 'għodda tippermettilek li tipproċessa malajr l-operazzjonijiet li ġejjin.

Ikkonverti bejn it-Test u n-Numru:

With this utility, you can quickly convert cell value between text and number. It can also convert values in cells that are preceded by an apostrophe to the number.

Ikkonverti Formula għal Test:

With this utility, you can easily convert formulas to text format in selection.

Ikkonverti Test għall-Formula:

B'din l-utilità, se tikkonverti formuli li ġew maħżuna bħala format ta 'test f'formuli reali.

Ikkonverti sad-Data:

With this utility, you can quickly identify and convert some non-standard date format which cannot be identifying by Excel as the normal data format. For example, it can easily convert and identify the following styles of date (such as "20120825", "2003 1 2 11:12:13.14PM", "2012.8.13") to the local date format (US) as "8/25/2012", "1/2/2003 11:12:13 PM", and "8/13/2012" in Excel.

Ikkonverti Ħin

This feature enables:
1. One click to convert time to seconds only;
2. One click to convert time to minutes only;
3. One click to convert time to an hour only;
4. And convert time to seconds/minutes/hours and save to a new location.

Konverżjoni tal-Munita:

It's a handy currency utility, which brings you a quick way to convert more than 50 currencies in your Excel by using the latest exchange rates from the reliable Internet website. You can easily convert a single value or volume values from range cells, and get the latest exchange rates at any time by updating from the reliable website (requires an Internet connection).

Konverżjoni ta 'Unità:

Malajr tikkonverti l-qisien minn unità għal oħra fl-Excel tiegħek. Jappoġġja l-kejl li ġej: Angolu, Bits bytes, Distanza, Enerġija, Forza, Sors, ​​Volum, Massa, Likwidu, Ħin u Temperatura.

Konverżjoni ta 'Sistemi ta' Numru

This feature can quickly convert among different number systems with only several clicks, without using any formulas. It includes converting binary to hex, octal to decimal, decimal to hex, ascii to hex, etc.

Spell Out Numbers

This utility can spell out numbers into English and Chinese words in Excel. For example, it can spell out the "12.75" to "Twelve Dollars and Seventy-five Cents".

Bidla ta 'Sinjal ta' Valuri:

B'din l-utilità ta 'Excel, inti tista' faċilment tiffissa trailing sinjali negattivi; ibdel is-sinjali negattivi kollha għal pożittivi; ibdel is-sinjali pożittivi kollha għal negattivi u ireġġgħu lura s-sinjal tal-valuri kollha. M'għandekx bżonn tuża formula għall-ipproċessar tal-operazzjonijiet ta 'hawn fuq.

Ikkonverti bejn Rumani u Numru

With this feature, you can quickly convert a range of Roman data to normal decimal numbers in bulk, and vice versa.

Bidla ta 'Sinjal ta' Valuri

B'din l-utilità ta 'Excel, inti tista' faċilment tiffissa trailing sinjali negattivi; ibdel is-sinjali negattivi kollha għal pożittivi; ibdel is-sinjali pożittivi kollha għal negattivi u ireġġgħu lura s-sinjal tal-valuri kollha. M'għandekx bżonn tuża formula għall-ipproċessar tal-operazzjonijiet ta 'hawn fuq.

Ikkonverti Numru għal Ordinal

With this feature, you can quickly convert selected normal numbers to an ordinal numeral in bulk, such as converting 1 to 1st, 2 to 2nd, 11 to 11th, 25 to 25th, etc.

Ringieli ta 'Għaqqad Avvanzati

With this utility, you can quickly combine multiple duplicate rows into one record based on a key column, and it also can apply some calculations such as sum, average, count and so on for other columns.

To Actuals

Convert the real value or formula in selected cells into the displaying values.

For example, you may insert a random number with inputting =RAND()*100 in a cell, and it displays 75.1203 in the cell. With this tool, you will remove the formula of =RAND()*100, but remain the displaying value of 75.1203.

Round (Mingħajr Formula):

Batch round numbers in selected range to the given decimal places without formula.

In Excel we can round numbers with functions or Format Cells command, however, both ways do not change the actual value of cells after rounding. This utility will round numbers in a range, and make the actual value of cells as displayed value. It supports the common round, round up, round down, and round to even.

Għaqqad (Ringieli u Kolonni):

With this utility, you can combine selected cells based on rows or columns, and combine data from multiple columns (or rows) into a single cell.

Per eżempju, tista 'tgħaqqad id-data fil-kolonni AD, u poġġiha kollha f'kolonna A. Int għandek tliet għażliet biex timmaniġġa d-data li ġiet magħquda. Tista 'Żommha, ħassarha jew toħloq ċelluli magħquda. Bħala għażla, tista 'tispeċifika karattru wieħed jew aktar biex tiddaħħal bejn id-data kkombinata (per eżempju, linja ġdida jew daħħal test).

Editjar tal-Grupp

Super Find

Search in specified scope (comments, cells, formulas, or hyperlinks), and search by specified criteria (date type, number, or specified formatting) in Excel.

Sib kordi tat-test speċifiċi biss fil-kummenti

This feature is able to look for the specific value in comments within the selection, active sheet or the whole workbook.

Sib kordi tat-test speċifiku biss fil-formoli

This feature can help Excel users quickly search the specific text strings in formulas only within the selection, active sheet, selected sheets, or the whole workbook.

Fittex valuri tat-test speċifiku biss fl-hyperlinks

This feature can quickly find the specified text value in hyperlinks added in the current selection, active sheet, selected sheets, or the entire workbook.

Sib string tat-test speċifiku biss fil-valur taċ-ċellola

This feature enables to search the specified text string by text length, uppercase, lowercase, and by part of the string.

Sib ċelloli li fihom valuri tat-tip tad-data bbażati fuq kriterji

With this feature, you can quickly find all date cells, or find cells containing the specified date in the selection, active sheet, selected sheets, or the entire workbook.

Sib numri bbażati fuq kriterji

With this feature, you can quickly find numbers in a certain numerical interval, such as greater/less than a certain number, between two numbers, etc. This feature also supports to find out duplicates or unique values at ease.

Sib iċ-ċelloli kollha b'formattjar speċifiku ta 'ċelloli

This feature can quickly find out cells by specified cell formatting, such as bold, italic, strikethrough, color, etc. In addition, it also supports to look for cells which are with comments and formula.

Fuzzy Lookup

Comparing to exact searching, this feature can help Excel users to find out similar searching results, such as text strings with the misspelling.

Agħżel

Ġabra ta 'għodda tagħmel l-għażla ta' oġġetti varji eħfef f'Excel.

Agħżel Helper tal-Medda

Hija utilità utli biex tgħinek tagħżel, tħassar u tanalizza reżoluzzjonijiet multipli fil-ktieb tax-xogħol attiv. Ma 'dan, tista' malajr tagħmel l-operazzjonijiet li ġejjin:

  1. Agħżel firxiet multipli mingħajr ma żżomm il-buttuna Ctrl;
  2. Iddeskrivi ċ-ċelluli minn firxiet magħżula;
  3. Firxiet magħżula b'lura.
Agħżel Ringieli ta 'Intervalli u Kolonni

With this utility, you can easily select a specific number of rows or columns at a specified interval in a large worksheet. For example, you can quickly select three rows at two rows interval.

Agħżel Iċ-Ċelloli Konġunti

Agħżel iċ-ċelloli magħquda kollha f'firxa b'klikk waħda. Jekk jogħġbok agħżel biss firxa u kklikkja "Agħżel Ċelloli Megħjuna", imbagħad iċ-ċelloli kollha magħquda f'din il-medda se jintgħażlu.

Agħżel Last Cell

With this feature, you can one click to select the last cell of the used range, last cell with data of the last row or last cell with data of the last column.

Agħżel Ċelloli b'Man jew Min Valur:

Din l-għodda mhux biss tagħżel il-valur minimu jew massimu f'firxa magħżula ta 'ċelloli iżda wkoll tmur għall-pożizzjoni eżatta tal-valur minimu jew massimu. Fl-Excel, tista 'tuża l-funzjoni MIN u MAX biex tagħżel il-valur minimu jew massimu, iżda ma tistax tmur għall-pożizzjoni eżatta tal-valur minimu jew massimu.

Agħżel Ċelloli bi Valur ta 'Żball

Selects all cells on the active worksheet with a formula that produce an error value (such as #DIV/0!, #N/A ).

Agħżel Ċelloli Unlocked

With this utility, you can quickly select all unlocked cells from a range. Tip: please specify a range before applying this utility.

Agħżel Unblank Cells

With this feature, you can select all non-blank cells from a range with just one click. With this feature, you can select all non-blank cells from a range with just one click.

Agħżel Ċelloli Speċifiċi

Selects cells or an entire row from a specified range that meet certain criteria. Once selected, you can apply other operations (such as, formatting or delete) to the cells or entire row.

Agħżel Ċelloli bil-Format

Selects cells with the same formatting from range cells according to the formatting of the base cell or the base cell attributes. Normally you can use this tool to determine how many cells with the same formatting of the base cells. Once selected, you can change the font size or color of the selected cells.

Agħżel Duplikat & Unique Cells

Din l-utilità tista 'tgħinek tagħżel malajr il-valuri doppji jew uniċi jew ringieli sħaħ minn kolonna jew medda.

Agħżel l-istess u Ċelloli differenti

With this feature, you can easily compare two ranges of cells, find, select, and highlight the duplicates or unique values between both ranges.

Daħħal

Ġabra ta 'għodda ta' daħħal.

Daħħal Ringieli Titoli

F'xi żmien jista 'jkollok bżonn li żżid titolu għal kull ringiela, bħal Bill tas-Salarju. Din l-utilità tista 'malajr daħħal titli għal ringieli.

Daħħal Ringieli vojta u Kolonni:

This handy tool will save your time, and make it convenient for you to quickly insert multiple blank rows or columns at a specific interval at a time.

Daħħal id-Data Random

With this utility, you can easily process the following operations in a range of cells for you. A. Insert a sequence of integers randomly; B: Insert or generate random date; C. Insert or generate password (random data strings); D. Insert or generate specified formatting data strings; E. Insert or generate a custom list.

Daħħal Numru ta 'Sekwenza

Malajr daħħal valur uniku (u konsekuttiv) f'ċellula f'Excel. Tista 'żżid il-prefiss jew is-suffiss tat-test u speċifika n-numru ta' numri għan-numru. Per eżempju, tista 'faċilment daħħal numru tas-serje bħala Kutools-XXXX-2011 (XXXX tindika n-numru tas-sekwenza).

Sib Numru ta 'Sekwenza Neqsin

With this feature, you can quickly find and insert missing numbers in a sequence list.

Imla Lista Personalizzata

Permezz ta 'din il-karatteristika, tista' malajr toħloq il-listi tad-dwana personali tiegħek u żżommhom fil-kaxxa tal-lista, u imbagħad imlahom fiċ-ċelloli tal-worksheet vertikalment jew orizzontalment.

Agħti lista tal-kombinazzjonijiet kollha

Based on given text strings and values, this feature can quickly figure out all possible combinations and list them in a column.

Daħħal Bullet

With this feature, you can quickly insert bullets at the beginning of multiple selected cells. In addition, you can quickly remove bullets from multiple selected cells with one click only.

Daħħal in-Numerazzjoni

With this feature, you can quickly insert numberings for a range of cells with clicks at once. It also supports to quickly remove numberings from multiple cells with clicks.

Daħħal id-Data

With this tool, you can quickly insert a formatted date into a cell, just pick up a date with its date formatting and insert into a cell.

Imla Ċelloli vojta

This utility can save you time and help you quickly fill blank cells without overwriting original values in selections. With it, you can:

  1. Imla ċelloli vojta b'valuri ta 'hawn fuq, taħt, fuq ix-xellug jew fuq il-lemin
  2. Imla ċelloli vojta b'valuri lineari.
  3. Fill blank cells with a fixed value, such as 0.
Kaxxi tal-Iċċekkjar għall-Lott Daħla

With it, you can easily insert checkbox in a cell or range. Tip: If you select a range, it will insert checkbox into all cells of the range.

Buttuni tal-Għażla Daħħal għall-Lott

With it, you can easily insert option button in a cell or range. Tip: If you select a range, it will insert an option button into all cells of the range.

Daħħal Watermark

With this feature, you can insert both picture and text watermarks into the worksheet at ease.

Test Awtomatiku

With this Auto Text feature, you can easily save and reuse all kinds of data in Excel:

  1. Save charts as an AutoText entry and reuse with one click;
  2. Save a range of data as an AutoText entry and reuse with one click;
  3. Save any formulas as AutoText entries and reuse with one click;
  4. Save clip arts or pictures as AutoText entries and reuse with one click;
  5. Easily import and export saved AutoText entries.

Ħassar

Ġabra ta 'għodda tippermetti li tipproċessa malajr l-operazzjonijiet li ġejjin.

Ħassar Ringieli vojta

With this tool, you can quickly delete blank rows in the selected range, selected worksheets, active worksheets, and all worksheets. Normally it's quite difficult to delete all blank rows in a workbook with too many worksheets in Excel, but with this tool, you can get it done with one click.

Ħassar Fajls u Kolonni Hidden (Viżibbli)

With this utility, you can quickly delete all blank rows or blank columns, hidden rows or hidden columns and visible rows or visible columns from a selected range, selected sheets, active sheet or all sheets.

Ħassar Filigrana

With this feature, you can quickly remove watermarks which are inserted by the Daħħal Watermark feature of Kutools for Excel.

Ħassar Illustrazzjonijiet u Oġġetti

B'din l-utilità, tista ':

  1. Delete Charts
  2. Delete Lines
  3. Delete Pictures
  4. Delete Auto Shapes
  5. Delete Smart Arts
  6. Delete Text Boxes
  7. Delete Embedded OLE Objects
  8. Delete Linked OLE Objects.
Ħassar il-Kontrolli tal-Web

Din l-utilità tista 'tgħinek tħassar il-kontrolli kollha tal-web b'wieħed ikklikkja.

Lott Ħassar Kaxxi ta 'Verifika

This feature can remove the selected checkboxes at once.

Lott Ħassar Button ta 'Għażla

With this feature, you can delete all option buttons in a specific range with only one click.

Neħħi l-Macros kollha

Malajr neħħi kwalunkwe mill-macros li ġejjin mill-ktieb tax-xogħol tiegħek: moduli VBA, UserForms, worksheets Excel 5 / 95 dialog jew worksheets Excel 4 XLM.

Lott Neħħi l-Macros kollha

With this feature, you can easily remove all macros from multiple workbooks at once in Excel.

Test

It embodies a lot of handy operations for you to manipulate the text in cells.

Żid it-Test

This feature can add the same text strings or characters into multiple selected cells in bulk. It includes:

  1. Add same text strings or characters to the beginning of selected cells
  2. Add same text strings or characters to the end of selected cells
  3. Add same text strings or characters at the specified position of selected cells
  4. Add same text strings or characters before every uppercase, lowercase, letter, or number
Estratt Test

With this feature, you can quickly extract text strings between two characters or symbols from selected cells.

Indirizz tal-Email tal-Estratt

With this feature, you can quickly extract the email addresses from text strings of selected cells in Excel.

Neħħi Spazji

This feature can remove various kinds of space from a range of cells, includes:

  1. Remove leading spaces only from text strings
  2. Remove trailing spaces only from text strings
  3. Remove both leading spaces and trailing spaces from text strings
  4. Remove all excess spaces from text strings
  5. Remove all kinds of spaces from text strings
Neħħi Zeros Leading

With this feature, you can one click to remove leading zeros from all selected cells immediately.

Neħħi bil-Pożizzjoni

With this feature, you can easily remove characters from the beginning / end of text strings, or remove given numbers of characters from the specified position.

Neħħi Karattri

It’s a handy tool to remove all kinds of characters from text strings in a range, including:

  1. Neħħi karattri numeriċi minn ċelloli
  2. Neħħi karattri alfabetiċi miċ-ċelloli
  3. Neħħi karattri mhux numeriċi miċ-ċelloli
  4. Neħħi karattri mhux alfabetiċi miċ-ċelloli
  5. Neħħi karattri mhux printable miċ-ċelloli
  6. Neħħi karattri mhux alfanumeriċi miċ-ċelloli
  7. Neħħi personalizzata karattri miċ-ċelloli
Numri ta 'sottoskritti f'Formoli Kimiċi

This feature is able to format all numbers which should be made subscript in chemical equations as a subscript in bulk.

Bidla fil-Każ

This handy tool can quickly convert text among upper case, lower case, proper case, and sentence case. It includes:

  1. Change case of text to all caps / upper case.
  2. Change case of text to lower case.
  3. Change case of text to proper case.
  4. Change case of text to sentence case.
  5. Change case of text to toggle case.
Ordni ta 'Test Reverse

With this feature, you can quickly reverse the word order in each selected cell in bulk. It supports:

  1. Reverse text order by nothing. For example, reverse “Kutools for Excel” to “lecxE rof slootuK”;
  2. Reverse text order by space. For example, reverse “Kutools for Excel” to “Excel for Kutools”;
  3. Reverse text order by comma or other separators. For example, reverse “Word, Excel, PowerPoint, Outlook” to “Outlook, PowerPoint, Excel,Word”;
Ibdel il-Karattri Aċċentati

With this feature, you can easily replace all kinds of accented characters with regular chars in the entire workbook.

Ismijiet Split

With this feature, you can easily split full names in a column to the first, middle and last name columns separately as you need.

Split Cells

This excellent feature can quickly split cell content of one column into multiple columns or rows by certain separators. In addition, this feature can also split cell content into number column/row and text string column/row.

format

Ġabra ta 'għodda għall-ifformattjar.

Ringiela alternata / Shading tal-Kolonna

Quickly apply shade to alternate rows for a range cells in a worksheet from using the Conditional Formatting and standard formatting to improve the readability of your worksheet in Excel, and you don't need to know how to use the Conditional Formatting and standard formatting.

Superscript / Subscript (Formatting)

Faċilment ifformattja t-test bħala superkritt jew sottoskrizzjoni f'ċellola. Tista 'wkoll tapplika l-attributi bil-grassett u l-Italika u l-każ (fuq jew t'isfel) għal karattri alfabeti. Hija għodda perfetta għalik biex taħdem b'formuli matematiċi jew kimiċi f'Excel.

Applika l-Formattjar tad-Data

B'din l-utilità tista 'tbiddel malajr id-data tal-ifformattjar tal-firxa magħżula.

Kopja ta 'Formattjar ta' Ċelloli

To copy formatting from one place and apply it to another, you may use Format Painter. But the Format Painter will copy all the formatting of the cell and apply it to another. This utility can help you copy some specific formatting of the cell and apply it to another.

Ċar il-formattjar taċ-ċelloli kollha

Normally Excel does not support a tool to clear various types of cell format at once, but with this utility, you can easily clear all cell formats from a range with one click.

Aġġusta Daqs taċ-Ċellula

Din l-utilità tgħinek taġġusta malajr l-għoli tal-filliera u l-wisa 'tal-kolonna f'liri, ċentimetri, pulzieri jew pixels. Jista 'japplika għal medda jew il-folja ta' ħidma kollha.

link

Ġabra ta 'għodod għal hyperlinks u referenzi esterni (links).

Ikkonverti l-hyperlinks

Ma 'din l-utilità, tista' malajr tikkonverti test (URL) f'inklinks, tapplika indirizzi multipli ta 'hyperlink għal kontenut taċ-ċellola (test) u tikkonverti indirizz multipli ta' hyperlink f'test f'Excel.

Sib u tkissru Links Imfarrka

It can list all links (external reference) of the active worksheet and break all broken links by replacing it with appreciate value in Excel.

Ħassar Hyperlinks

Malajr jikkonvertu hyperlinks f'ċelloli għal test sempliċi. Tista 'tħassar l-hyperlinks kollha f': Firxa magħżula; worksheet attiva; worksheets magħżula u l-worksheets kollha.

aktar

More tools will be located here.

Kalkulatur

With this calculator, you can carry out more than 10 types of mathematical operation. You can easily retrieve a value from a selected cell for calculating, and paste the calculating result into a specific cell. You can also use the keyboards to handle the calculator for operation.

operazzjoni

Twettaq operazzjonijiet komuni tal-matematika f'ċelloli, bħal żieda, tnaqqis, multiplikazzjoni, diviżjoni, eċċ. Per eżempju, tista 'faċilment tuża din l-għodda biex iżżid kolonna ta' prezzijiet ta 'diversi prodotti b'XXUMX fil-mija.

Bidla fil-Forma tal-Kummenti

Malajr ibiddel il-forma tal-kummenti kollha f'Excel.

Oħloq Lista ta 'Kummenti

This feature will extract and list all comments in a new worksheet or workbook as you specified.

Format Kumment

This feature will copy the formatting of the comment of the active cell, and apply the formatting to all of the other comments in bulk.

Sib / Ibdel it-Test Kumment

This feature enables to find certain data in comments and replace with given content in the active sheet or the whole workbook.

Neħħi / Żid Isem tal-Utent fil-Kumment

This feature will save you time greatly to batch add, remove, and change user names in all comments of the active worksheet or the entire workbook.

Ikkonverti Kumment u Ċellula

With this feature, it’s quite easy to convert between comments and cell contents. It’s able to achieve:

  1. Ikkonverti l-kontenut taċ-ċelluli għall-kummenti
  2. Ikkonverti l-kummenti għall-kontenut ta '
  3. Daħħal il-kontenuti taċ-ċelluli għal kummenti
  4. Daħħal kummenti għall-kontenuti taċ-ċelluli
AutoFit Kumment

This smart feature will resize all comments to fit their contents accordingly in bulk in active worksheet or the entire workbook.

Poġġi l-kumment tal-kumment

With this feature, you can one click to reset all comments back to the default positions in the active worksheet or the whole workbook immediately.

Grupp tal-Formula

Kutools Funzjonijiet

A collection of built-in functions.

Data u Ħin

This is a series of built-in functions to convert time to seconds / minutes/ hours in Excel.

Statistika u Matematika

This is a series of built-in functions to count/sum/average visible cells only, and count/sum by color, including:

  1. Average Visible cells
  2. Count Visible Cells
  3. Sum Visible Cells
  4. Count by cell color
  5. Count by font color
  6. Count by font bold
  7. Count characters
  8. Count shades
  9. Sum by cell color
  10. Sum by font color
  11. Sum by font bold
Test

This series of built-in functions contain:

  1. Numri ta 'estrazzjoni: Extract numbers from mixed text string with the function
  2. Test Reverse: Ordni b'lura ta 'karattri f'ċellula b'funzjonijiet

Kopja eżatta (Formula)

Easily copy all the formulas without adjusting the relative cell references.

Normally Excel will adjust the cell references if you copy your formulas to another location. Then if you want to process this operation in your Excel without using this tool, you have to lock all references with $.

Ikkonverti tirreferi (Referenzi)

Convert notation of references to cells in the formulas in selection.

For example: [=F5*(G12/100)] becomes [=$F5*($G12/100)]. With this feature, you can:

  1. Ikkonverti formuli għal referenzar assolut ($ F $ 5)
  2. Ikkonverti formuli għal referenzi relattivi (F5)
  3. Ikkonverti formuli għal fillieri relattivi u kolonni assoluti ($ F5)
  4. Ikkonverti formuli għal ringieli assoluti u kolonni relattivi (F $ 5)

aktar

Aktar għodod għat-tqandil ta 'formuli f'Excel.

Ibdel l-Ismijiet tal-Medda

Din l-għodda żżid l-Excel b'karatteristika li tissostitwixxi referenza ta 'isem fil-formuli magħżula bir-referenza korrispondenti. Għaċ-ċelloli fihom formuli, din hija karatteristika pjuttost utli biex tkompli tuża referenzi ta 'l-isem mingħajr ma taffettwa l-formuli magħżula.

Hide / Unhide Range Name

With this feature, you can quickly show or hide all range names in the current workbook.

Kondizzjoni ta 'Żball Wizard

This tool is sophisticatedly designed for adding error condition to a formula or group of formulas. With this tool, you can easy to display a custom message for formulas that produce errors. This means that instead of e.g. #VALUE!. You can have your own error message displayed.

Dinamikament Irreferi għal Worksheets

Din l-utilità tista 'tgħinek biex timla malajr ir-referenzi taċ-ċelluli minn worksheets multipli f'wieħed mill-worksheet. Tista 'timlahom vertikalment jew orizzontalment. Jekk ikollok ktieb ta 'ħidma li jkun fih worksheets multipli, u issa trid estratt l-istess referenzi taċ-ċelluli (A1, pereżempju) minn worksheets oħra f'wieħed worksheet, b'din il-funzjoni, tista' malajr tikseb ir-riżultat = Sheet1! A1, = Sheet2! A1, = Sheet3! A1, = Sheet4! A1 ... fi ktieb tal-master.

Monitor Precedents / Dependents of Ranges

These features can help you quickly automatically display all dependents and precedents in a selected range in real time with one click. It includes:

  1. Immonitorja Preċedent tal-Firxiet
  2. Segwi d-dipendenti tal-firxiet
  3. Preċedent u dipendenti tal-Monitoraġġ

Workbook & Sheets Group

Workbook

A collection of tools allow you to quickly process the following operations in the workbook.

Ktieb tax-xogħol maqsum

Easily split each worksheet of the active workbook as an individual Excel Workbook, Excel 97-2003 Workbook, or TXT/CSV/PDF file, and each file carries the name of the worksheet. You can set to skip all the blank and hidden worksheets.

Konvertitur tal-Format tal-Fajl

Normally in Excel, you can apply the Save as feature to save the Excel file format from XLSX to XLS, or vice versa, also can save the Excel file to PDF file. But if you have multiple Excel files need to be converted formats, this way will not be a good choice. So with this File Format Converter function, you can quickly and easily finish the following operations:

  1. Ikkonverti fajls XLSX multipli għal fajls XLS f'Excel
  2. Ikkonverti fajls XLS multipli għal fajls XLSX f'Excel
  3. Ikkonverti multipli jisbqu workbooks għal fajls PDF f'Excel
Daħħal l-Informazzjoni dwar il-Workbook

Quickly insert workbook name or saving path of the current workbook or current worksheet name in the header, footer, or a specified cell.

Folder Bil-Ftuħ

Iftaħ malajr il-folder li l-workbook attiva tibqa 'fiha.

Kopja tal-Path Sħiħ

Ħassar malajr il-path sħiħ tal-ktieb tax-xogħol attiv, u allura tista 'twaħħal il-passaġġ sħiħ tal-ktieb tax-xogħol attiv fil-post fejn trid tużaha.

Aħbi l-Windows Inattiv

This feature will hide all inactive workbooks with one click.

Żomm il-Windows Hidden Kollha

This is a handy feature to help you one click to unhide all hidden workbooks in bulk.

Auto Open Dawk il-Ħinijiet tax-Xogħol li Jmiss

With this tool, you can easily configure which open workbooks to be opened automatically next time while you launch the Excel. If you need to open the same multiple workbooks every time in your Excel, this tool can really save your time.

Worksheets

Ġabra ta 'għodda tippermetti li tipproċessa malajr l-operazzjonijiet li ġejjin fil-worksheets.

Sinkronizza Worksheets

Malajr toggle l-worksheets kollha tal-ktieb tax-xogħol attiv billi tipponta fuq l-istess numru ta 'ringiela (kull folja għandha l-istess għażla ta' firxa u ċellula ta 'fuq tax-xellug bħala l-folja attiva).

Isselillja l-Sort

With this tool, you can quickly rearrange all worksheets in the active workbook. It supports one click to alphanumerically sort sheets, one click to reverse current sheet orders, one click to sort sheets by color, and move up/down a certain sheet’s order separately.

Freeze Panes Multiple Worksheets

With this handy feature, you can quickly freeze across all worksheets of the whole workbook at the same time.

Unfreeze Panes Multiple Worksheets

This feature enables to unfreeze across all worksheets of the whole workbook at a time.

Irreġistra Worksheets

Quickly rename multiple worksheets of the active workbook at one time. You can choose to rename multiple worksheets:
1. Insert the specified content at the beginning/ending of original sheet names, or replace original sheet names in bulk;
2. Replace with contents from the specified range of cells;
3. Replace with contents from the same cells in corresponding sheets.

Oħloq Lista ta 'Ismijiet tal-Karta

With this feature, you can quickly list the worksheet names of the active workbook in a new worksheet, and add hyperlinks or macro buttons linking to corresponding worksheets.

Kopja ta 'Worksheets

Quickly make multiple copies of the active worksheet, or to insert multiple worksheets with customized worksheet names into your workbook. You can specify a range of cells that contain your worksheet names for the copied worksheets or the inserted worksheets.

Oħloq Sequence Worksheets

Quickly create a new workbook with customized worksheet names. You can easily specify the worksheet name by using: month names, day names, numerical sequence, a series, custom list and date in a range. For example, you can quickly create a new workbook with worksheet names: Company-1, Company-2, Country-1, and Country-2, etc.

Kalendarju perpetwu

This utility can quickly create a new workbook to lay out a calendar with specified number of months, and each worksheet contains one calendar month in the new workbook.

Data maqsuma

Din l-utilità tista 'taqsam id-data f'firxa f'diversi worksheets bbażati fuq kolonni speċifiċi jew ringieli fissi.

Ħassar Blank Worksheets

Malajr ħassar il-worksheets vojta (inklużi worksheets moħbija) mill-ktieb tax-xogħol attiv.

Ħassar il-Folji moħbija kollha

Malajr ħassar il-worksheets kollha moħbija mill-workbook attiva (kurrenti).

Ħassar il-Folji Inattivi kollha

This feature will quickly delete all worksheets except the active one from the current workbook with only one click.

Table Merge

Update or merge two tables by a given matching column from two worksheets or workbooks.

Data maqsuma

Split data in a range into multiple worksheets based on specific columns or fixed rows.

Konvertitur tal-Format

Convert Excel file Format between XLSX and XLS, and convert Excel files to PDF files.

  1. Ikkonverti fajls XLSX multipli għal fajls XLS f'Excel
  2. Ikkonverti fajls XLS multipli għal fajls XLSX f'Excel
  3. Ikkonverti multipli jisbqu workbooks għal fajls PDF f'Excel

Ktieb tax-xogħol maqsum

Split each worksheet of the active workbook as an individual workbook, TXT file, CSV file, or PDF file.

Disinn tax-xogħlijiet

This is added to toggle the Design Tools added by Kutools for Excel.

Stampar

Ġabra ta 'għodda tippermetti li tipproċessa malajr l-operazzjonijiet li ġejjin.

Stampa Wizard ta 'Kotba Multipli

Quickly print multiple workbooks and text files from a specified directory or across multiple directories. You can specify the type of files to be printed from a directory or multiple directories. You can choose to generate a summary report if any errors occurred while printing, you will have it in the report.

Stampa Wizard ta 'Għażliet Multipli

Quickly printing multiple non-contiguous ranges without a page break between ranges. Normally, when you print multiple selections, Excel inserts a page break between each range in your selection. You can also rearrange the order of selections to be printed.

Stampa l-Ewwel Paġna ta 'Kull Worksheet

With this feature, you can quickly print the first pages of each worksheet in the current workbook with only one click.

Stampa Paġni f'ordni b'lura

This feature will reverse the printing order and print the active worksheet from the last page to the first one with only one click.

Stampa Paġna Kurrenti

Din l-utilità tippermettilek li tipprintja malajr il-paġna stampata (il-paġna kurrenti) li ċ-ċellola attiva jqiegħedha fi klikk waħda.

Stampa Paġni Speċifikati

With this utility, you can easily print only odd or even pages, or the specified range of pages in active worksheet.

Kopja ta 'Page Setup

Qatt kopja l-iffissar tal-konfigurazzjoni tal-paġna mill-worksheet attiva għall-worksheets l-oħra fl-istess workbook. Is-settings tal-konfigurazzjoni tal-paġna jinkludu oġġetti bħal headers, footers, marġini, orjentazzjoni tal-paġna, eċċ.

Subtotali għall-ippakjar

Kultant meta nipprintjaw il-karta tas-salarju u d-dħul tad-dħul tal-bejgħ f'Excel, nistgħu rridu nipprintjaw informazzjoni addizzjonali (bħal Somma, valur massimu) fuq kull paġna stampata. B'din l-utilità, tista 'daħħal żewġ fillieri ġodda fl-aħħar ta' kull paġna stampata. L-ewwel ringiela fiha titoli ta 'operazzjoni, u t-tieni ringiela fiha data relattiva.

Daħħal Paġna Tkisser Kull Ringiela

This handy feature will quickly insert page breaks after every specified number of rows in the active worksheet. For example, it can insert page breaks after every 10 rows in bulk.

Żid il-Fruntiera għal Kull Page

With this feature, you can one click to quickly add borders to each page in the active worksheet in bulk.

icon SplittoColumns

Split għal Kolonni

With this utility, you can quickly print columns in multiple segments to fit on one printed page in Excel.

Let's say you have 200 names in a column and want to print them in columns of 50 on one printed page. With this utility, you can quickly get it done, and it will save much ink and paper.

Importazzjoni / Esportazzjoni

Ġabra ta 'għodda tippermetti li tipproċessa malajr l-operazzjonijiet li ġejjin.

Firxa ta 'esportazzjoni għal fajl

Easily export a range of data to a file, either an Excel workbook, a CSV, a simple HTML or all formatting HTML.

Esportazzjoni Medda bħala Grafika

Malajr jikkonverti firxa (u l-oġġetti grafiċi murija fil-medda) tal-worksheet attiva għal immaġini f'format Gif, JPEG, TIF jew PNG.

Grafika tal-Esportazzjoni

Normally if you want to export a chart from Excel, you may need to copy this chart and paste it on a drawing tool, and then save it as an image file. With this utility, you can export a lot of graphics as images quickly.

Importa Stampi

This utility can help you import multiple pictures. You can specify the arrangement rule and height for all pictures.

Immaġina Importa Importazzjoni

This fantastic feature can import and insert pictures based on cell contents in one column/ row.

Daħħal il-Fajl f'Cursor

Daħħal malajr il-kontenut komplut tal-worksheet, il-fajl CSV, il-fajl tat-test jew il-fajl PRN fil-pożizzjoni kurrenti tal-cursor tal-worksheet attiv. Pereżempju, b'din l-għodda tista 'faċilment daħħal worksheets multipli-bl-istess struttura ta' data- minn kotba ta 'ħidma differenti f'kopja waħda.

Lista tal-Fajl

Microsoft Windows® does not provide a way to print a list of the file names contained in a directory. With this tool, you can easily create a new workbook containing a list of the filenames from a specified directory, you can choose to include the sub-directory and create hyperlinks to the file names.

Oħloq folders Ibbażat fuq il-Kontenut taċ-Ċellula

This utility can help you easily create lots of file folders in a specified location using the cell contents as file folder names in Excel. For example, you can quickly create a file folder for each of employees by using their names to name the file folder.

Grupp ta 'Sigurtà

Encrypt Cells

With this utility, you can encrypt the selected cells. (the formula cells cannot be encoded). Here is the Usage:

1. Agħżel il-medda li tixtieq tikkrypt.
2. Click "Encrypt Cells".
3. Input the password. (The password can be letters, numbers and special characters)

Iċċekkja ċelloli

Din l-utilità biss tiddiżiprivja ċ-ċelloli li kriptati bil-Encrypt Cells of Kutools għal Excel.

Ipproteġi l-Folja tax-Xogħol

With this utility, you can quickly protect multiple worksheets with the same password in the current workbook. Here is the usage:

1. Only the unprotected worksheets will be listed in the dialog box, please select the worksheets that you want to protect and click "OK".
2. Enter a password to protect worksheets, and you can set other options for how you would like the worksheets to be protected.
3. Ikklikkja "OK".

Ipproteġi l-Folja tax-Xogħol

If multiple worksheets are protected by the same password, this utility can quickly unprotect these worksheets in bulk. Here is the usage:

1. Only the protected worksheets will be listed in the dialog box, please select the worksheet you want to unprotect and click OK.
2. Enter the password to unprotect the worksheets.

Mailings Group

Oħloq Mailing List

With this feature, you can quickly create a list of recipients in an Excel table.

Ibgħat Emails

This feature will help you to send personalized emails to multiple recipients in bulk.

Grupp Iffiltrat u Statistiku

Tip Avvanzat

Quickly sort data by special criteria in Excel.

With this utility, you can quickly sort data in selection by Text length, Month, Last name, Day, Absolute value, Odd and even number, Mail domain, and Frequency. With the built-in Excel Sort command, you can only sort data by values, Cell Color, Font Color and Cell Icon.

Super Iffiltra

Din l-utilità tappoġġja malajr il-filtrazzjoni tal-worksheet kollha billi tgħaqqad kundizzjonijiet multipli. Tista 'żżid, tħassar jew tiddiżattiva l-kondizzjonijiet faċilment.

Għadd bil-Kulur

Calculate cells by background color or font color.

This utility will calculate the cells based on cell background color or font color in the range and generate a report with information, such as how many cells that have the same background/font color, the sum value of same background/font color cells, the average value of same background/font color cell, the max value of same background/font color and the min value of same background/font color cell.

icon PagingSubtotal

Subtotali għall-ippakjar

Insert a row into each printed page for analyzing and calculate each column.

Insert a row into each printed page for analyzing and calculating each column. It supports count, average, and sum values in the corresponding column, find out the max / min value from the specified column, and product and count numbers of the column.

Filtru speċjali

A collection of tools help you to quickly filter data with special criteria.

Iffiltra grassa

This feature will quickly filter out all bold cells in the column containing the active cell with only one click.

Filtru Italiku

This feature will automatically filter out cells by italics formatting in the column containing the active cell with only one click.

Strikethrough tal-filtru

This feature will automatically filter out cells by strikethrough formatting in the column containing the active cell with only one click.

Kumment Iffiltra

This feature will filter out all cells containing comments in a selected column.

Formula tal-Filtru

This feature will filter out all cells containing formulas in a selected column.

Iffiltra Merged

This feature will automatically filter out all merged cells in the column containing the active cell with only one click.

Filtru speċjali

This feature supports multiple special filter criteria to help you filter easily. It includes:

  1. Iċ-Ċelloli tal-filtru b'Kapucase / Lowercase
  2. Iċ-Ċelloli tal-Filtru bit-Tul tat-Test
  3. Iċ-Ċelloli tal-Filtru Permezz ta 'Xogħol / Weekend / Jum Speċjali Tal-Ġimgħa
  4. Iffiltra ċ-Ċelloli Kollha bil-Karattri skuri
  5. Iffiltra ċ-Ċelloli Kollha Permezz tal-Italja
  6. Iċ-Ċelloli tal-Filtru Bil Strikethrough
  7. Iffiltra ċ-Ċelloli kollha bil-Kummenti
  8. Iffiltra ċ-Ċelloli Kollha li fihom Formula
  9. Iffiltra ċelloli Merged
  10. Ċelloli tal-filtru Permezz Il-Kulur tat-Tip
  11. Iċ-Ċelloli tal-Filtru Permezz tal-Kulur tal-Isfond

Common processing

Re-run Last Utility

Applika malajr l-utilità ta 'Kutools għall-Excel li għadek kif nediet qabel bi klikk waħda.

jgħinu

Informazzjoni dettaljata dwar Kutools għal Excel.

lingwi

Set and change displaying language of Kutools for Excel.

Modalità ta 'toolbar

Set and change the toolbar mode of Kutools tab and Kutools Plus tab to the suit your toolbar.

Ċentru ta 'Twaqqif

Tinkludi l-Settings li ġejjin:
1: Itfi jew jippermetti l-add-in ta 'Kutools għal Excel.
2: Konfigurazzjonijiet ċari u caches ta 'dan add-in.
3: Set the language of the software.
4: Iċċekkja l-informazzjoni tar-reġistrazzjoni tal-utent.

Resister

If you have purchased a license, you can register the software here, or you can click on the "Purchase" button to purchase a license from our website.

Iċċekkja għal Aġġornamenti

Check and install the latest version of Kutools for Excel.

Get Help

Get help from our website https://www.extendoffice.com.

dwar

Juri informazzjoni dettaljata dwar Kutools għal Excel, bħal verżjoni, informazzjoni dwar il-liċenzja, eċċ.

Protect Group

shot design tab protect group

Għażla Lock

One click to set the formatting of current selection as lock.

Għażla Issib

One click to set the formatting of current selection as unlock.

Highlight unlocked

One click to highlight all cells formatting as unlocking in the whole workbook.

Formuli Hide

One click to hide the formulas in cells of selection. The hidden formulas will not display in the formula bar after you protect the worksheet.

Formuli Unhide

One click to show all hidden formulas in the selection.

Highlight Hidden

One click to highlight all cells whose formulas are formatting as hidden in the whole workbook.

View Grupp

Tfisser Formuli

One click to highlight all cells containing formulas in the whole workbook.

Ismijiet Highlight

One click to highlight all named ranges in the whole workbook.

Monitor Group

Monitor Precedents / Dependents

These features can help you quickly automatically display all dependents and precedents in a selected range in real time with one click. It includes:

  1. Immonitorja Preċedent tal-Firxiet
  2. Segwi d-dipendenti tal-firxiet
  3. Preċedent u dipendenti tal-Monitoraġġ

Settings

In the Design Tools Settings center, you can configure as follows:

  1. Enable the protect options to automatically protect and unprotect worksheets;
  2. Specify the highlight colors for unlocked ranges, formulas hidden ranges, formulas cells, and named ranges.

Disinn mill-qrib

Click to exit the Design tab.