Mae cwcis yn ein helpu i gyflwyno ein gwasanaethau. Drwy ddefnyddio ein gwasanaethau, rydych yn cytuno i'n defnydd cwcis.
Tip: Mae ieithoedd eraill yn Google-Cyfieithu. Gallwch ymweld â'r English fersiwn o'r ddolen hon.
Mewngofnodi
x
or
x
x
cofrestr
x

or

Kutools - Yn Cyfuno Mwy o Swyddogaethau ac Offer Uwch 300 ar gyfer 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

Gweler sut mae Kutools ar gyfer Excel yn arbed eich amser yn Excel 2019 / 2016 / 2013 / 2010 / 2007 / Office 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
Gweld y Grŵp Ranges & Cells Group Grŵp Golygu Grŵp Fformiwla

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 Grŵp Diogelwch Mailings Group Grŵp Hidlo ac Ystadegol

Tab dylunio

shot design tab 02
shot design tab 03
shot design tab 04
shot design tab 05
Protect Group Gweld y Grŵp Monitor Group Options Group

Nodyn: Y dylunio tab is turned off by default. Excel users can toggle it by Kutools Mwy > Dylunio Taflenni Gwaith.

Gweld y Grŵp

Panelau Navigation:

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

Nid yn unig y mae Pane Navigation yn rhestru'r holl lyfrau gwaith, taflenni gwaith, colofnau ac enwau mewn ffenestr adeiledig i chi, ond mae hefyd yn ychwanegu at Excel gyda nodwedd ddiddorol sy'n eich galluogi i edrych yn rhwydd ar yr holl lyfrau gwaith, taflenni gwaith, a newid rhwng pob un ohonynt. A beth sy'n fwy? Gallwch ddewis yn gyflym a mynd i'r golofn ac enw penodol yn eich llyfrau gwaith. Gallwch lusgo a gollwng y Panelau Navigation i unrhyw safle yn eich ardal waith, a gellir ei weithredu i guddio neu ddangos gydag un clic.

Maint Maes Gwaith:

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.

Darllenwch Layout 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

colofnau

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

Gyda'r cyfleustodau hwn, gallwch gyflym gwelededd colofnau cudd gydag un clic. Bydd un clic yn dangos yr holl golofnau cudd yn yr ystod a ddefnyddir, cliciwch eto bydd yn gosod yr holl golofnau cudd yn anweledig.

Taflenni gwaith

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.

Dangos / Cuddio

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

Gosod Ardal Sgrolio:

Mae'n ffordd wych o osod neu gyfyngu ar yr ardal sgrolio yn eich llyfr gwaith. Os ydych chi'n symud llawer o'ch taflen waith o gwmpas, neu os oes gennych ddata nad ydych am i ddarllenwyr ei archwilio, mae'r offeryn hwn yn gyfleus i chi gyfyngu ar ardal weledol eich taflen waith at yr unig ddata sydd â data gwirioneddol.

Unhide Pob Rang:

Gallwch ddadlwytho'r holl ystodnau cudd yn y daflen waith weithredol yn gyflym.

Hide Unselected sheets:

Mae'n eich galluogi i guddio'r holl daflenni anweithredol (heb eu dewis) yn gyflym yn y llyfr gwaith gweithredol (cyfredol) gydag un clic.

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.

Cuddio Windows Anweithgar:

Os ydych wedi agor lluoslyfrau gwaith yn Excel, mae'r offeryn hwn yn eich galluogi i guddio'r holl lyfrau gwaith anweithgar eraill gydag un clic yn gyflym.

Unhide All Hidden Windows:

Dadlwythwch yr holl lyfrau gwaith cudd gydag un clic. Fel arfer mae'n rhaid i chi ddadwneud pob llyfr gwaith cudd un i un yn Excel.

Hide/Unhide Workbooks and Sheets:

