Script - Function #

savebysheetname #

Save each sheet as a separate file.

coloredRowDel #

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

Handling Duplication #

checkDuplication #

In the selected area, color the redundant value.

removeDuplicates #

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

clearFilter #

clear all filters.

fontset #

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