└ Script-Function

Script-Function #

savebysheetname #

savebysheetname
Save each sheet as a separate file.

coloredRowDel #

coloredRowDel
Delete the row of the colored cell from the selected area.

Handling Duplication #

checkDuplication #

checkduplication
In the selected area, color the redundant value.

removeDuplicates #

removeduplicates
Remove the duplicate value from the value of the selected area and make and paste a new sheet.

clearFilter #

clearFilter
clear all filters.

fontset #

fontset
Set the font of active sheet to “Segoe UI” 10pt.
→ if using Korean apply “Malgun Gothic”

← └ Script-Value format └ Script-Data Util →