Cuddio neu ddadlwytho llyfrau gwaith lluosog a thaflenni gwaith yn rhyngweithiol ar un adeg. Fel rheol mae'n rhaid i chi guddio neu ddadwneud y llyfr gwaith a'r daflen waith un i un yn Excel. Mae hwn yn offeryn defnyddiol i chi drin llyfr gwaith mawr gyda bwndel o daflenni gwaith.

Dewisiadau Gweld:

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

Ystod

Mae casgliad o gyfleustodau yn eich galluogi i brosesu'r gweithrediadau canlynol mewn cyflymder a chelloedd yn gyflym.

Cyfunwch yr un Celloedd

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.

Ymunwch â 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.

Troi Ystod Llorweddol

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.

Troi Ystod Fertigol

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.

Trosi Dimensiynau Tabl:

Gyda'r cyfleuster Dimensiwn Tabl Trosglwyddo hwn, gallwch chi drawsnewid tabl croes (dau ddimensiwn) yn gyfleus i restr fflat (un dimensiwn) ar yr un pryd, ac is-bennill.

Ystod Trawsnewid:

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.

Rangau Cyfnewid:

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.

Ystod Dosbarthiad Ar hap:

Gyda'r cyfleustodau hwn, gallwch chi gyflymu celloedd mewn amrywiaeth ar hap, i ddidoli celloedd yn seiliedig ar bob rhes neu golofn ar hap, i ddidoli rhes neu golofn gyfan ar hap, i ddewis celloedd, rhesi neu golofnau cyfan ar hap.

Gludwch i Ystod Gweledol

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

Gosodwch Ardal Sgroli

Mae'n ffordd wych o osod neu gyfyngu ar yr ardal sgrolio yn eich llyfr gwaith. Os ydych chi'n symud llawer o'ch taflen waith o gwmpas, neu os oes gennych ddata nad ydych am i ddarllenwyr ei archwilio, mae'r offeryn hwn yn gyfleus i chi gyfyngu ar ardal weledol eich taflen waith at yr unig ddata sydd â data gwirioneddol.

Unhide all Ranges

Gallwch ddadlwytho'r holl ystodnau cudd yn y daflen waith weithredol yn gyflym.

Cymharu Celloedd

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

Atal Teipio

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.

Atal Dyblyg

Gall y cyfleustodau hyn atal datgelu data dyblyg mewn un golofn gydag un clic. Mae'r cyfleustodau hwn yn cyflawni'r un swyddogaeth â nodwedd dilysu Data Excel, ond dim ond i chi ddewis un golofn ac yna cymhwyso'r cyfleustodau hwn, yna ni allwch deipio gwerthoedd dyblyg yn yr un golofn.

Atal Teipio

Yn hawdd i atal cymeriadau arbennig neu rai rhag cael eu teipio mewn celloedd

Dim ond caniatáu i gymeriadau penodol gael eu cofnodi mewn ystod o gelloedd

icon CopyRanges

Rhyddhau Copi:

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

Cynnwys

Mae casgliad o offer yn eich galluogi i brosesu'r gweithrediadau canlynol yn gyflym.

Trosi rhwng Testun a Rhif:

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.

Trosi Fformiwla i'r Testun:

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

Trosi Testun i Fformiwla:

Gyda'r cyfleustodau hwn, bydd yn trosi fformiwlâu sydd wedi'u storio fel fformat testun yn fformiwlâu go iawn.

Trosi hyd yma:

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.

Trosi Amser

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.

Trosi Arian:

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).

Trosi Uned:

Trosi yn gyflym fesuriadau o un uned i'r llall yn eich Excel. Mae'n cefnogi'r mesuriadau canlynol: Angle, Bits bytes, Pellter, Ynni, Llu, Ffynhonnell, Cyfrol, Màs, Hylif, Amser a Thymheredd.

Trosi Systemau Rhif

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.

Rhifau Sillafu

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".

Newid Arwydd Gwerthoedd:

