快捷键库

全部快捷键

浏览所有已发布的快捷键。如果你想看完整目录,而不是交互工具,就从这里开始。

打开探索
Microsoft Excel

Toggle Cell Values and Formulas

Switch between displaying cell values and formulas in the active worksheet.

Ctrl + `
Microsoft Excel

Copy Formula from Cell Above

Copies the formula from the cell directly above the active cell into the current cell or the formula bar.

Ctrl + '
Microsoft Excel

Open Paste Special Dialog

Opens the Paste Special dialog box, allowing you to choose how to paste copied content (e.g., values, formats, formulas).

Ctrl + Alt + V
Microsoft Excel

Italicize text or remove italic formatting

Toggle italic formatting on selected text.

Ctrl + 3
Microsoft Excel

Toggle Bold Formatting

Toggle bold formatting on selected text or remove existing bold formatting.

Ctrl + 2
Microsoft Excel

Underline text or remove underline

Underline selected text or remove underline from selected text.

Ctrl + 4
Microsoft Excel

Apply or remove strikethrough formatting

Toggle strikethrough on selected text in supported applications.

Ctrl + 5
Microsoft Excel

Toggle Object Display Modes

Cycle through hiding objects, displaying objects, and showing placeholders for objects.

Ctrl + 6
Microsoft Excel

Apply outline border to selected cells

Adds an outline border around the currently selected cells in Excel or similar spreadsheet applications.

Ctrl + Shift + &
Microsoft Excel

Remove outline border from selected cells

Removes the outline border from the currently selected cells in a spreadsheet or table.

Ctrl + Shift + _
Microsoft Excel

Toggle Outline Symbols Visibility

Show or hide outline symbols (grouping indicators) in the current worksheet or document.

Ctrl + 8
Microsoft Excel

Apply General Number Format

Apply the General number format to selected cells.

Ctrl + Shift + ~
Microsoft Excel

Apply Currency Format with Two Decimals and Parentheses for Negatives

Applies the Currency number format with two decimal places and encloses negative numbers in parentheses.

Ctrl + Shift + $
Microsoft Excel

Apply Percentage Format with No Decimal Places

Apply the Percentage number format to selected cells, displaying values as percentages with zero decimal places.

Ctrl + Shift + %
Microsoft Excel

Apply Scientific Number Format with Two Decimal Places

Apply the Scientific number format with two decimal places to the selected cell(s).

Ctrl + Shift + ^
Microsoft Excel

Apply Date Format with Day, Month, Year

Applies the date format displaying day, month, and year to the selected cell in Excel.

Ctrl + Shift + #
Microsoft Excel

Apply Time Format (Hour:Minute AM/PM)

Apply the time format displaying hour, minute, and AM/PM designation to the selected cell or content.

Ctrl + Shift + @
Microsoft Excel

Apply Number Format with Two Decimals and Thousands Separator

Applies the Number format with two decimal places, thousands separator, and minus sign for negative values.

Ctrl + Shift + !
Microsoft Excel

Open Insert Hyperlink Dialog Box

Open the Insert Hyperlink dialog box to add or edit a hyperlink in the selected cell.

Ctrl + K
Microsoft Excel

Check Spelling

Opens the Spelling dialog to check spelling in the active worksheet or selected range.

F7
Microsoft Excel

Display Quick Analysis Options

Open the Quick Analysis tool for selected cells containing data.

Ctrl + Q
Microsoft Excel

Open Workbook Statistics Dialog

Open the Workbook Statistics dialog box to view details about the current workbook, such as the number of sheets, cells, formulas, and more.

Ctrl + Shift + G
Microsoft Excel

Select the entire worksheet

Selects all cells in the active worksheet.

Ctrl + A
Microsoft Excel

Select entire worksheet

Selects all cells in the active worksheet, including the entire data range and empty cells.

Ctrl + Shift + Space