excel keyboard shortcut

CTRL key shortcuts / Nhóm phím tắt Ctrl trong Excel

Ctrl + page up: move to previous worksheet
Shift + Arrow keys: extend selection by one cell
Ctrl + Shift + Arrows: extend seleciton to the end of row or column
Ctrl + Shift + End: extend selection to the end of data
Ctrl + Shift + Home: extend selection to the cell A1
Ctrl + A: Select all
Shift + Spacebar: select row
Ctrl + Spacebar: select colum
ALT + ;: select visible data only
Ctrl + Shift + “+”: Insert cells, rows, or columns
Ctrl + “-“: Delete cells, rows, or columns
Ctrl + 9: Hide rows
Ctrl + 0: hide columns
Shift + F11: Insert new worksheet
Ctrl + B: Bold
Ctrl + I: Underline
Ctrl + Shift + &: Add outside border
Ctrl + Shift + “-“: Remove outside border
Ctrl + Shift + $: Currency format
Ctrl + Shit + %: Percentage format
Ctrl + Shift + !: numer format
Ctrt + Shift + ~: General format
Ctrl + 1: Format cells dialog box
Ctrl + Shift + F: Font tab of Format Cell dialog box
Ctrl + Shift + U: Expland formula bar
Alt + Enter: insert line
Shift + Space = chọn nguyên row
Ctrl + Space = chọn nguyên column
Để insert cột/ hàng
Ctrl + Shift + “=”: insert new column/ row
Để del cột/ hàng:
Alt + “=”: SUM tất cả các ô phía trên/ auto sum
Dùng trong Pivot Table:
Alt + F5: refresh data