Gyda'r cyfleustodau Excel hwn, gallwch chi hawdd atgyweirio arwyddion negyddol trawiadol; newid pob arwydd negyddol i gadarnhaol; newid pob arwydd cadarnhaol i negyddol a gwrthdroi arwydd pob gwerth. Nid oes angen i chi ddefnyddio fformiwla ar gyfer prosesu'r gweithrediadau uchod.

Trosi rhwng Rhufeinig a Rhif

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

Newid Arwydd Gwerthoedd

Gyda'r cyfleustodau Excel hwn, gallwch chi hawdd atgyweirio arwyddion negyddol trawiadol; newid pob arwydd negyddol i gadarnhaol; newid pob arwydd cadarnhaol i negyddol a gwrthdroi arwydd pob gwerth. Nid oes angen i chi ddefnyddio fformiwla ar gyfer prosesu'r gweithrediadau uchod.

Trosi Rhif i'r Gorchmynion

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.

Cyfresi Cyfuniad Uwch

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.

Rownd (Heb Fformiwla):

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.

Cyfuno (Ffurflenni a Cholofnau):

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.

Er enghraifft, gallwch chi gyfuno'r data yng ngholofnau AD, a'i roi i mewn i golofn A. Mae gennych dri opsiwn i drin y data sydd wedi'i gyfuno. Gallwch ei gadw, ei ddileu, neu greu celloedd cyfun. Fel opsiwn, gallwch nodi un neu fwy o gymeriadau i fewnosod rhwng y data cyfun (er enghraifft, llinell newydd neu mewnosod testun).

Grŵp Golygu

Darganfyddiad Super

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

Dewch o hyd i llinynnau testun penodol yn unig yn y sylwadau

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

Dewch o hyd i llinynnau testun penodol yn unig yn y fformiwlâu

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.

Chwiliwch werthoedd testun penodol yn unig mewn hypergysylltiadau

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

Dewch o hyd i llinyn testun penodol yn unig yn y gwerth celloedd

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

Darganfyddwch gelloedd sy'n cynnwys gwerthoedd math dyddiad yn seiliedig ar feini prawf

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.

Darganfyddwch rifau yn seiliedig ar feini prawf

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.

Dod o hyd i bob celloedd gyda fformatio celloedd penodol

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.

Chwiliad diflas

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

dewiswch

Mae casgliad o offer yn gwneud dewis o eitemau amrywiol yn haws yn Excel.

Dewiswch Range Helper

Mae'n gyfleustodau defnyddiol i'ch helpu i ddewis, dad-ddewis, a gwrthdroi dewisiadau lluosog yn y llyfr gwaith gweithredol. Gyda hi, gallwch wneud y gweithrediadau canlynol yn gyflym:

  1. Dewiswch ystodau lluosog heb ddal i lawr yr allwedd Ctrl;
  2. Dileu celloedd o ystodau dethol;
  3. Aildroi ystodau dethol.
Dewiswch Rhesymau a Pholymau Cyfartal

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.

Dewiswch Gelloedd Cyfun

Dewiswch yr holl gelloedd cyfun mewn ystod gydag un clic. Dewiswch amrediad a chliciwch ar "Dewis Celliau Cyfun", yna bydd pob celloedd cyfun yn yr ystod hon yn cael eu dewis.

Dewiswch 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.

Dewiswch Gelloedd gyda Max neu Werth Min:

Nid yw'r offeryn hwn yn dewis y gwerth lleiafswm neu'r uchafswm yn unig mewn ystod ddethol o gelloedd ond hefyd yn mynd i union leoliad y gwerth isafswm neu'r uchafswm. Yn Excel, gallwch ddefnyddio'r swyddogaeth MIN a MAX i ddewis y gwerth isafswm neu'r uchafswm, ond ni all fynd i'r union sefyllfa o werth isafswm neu uchafswm.

Dewiswch Cells gyda Gwerth Gwall

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

Dewiswch Gelloedd Datgloledig

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

