Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Content: Excel 2010 keyboard shortcuts - Crt combination shortcut keys. | Excel 2010 Keyboard Shortcuts Ctrl combination shortcut keys Click to edit headline title style Key CTRL+PgUp Description Key Description Switches between worksheet tabs, from left-to-right. Switches between worksheet tabs, from right-to-left. CTRL+SHIFT+Plus (+) Displays Insert dialog box to insert blank cells. CTRL+Minus (-) Displays Delete dialog box to delete selected cells. Unhides hidden rows within the selection. CTRL+; Enters current date. CTRL+SHIFT+& Applies outline border to selected cells. CTRL+' CTRL+SHIFT_ Removes outline border from selected cells. CTRL+1 Copies a formula from the cell above the active cell into the cell or the Formula Bar. Displays Format Cells dialog box. CTRL+SHIFT+~ Applies General number format. CTRL+2 Applies or removes bold formatting. CTRL+SHIFT+$ Applies Currency format with two decimal places (negative numbers in parentheses). CTRL+SHIFT+% Applies Percentage format with no decimal places. CTRL+3 Applies or removes italic formatting. CTRL+4 Applies or removes underlining. CTRL+SHIFT+^ Applies Scientific number format with two decimal places. CTRL+5 Applies or removes strikethrough. CTRL+SHIFT+# Applies Date format with day, month, and year. CTRL+6 Alternates between hiding and displaying objects. CTRL+SHIFT+@ Applies Time format with the hour and minute, and AM or PM. CTRL+8 Displays or hides the outline symbols. CTRL+SHIFT+! Applies Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Selects current region around active cells. In PivotTables, it selects entire PivotTable reports. Enters the current time. CTRL+9 Hides selected rows. CTRL+0 Hides the selected columns. CTRL+A Selects entire worksheet. CTRL+` Alternates between displaying cell values and displaying formulas. CTRL+SHIFT+A CTRL+SHIFT+" Copies value from cell above an active cell into the cell or the Formula Bar. CTRL+B Inserts argument names and parentheses when .