excle中所有的快捷键（All shortcut keys in excle）
The best answer is in the help. For example, my name is 2007, arch the shortcut key in the help, and you can find the Excel shortcut key and function key
Ctrl combination shortcut key
Button description
Ctrl+Shift+ (to hide all hidden rows within the lected range.
Ctrl+Shift+) to hide all hidden columns in the lected range.
Ctrl+Shift+& applies the outline to the lected cell.
Ctrl+Shift_ removes frames from lected cells.
Ctrl+Shift+~ applies the "regular" digital format.
Ctrl+Shift+$applies a currency format with two decimal places (negative numbers in parenthes).
Ctrl+Shift+% applies percentages in a format that does not have small digits.
Ctrl+Shift+^ us 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 parator and minus (-) (negative for) the number format.
水环境容量
Ctrl+Shift+* lects the current area surrounding the active cell (the data region enclod by the blank rows and blank columns).
In the PivotTable, it will lect 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 inrt dialog box for inrting blank cells.
Ctrl+ minus (-) to delete the lected cells display the delete dialog box.
Ctrl+; enter the current date.
Ctrl+` switches the cell values and formulas in the worksheet.
折纸飞机教案
Ctrl+'copies the formula from the cells above the active cell to the cell or edit column.
Ctrl+1 displays the cell Format dialog box.
Ctrl+3 applies or cancels tilted formatting.事后监督
Ctrl+4 apply or cancel underscore.
学习效果评价Ctrl+5 apply or cancel the line.
Ctrl+6 switches between hidden objects, display objects, and display object placeholders.
Ctrl+8 shows or hides outline symbols.
Ctrl+9 hides lected rows.
Ctrl+0 hides lected columns.
羊肉怎么炖才好吃
Ctrl+A lects the entire worksheet.
送杯子的含义If the worksheet contains data, then press Ctrl+A to lect the current region, press Ctrl+A again, lect the current region and its header, and lect the entire worksheet by pressing the Ctrl+A for the third time.
When the inrtion point is on the right of a function name in the formula, the function parameter dialog box is displayed.
猪头做法When the inrtion point is on the right of a function name in the formula, press Ctrl+Shift+A to inrt parameter names and parenthes.
Ctrl+C copies the lected cells.
If you press Ctrl+C two times in a row, the clipboard will be displayed.
Ctrl+D us the down filling command to copy the contents and formats of the topmost cells in the lected range into the following cells.
Ctrl+F displays the find and Replace dialog box, where the find tab is in the lected state.
Press Shift+F5 to also display this tab, and press Shift+F4 to repeat the last find operation.
Press Ctrl+Shift+F to open the t cell Format dialog box, where the Font tab is in the lected state.
Ctrl+G displays the Location dialog box.
Press F5 to display this dialog box.
氡气怎么读Ctrl+H displays the find and Replace dialog box, where the replace tab is in the lected state.
Ctrl+I applies or cancels tilted formatting.
Ctrl+K displays the inrt Hyperlink dialog box for the new hyperlink, or displays the edit Hyperlink dialog box for the
lected existing hyperlink.
Ctrl+N creates a new blank workbook.
Ctrl+O displays the open dialog box to open or find files.
Press Ctrl+Shift+O to lect all cells that contain annotations.
Ctrl+P displays the print dialog box.
Press Ctrl+Shift+P to open the t cell Format dialog box, where the Font tab is in the lected state.
Ctrl+R us the right filling command to copy the contents and formats of the leftmost cells of the lected range to the cells on the right.
Ctrl+S saves active files with its current file name, location, and file format.
Ctrl+T displays the Create Table dialog box.
Ctrl+U apply or cancel underscore.
Press Ctrl+Shift+U to switch between the unfolded and collapd edit columns.
Ctrl+V inrts the contents of the clipboard at the inrtion point,