Dewiswch Gelloedd Unblank

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.

Dewiswch Gelloedd Penodol

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.

Dewiswch Cells gyda Fformat

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.

Dewiswch Dyblyg a Chelloedd Unigryw

Gall y cyfleustodau hyn eich helpu i gyflym ddewis y gwerthoedd dyblyg neu unigryw neu gyfres cyfan o golofn neu amrediad.

Dewiswch yr un celloedd a gwahanol gelloedd

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

Mewnosod

Casgliad o offer mewnosod.

Mewnosod Llifiau Teitlau

Weithiau mae'n bosib y bydd angen i ni ychwanegu teitl ar gyfer pob rhes, fel bil Cyflog. Gall y cyfleustodau hwn fewnosod yn gyflym deitlau ar gyfer rhesi.

Rhowch Ffrwythau a Pholymau Gwag:

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.

Mewnosod Data Ar hap

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.

Mewnosod Rhif Dilyniant

Mewnosod yn gyflym werth unigryw (ac olynol) i mewn i gell yn Excel. Gallwch ychwanegu rhagddodiad neu atodiad y testun a nodi nifer y digidau ar gyfer y rhif. Er enghraifft, gallwch chi fewnosod rhif cyfres yn hawdd fel Kutools-XXXX-2011 (XXXX yn nodi rhif y dilyniant).

Darganfyddwch Nifer y Dilyniant Angenrheidiol

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

Llenwch Restrau Custom

Gan ddefnyddio'r nodwedd hon, gallwch chi greu eich rhestrau arferol yn gyflym ac yn eu cadw i mewn i'r blwch rhestr ac yna eu llenwi i mewn i'r celloedd taflenni gwaith yn fertigol neu'n llorweddol.

Rhestrwch Pob Cyfuniad

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

Mewnosod Bwled

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.

Mewnosod Rhifio

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.

Mewnosod Dyddiad

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.

Llenwi Celloedd Blank

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

  1. Llenwi celloedd gwag gyda gwerthoedd uchod, isod, i'r chwith neu'r dde.
  2. Llenwi celloedd gwag gyda gwerthoedd llinol.
  3. Fill blank cells with a fixed value, such as 0.
Batch Mewnosod Blychau Gwirio

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.

Llwyth Mewnosod Botymau Opsiwn

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.

Mewnosod Watermark

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

Testun Auto

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.

Dileu

Mae casgliad o offer yn eich galluogi i brosesu'r gweithrediadau canlynol yn gyflym.

Dileu Llwybrau Gwag

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.

Dileu Rhesiau a Colofnau Cudd (Gweladwy)

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.

Dileu Watermark

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

Dileu Darluniau a Gwrthrychau

Gyda'r cyfleustodau hwn, gallwch:

  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.
Dileu Rheolaethau Gwe

Gall y cyfleustodau hyn eich helpu i ddileu'r holl reolaethau gwe gydag un clic.

Batch Delete Box Boxes

This feature can remove the selected checkboxes at once.

Llwyth Dileu Botwm Opsiwn

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

Dileu Pob Macros

Dileu yn gyflym unrhyw un o'r macros canlynol o'ch llyfr gwaith: modiwlau VBA, UserForms, taflenni gwaith dialog 5 / 95 Excel, neu Excel 4 XLM taflenni gwaith.

Swp Tynnu Pob Macros

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

Testun

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

Ychwanegu Testun

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
Dyfyniad testun

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

Dyfyniad Cyfeiriad E-bost

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

Dileu Mannau

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
Tynnwch Leeros Zeros

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

Dileu yn ôl Safle

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.

Dileu Nodweddion

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

  1. Dileu cymeriadau rhifol o gelloedd
  2. Tynnwch gymeriadau alffabetig o gelloedd
  3. Tynnwch gymeriadau nad ydynt yn rhifol o gelloedd
  4. Dileu cymeriadau nad ydynt yn aeddfetig o gelloedd
  5. Dileu cymeriadau na ellir eu hargraffu o gelloedd
  6. Dileu cymeriadau nad ydynt yn alffaniwmerig o gelloedd
  7. Tynnwch gymeriadau addas o gelloedd
