全部快捷键

Automatically recognize patterns in adjacent columns and fill the current column based on the detected pattern.

Press F4 to toggle a selected cell reference or range in a formula between absolute ($A$1), mixed (A$1 or $A1), and relative (A1) references.

Opens the Insert Function dialog to search and select a function.

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

Inserts a chart as an object in the current worksheet using the selected data range.

Inserts a chart of the selected data range into a new Chart sheet.

Open the New Name dialog to define a named range or constant for use in formulas.

Open the Paste Name dialog box and paste a defined name into a formula.

Open the Macro dialog to create, run, edit, or delete macros.

Open the Microsoft Visual Basic for Applications (VBA) editor to write and edit macros.

Open the Power Query Editor to transform and clean data.

Refreshes the data in the active worksheet, updating external data connections and recalculating formulas.

Refreshes all data connections and queries in the current workbook.

Deletes the selected table in Excel.

Move the selected table to a new location in the worksheet.

Rename the active table in Excel.

Extends the selection from the active cell to the last used cell in the same column.

Extends the selection from the current cell to the first cell in the same column.

Extends the selection from the current cell to the last used cell in the same row.

Extends the selection from the current cell to the first cell in the same row.

Navigates to the topmost cell in the currently selected column.

Moves the active cell to the last cell in the current column that contains data or formatting.

Press Ctrl+Esc to close a dialog box or cancel an ongoing process like a paste operation.

Open the Go To dialog box to quickly navigate to a specific cell, range, or named reference.