excel 2007快捷键和功能键（2007快捷键和功能键 excel）.docVIP

excel 2007快捷键和功能键（2007快捷键和功能键 excel） Excel 2007 shortcuts and function keys Core tip: the following list contains the Ctrl combination shortcut key, the function key, some other commonly used shortcuts, and their functional descriptions. Related downloads: Excel 2007 official edition The following list contains the Ctrl combination shortcut key, the function key, some other commonly used shortcuts, and their functional descriptions. Tip that you might need to print this topic so that you can refer to the content at work. To print this topic, press Ctrl+P. Note: if you do not have a shortcut key to use frequently, you can create a shortcut key by recording the macro. Ctrl combination shortcut key Button description Ctrl+Shift+ (to hide all hidden rows within the selected range. Ctrl+Shift+) to hide all hidden columns in the selected range. Ctrl+Shift+ applies the outline to the selected cell. Ctrl+Shift_ removes frames from selected cells. Ctrl+Shift+~ applies the regular digital format. Ctrl+Shift+$applies a currency format with two decimal places (negative numbers in parentheses). Ctrl+Shift+% applies percentages in a format that does not have small digits. Ctrl+Shift+^ uses an index format with two decimal places. Ctrl+Shift+# applications have day, month, and year date formats. Ctrl+Shift+@ applications have hours and minutes, and AM or PM in the time format. Ctrl+Shift+! With two decimal places, thousands separator and minus (-) (negative for) the number format. Ctrl+Shift+* selects the current area surrounding the active cell (the data region enclosed by the blank rows and blank columns). In the PivotTable, it will select the entire pivottable. Ctrl+Shift+: enter current time. Ctrl+Shift+ copy values from cells above active cells to cells or edit columns.. The Ctrl+Shift+ plus (+) shows the insert dialog box for inserting blank cells. Ctrl+ minus (-) to delete the selected cells display the delete dialog box. Ctrl+; enter the current date. Ctrl+` switches the c