Niferoedd o danysgrifiadau yn Fformiwlâu Cemegol

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

Newid Achos

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.
Gorchymyn Gwrthod Testun

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”;
Anfon Caractorau Acennig yn lle

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

Enwau Hollti

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

Rhannu Celloedd

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.

fformat

Casgliad o offer ar gyfer fformatio.

Rhedio Amgen / Sailio Colofn

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)

Fformat y testun yn hawdd fel superscript neu isysgrif mewn cell. Gallwch hefyd ddefnyddio'r nodweddion Bold ac Eidaleg a'r achos (uchaf neu isaf) ar gyfer cymeriadau'r wyddor. Mae'n offeryn perffaith i chi weithio gyda fformiwlâu mathemategol neu gemegol yn Excel.

Gwneud cais Dyddiad Fformatio

Gyda'r cyfleustodau hwn gallwch newid fformatio dyddiad yr amrediad a ddewiswyd yn gyflym.

Copïo Ffurfio Cell

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.

Clirio Pob Ffurfio Celloedd

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.

Addasu Maint Cell

Mae'r cyfleustodau hwn yn eich helpu i addasu lled yr uchder a lled y golofn yn gyflym mewn punnoedd, centimetrau, modfedd neu bicseli. Gall wneud cais i amrediad neu'r daflen waith gyfan.

Cyswllt

Casgliad o offer ar gyfer hypergysylltiadau a chyfeiriadau allanol (dolenni).

Trosi Hypergysylltiadau

Gyda'r cyfleustodau hwn, gallwch drosi testun (URL) yn gyflym yn hypergysylltiadau, cymhwyso cyfeiriadau hypergysylltu lluosog i gynnwys celloedd (testun) a throsi cyfeiriad hypergysylltu lluosog i mewn i destun yn Excel.

Dod o hyd a chreu cysylltiadau brwd

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

Dileu Hypergysylltiadau

Trosi yn gyflym hypergysylltiadau mewn celloedd i destun plaen. Gallwch ddileu'r holl hypergysylltiadau yn: Range Range; taflen waith weithredol; taflenni gwaith dethol a phob taflen waith.

Mwy

More tools will be located here.

Cyfrifiannell

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.

Ymgyrch

Yn perfformio gweithrediadau mathemateg cyffredin mewn celloedd, megis adio, tynnu, lluosi, rhannu, ac ati. Er enghraifft, gallwch ddefnyddio'r offeryn hwn yn hawdd i gynyddu colofn o brisiau amrywiol gynhyrchion gan 2 y cant.

Newid Sylwedd Shape

Newid yn gyflym siâp pob sylw yn Excel.

Creu Rhestr Sylwadau

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

Fformat Sylw

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.

Darganfyddwch / Amnewid Testun Sylw

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

Tynnwch / Ychwanegwch Enw Defnyddiwr yn Sylw

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.

Trosi Sylw a Cell

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

  1. Trosi cynnwys cell i sylwadau
  2. Trosi sylwadau i gynnwys celloedd
  3. Mewnosodwch gynnwys celloedd i sylwadau
  4. Rhowch sylwadau i gynnwys celloedd
Sylw AutoFit

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

Ailosod Safle Sylw

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.

Grŵp Fformiwla

Swyddogaethau Kutools

A collection of built-in functions.

Dyddiad ac Amser

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

Ystadegau a Mathemateg

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
Testun

This series of built-in functions contain:

  1. Rhifau Dyfyniad: Extract numbers from mixed text string with the function
  2. Testun Gwrthdroi: Gorchmynion cymeriadau gell yn ôl yn hawdd mewn cell â swyddogaethau

Copi Cywir (Fformiwla)

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 $.

