vba快捷键（VBA shortcut key）.doc

vba快捷键（VBA shortcut key）A lot, most of them do not remember!Commonly used is usually suitable for all Windows operations: Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+Y, Ctrl+B, and so on-------------------------------------------------------------------Ctrl combination shortcut keyButton descriptionCtrl+ (to hide all hidden rows within the selected range.Ctrl+) to hide all hidden columns in the selected range.Ctrl+& applies the outline to the selected cell.Ctrl+_ removes frames from selected cells.Ctrl+~ applies the "regular" digital format.Ctrl+$applies a currency format with two decimal places (negative numbers in parentheses).Ctrl+% applies percentages in a format that does not have small digits.Ctrl+^ uses an index format with two decimal places.Ctrl+# applications have day, month, and year date formats.Ctrl+@ applications have hours and minutes, and AM or PM in the "time" format.Ctrl+! With two decimal places, thousands separator and minus (-) (negative for) the number format.Ctrl+- displays the delete dialog box used to delete selected cells.Ctrl+* 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+: enter current time.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+ "copy values from cells above active cells to cells or edit columns.".Ctrl++ displays the insert dialog box used to insert blank cells.Ctrl+1 displays the cell Format dialog box.Ctrl+2 apply or cancel bold formatting settings.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+7 displays or hides the frequently used toolbars.Ctrl+8 shows or hides outline symbols.Ctrl+9 hides selected rows.Ctrl+0 hides selected columns.Ctrl+A selects the entire worksheet.If the worksheet contains data, press Ctrl+A to select the current zone. Press Ctrl+A again to select the entire worksheet.When the insertion point is on the right of a function name in the formula, the function parameter dialog box is displayed.When the insertion point is on the right of a function name in the formula, press Ctrl+Shift+A to insert parameter names and parentheses.Ctrl+B apply or cancel bold formatting settings.Ctrl+C copies the selected cells.If Ctrl+C is pressed two times in a row, the Microsoft Office clipboard is displayed.Ctrl+D uses the down filling command to copy the contents and formats of the topmost cells in the selected range into the following cells.Ctrl+F displays the Find dialog box.Press Shift+F5 to display the dialog box, and press Shift+F4 to repeat the last "find" operation.Ctrl+G displays the Location dialog box.Press F5 to display this dialog box.Ctrl+H displays the find and Replace dialog box.Ctrl+I applies or cancels tilted formatting.Ctrl+K displays the insert Hyperlink dialog box for the new hyperlink, or displays the edit Hyperlink dialog box for the selected existing hyperlink.Ctrl+L displays the Create List dialog box.Ctrl+N creates a new blank file.Ctrl+O displays the open dialog box to open or find files.Press Ctrl+Shift+O to select all cells that contain annotations.Ctrl+P displays the print dialog box.Ctrl+R uses the right filling command to copy the contents and formats of the leftmost cells of the selected range to the cells on the right.Ctrl+S saves active files with its current file name, location, and file format.Ctrl+U apply or cancel underscore.Ctrl+V inserts the contents of the clipboard at the insertion point and replaces any of the selected content. Use this shortcut only after you have cut or copied objects, text, or cell contents.Ctrl+W closes the selected Workbook window.Ctrl+X cuts the selected cells.Ctrl+Y repeats a previous command or operation (if possible).Ctrl+Z uses the undo command to undo the last command or delete the last entry.When the AutoCorrect smart tag is displayed, press Ctrl+Shift+Z to undo or restore the last AutoCorrect operation using the undo or repeat command.Function keyButton descriptionF1 displays the help task pane.Press Ctrl+F1 to close and reopen the current task pane.Press Alt+F1 to create a chart of the data in the current range.Press Alt+Shift+F1 to insert a new worksheet.F2 edits the active cell and puts the insertion point at the end of the cell content. If you prohibit editing in cells, it also moves the insertion point to the edit bar.Press Shift+F2 to edit the cell annotation.F3 paste the name defined into the form。