cell outline #

lineGray {ALT + SHIFT + 1} #

Remove the guidelines and create the gray line.
→ click : outskirt of the cell range selected.
→ double click : entire cell of the cell range selected.

lineBlack {ALT + SHIFT + 2} #

Remove the guidelines and create the black line.
→ click : outskirt of the cell range selected.
→ double click : entire cell of the cell range selected.

lineBlackBold {ALT + SHIFT + 3} #

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.

colorFill {ALT + SHIFT + 4} #

fill gray color on the cell selected.

setA4 #

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

delHyperlink #

Delete hyperlinks. The format is all erased together.

delBlank #

Delete all the spaces of the selected cell.

toFirstSheet #

Go to the first sheet.

savebysheetname #

Save each sheet as a separate file.

copyWidthHeight #

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

colorpicker #

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

fontset #

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

coloredRowDel #

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

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.

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

clearFilter #

clear all filters.