Trosi Cyfeiriadau (Cyfeiriadau)

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. Trosi fformiwlâu i gyfeirio absoliwt ($ F $ 5)
  2. Trosi fformwlâu i gyfeiriadau cymharol (F5)
  3. Trosi fformiwlâu i linellau cymharol a cholofnau absoliwt ($ F5)
  4. Trosi fformiwlâu i rhesi absoliwt a cholofnau cymharol (F $ 5)

Mwy

Mwy o offer ar gyfer trin fformiwlâu yn Excel.

Ailosod Enwau Ystod

Mae'r offeryn hwn yn ychwanegu at Excel gyda nodwedd ar gyfer disodli cyfeirnod enw yn y fformiwlâu dethol gyda'r cyfeiriad cyfatebol. Oherwydd bod y celloedd yn cynnwys fformiwlâu, mae hwn yn nodwedd eithaf defnyddiol i chi barhau i ddefnyddio cyfeiriadau enw heb effeithio ar y fformiwlâu dethol.

Cuddio / Enw Amrediad Unhide

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

Gwall Cyflwr Gwall

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.

Yn dynamig Cyfeiriwch at Daflenni Gwaith

Gall y cyfleustodau hyn eich cynorthwyo'n gyflym i lenwi'r cyfeiriadau un celloedd o daflenni gwaith lluosog i mewn i un daflen waith. Gallwch eu llenwi yn fertigol neu'n llorweddol. Gan dybio bod gennych lyfr gwaith sy'n cynnwys taflenni gwaith lluosog, ac nawr rydych am dynnu'r holl gyfeiriadau un celloedd (A1, er enghraifft) o daflenni gwaith eraill i mewn i un daflen waith, gyda'r swyddogaeth hon, gallwch gael y canlyniad yn gyflym = Sheet1! A1, = Sheet2! A1, = Sheet3! A1, = Sheet4! A1 ... i mewn i daflen waith feistr.

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. Monitro Rhagfynegiadau Ceffylau
  2. Monitro Dibynyddion Rhodfeydd
  3. Monitro Rhagflaenwyr a Dibynyddion

Workbook & Sheets Group

Llyfr Gwaith

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

Rhannu Llyfr Gwaith

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.

Fformat Ffeil Converter

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. Trosi ffeiliau XLSX lluosog i ffeiliau XLS yn Excel
  2. Trosi ffeiliau XLS lluosog i ffeiliau XLSX yn Excel
  3. Trosi llyfrau gwaith lluosog i ffeiliau PDF yn Excel
Mewnosod Gwybodaeth Llyfr Gwaith

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

Ffolder Cynnwys Agored

Agorwch y ffolder yn gyflym y mae'r llyfr gwaith gweithredol yn aros ynddi.

Copi Llwybr Llawn

Copïwch lwybr llawn y llyfr gwaith gweithredol yn gyflym, ac yna gallwch chi lwytho llwybr llawn y llyfr gwaith gweithredol i'r lle rydych chi am ei ddefnyddio.

Cuddio Windows Anweithgar

This feature will hide all inactive workbooks with one click.

Unhide All Windows Cudd

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

Agorwch y Llyfrau Gwaith hyn Nesaf Amser

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.

Taflenni gwaith

Mae casgliad o offer yn eich galluogi i brosesu'r gweithrediadau canlynol mewn taflenni gwaith yn gyflym.

Cydamseru Taflenni Gwaith

Dewiswch holl daflenni gwaith y llyfr gwaith gweithredol yn gyflym yn pwyntio ar yr un rhif rhes (mae gan bob taflen waith yr un dewis amrywiaeth a'r gell chwith uchaf â'r ddalen weithredol).

Dosbarthu Taflenni

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.

Rhewi Taflenni Gwaith Lluosog Panelau

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

Agorwch Daflenni Gwaith Lluosog Panelau

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

Ail-enwi Taflenni Gwaith

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.

Creu Rhestr o Enwau Taflen

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.

