Cell format Script

cell outline

lineGray

Remove the guidelines and create the gray line.
→ click : outskirt of the cell range selected.
→ double click : entire cell of the cell range selected.
→ keyboard shortcut : ALT + SHIFT + 1

lineBlack

Remove the guidelines and create the black line.
→ click : outskirt of the cell range selected.
→ double click : entire cell of the cell range selected.
→ keyboard shortcut : ALT + SHIFT + 2

lineBlackBold

Remove the guidelines and create the bold black line.
→ click : outskirt of the cell range selected.
→ double click : entire cell of the cell range selected.
→ keyboard shortcut : ALT + SHIFT + 3

colorFill

fill gray color on the cell selected.
→ keyboard shortcut : ALT + SHIFT + 4

setA4

Adjust the page size for A4 size.
→ recommended for new worksheet.

colorpicker

Copy the color of the selected cell and paste it to the cell that is selected.

copyWidthHeight

Copy the width & height of the selected cell and paste it to the cell that is selected.

Value format Script

Number format

formatNum_normal

Change to a normal number format.
[yes - with right padding(accounting)] #,##0_-;[Red]-#,##0_-;-_-
[no - without right padding] #,##0;[Red]-#,##0;-

formatNum_thousand

Change in a thousand unit number format.
[yes - with right padding(accounting)] #,##0,-;[Red]-#,##0,-;-_-
[no - without right padding] #,##0,;[Red]-#,##0,;-

formatNum_mil

Change in a million unit number format.
[yes - with right padding(accounting)] #,##0,,-;[Red]-#,##0,,-;-_-
[no - without right padding] #,##0,,;[Red]-#,##0,,;-

formatNum_date

Change to a date format containing the day.
[yes - with day of the week] yyyy-mm-dd(aaa)
[no - without day of the week] yyyy-mm-dd

delHyperlink

Delete hyperlinks. The format is all erased together.

delBlank

Delete all the spaces of the selected cell.

Function Script

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”

Data Util Script

Calculation

growthRate

Calculate the growth rate.

achievementRate

Calculate the achievement rate.

CAGR

Calculate the CAGR.

WordFill

If there is a value in the right side of the selected reference column, fill the cell value in a DB format.

allDecimals

In the case of numbers with decimal points, all decimal points come out.

upsidedown

Return the data of the selected column and return it to the right side.

inputRandomValue

Enter the sequential date or random integer.

sepText

In the text that is mixed with characters+numbers, only the number is returned to the right side.

Handling Name

tableToArray

Copy the clipboard to set the table as a name definition.

shownamelist

Call the currently defined name list box. → double click : activate name area

pivotRefresh

Automatically update the Pivot Table.

LaunchTextSplitter

split text from pdf table.

dietFileSize

Excel file size diet. check all sheet and clear.