Copi Taflenni Gwaith

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.

Creu Taflenni Gwaith Sequence

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.

Calendr Perpetual

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.

Rhannu Data

Gall y cyfleustodau hyn rannu data mewn amrywiaeth mewn taflenni gwaith lluosog yn seiliedig ar golofnau penodol neu resi sefydlog.

Dileu Taflenni Gwaith Blank

Dileu yn gyflym yr holl daflenni gwaith gwag (yn cynnwys taflenni gwaith cudd) o'r llyfr gwaith gweithredol.

Dileu Pob Taflen Gudd

Dileu pob taflen waith cudd o'r llyfr gwaith gweithredol (cyfredol) yn gyflym.

Dileu Pob Taflen Anweithredol

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.

Rhannu Data

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

Fformat Converter

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

  1. Trosi ffeiliau XLSX lluosog i ffeiliau XLS yn Excel
  2. Trosi ffeiliau XLS lluosog i ffeiliau XLSX yn Excel
  3. Trosi llyfrau gwaith lluosog i ffeiliau PDF yn Excel

Rhannu Llyfr Gwaith

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

Dylunio Taflenni Gwaith

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

Argraffu

Mae casgliad o offer yn eich galluogi i brosesu'r gweithrediadau canlynol yn gyflym.

Argraffwch Wizard Lluosog Wizard

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.

Argraffu Dewis Lluosog Dewin

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.

Argraffwch y Tudalen Gyntaf o bob Taflen Waith

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

Tudalennau Argraffiad yn y Gorchymyn Gwrthwynebu

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

Argraffu Tudalen Gyfredol

Mae'r cyfleustodau hwn yn eich galluogi i argraffu'r dudalen argraffedig (y dudalen gyfredol) yn gyflym lle mae celloedd gweithredol yn dod i mewn gydag un clic.

Argraffu Tudalennau Penodedig

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

Copi Setup Tudalen

Copïwch y gosodiad gosod tudalen yn gyflym o'r daflen waith weithredol i'r taflenni gwaith eraill yn yr un llyfr gwaith. Mae gosodiadau gosod tudalen yn cynnwys eitemau megis penawdau, footers, ymylon, cyfeiriadedd tudalen, ac yn y blaen.

Is-nodiadau Paging

Weithiau pan fyddwn yn argraffu'r daflen gyflog a'r adroddiad refeniw gwerthiant yn Excel, efallai y byddwn am argraffu gwybodaeth ychwanegol (fel gwerth Sum, Max) ar bob tudalen argraffedig. Gyda'r cyfleustodau hwn, gallwch chi osod dwy rhes newydd ar ddiwedd pob tudalen argraffedig. Mae'r rhes gyntaf yn cynnwys teitlau gweithredu, ac mae'r ail res yn cynnwys data cymharol.

Rhowch y dudalen Egwyliwch Pob Rhed

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.

Ychwanegwch Ffiniau i bob Tudalen

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

icon SplittoColumns

Rhannwch i Golofnau

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.

Mewnforio / Allforio

Mae casgliad o offer yn eich galluogi i brosesu'r gweithrediadau canlynol yn gyflym.

Ystod Allforio i Ffeil

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

Ystod Allforio fel Graffeg

Trosi ystod yn gyflym (a'r gwrthrychau graffig a ddangosir yn ystod) y daflen waith weithredol i ddelwedd yn fformat Gif, JPEG, TIF neu PNG.

Graffeg Allforio

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.

Mewnforio Lluniau

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

Lluniau Mewnforio Match

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

Mewnosod Ffeil yn Cyrchydd

Mewnosod yn gyflym cynnwys cyflawn y daflen waith, ffeil CSV, ffeil testun neu ffeil PRN i safle cyrchwr cyfredol y daflen waith weithredol. Er enghraifft, gyda'r offeryn hwn gallwch chi fewnosod hawdd daflenni gwaith lluosog - gyda'r un strwythur data - o wahanol lyfrau gwaith i mewn i un daflen waith.

Rhestr Enw Ffeil

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.

Creu Ffolderi Seiliedig ar Gynnwys Cell

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.

Grŵp Diogelwch

Amgryptio Celloedd

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

1. Dewiswch yr amrediad yr ydych am ei amgryptio.
2. Click "Encrypt Cells".
3. Input the password. (The password can be letters, numbers and special characters)

Dadgryptio Celloedd

Dim ond y celloedd sydd wedi'u hamgryptio ag Encrypt Cells of Kutools ar gyfer Excel y bydd y cyfleustodau hyn yn dadgryptio.

Diogelu Taflen Waith

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. Cliciwch "OK".

Dileu Taflen Waith

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

Creu Rhestr bostio

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

Anfon E-byst

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

Grŵp Hidlo ac Ystadegol

Trefnu Uwch

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.

Hidlo Super

Mae'r defnydd hwn yn cefnogi hidlo'r daflen waith yn gyflym trwy gyfuno nifer o gyflyrau. Gallwch ychwanegu, dileu neu analluoga'r amodau yn rhwydd.

Cyfrifwch Lliw

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

Is-nodiadau Paging

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.

Hidlo Arbennig

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

Hidlo Bold

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

Filter Italig

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

Hidlo Strikethrough

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

Hidlo Sylw

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

Fformiwla Hidlo

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

Hidlo wedi'i Gyfuno

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

Hidlo Arbennig

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

  1. Celloedd Hidlo Gan Uchafswm / Isafswm
  2. Celloedd Hidlo Hyd Hyd y Testun
  3. Celloedd Hidlo Erbyn Diwrnod Gwaith / Penwythnos / Diwrnod Penodol yr Wythnos
  4. Hidlo Pob Celloedd Trwy Gyferweddau Bold
  5. Hidlo Pob Cell Gan Eidaleg
  6. Celloedd Hidlo Gyda Strikethrough
  7. Hidlo Pob Cell Gyda Sylwadau
  8. Hidlo Pob Cell sy'n Cynnwys Fformiwla
  9. Hidlo Celloedd Cyfun
  10. Celloedd Hidlo Gan Lliw y Ffont
  11. Celloedd Hidlo Gan Y Lliw Cefndir

Common processing

Re-run Last Utility

Cymhwyswch gyfleustodau Kutools ar gyfer Excel yn gyflym eich bod chi newydd lansio o'r blaen gydag un clic.

Help

Gwybodaeth fanwl am Kutools ar gyfer Excel.

ieithoedd

Set and change displaying language of Kutools for Excel.

Modo Bar Offer

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

Canolfan Gosod

Mae'n cynnwys y Gosodiadau canlynol:
1: Analluoga neu alluogi'r Kutools ychwanegu at Excel.
2: Cyfluniadau clir a caches o'r ychwanegiad hwn.
3: Set the language of the software.
4: Gwiriwch wybodaeth gofrestru'r defnyddiwr.

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.

Gwiriwch am y Diweddariadau

Check and install the latest version of Kutools for Excel.

Cael Cymorth

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

Amdanom ni

Yn arddangos gwybodaeth fanwl am Kutools ar gyfer Excel, megis fersiwn, gwybodaeth am drwyddedau ac yn y blaen.

Protect Group

shot design tab protect group

Lock Dewis

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

Datgloi Dewis

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.

Fformiwlâu Cuddio

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.

Fformiwlâu Unhide

One click to show all hidden formulas in the selection.

Amlygu Cudd

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

Gweld y Grŵp

Amlygu Fformiwlâu

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

Enwau Goleuadau

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. Monitro Rhagfynegiadau Ceffylau
  2. Monitro Dibynyddion Rhodfeydd
  3. Monitro Rhagflaenwyr a Dibynyddion

Gosodiadau

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.

Dyluniad Cau

Click to exit the Design tab.