快捷键库

全部快捷键

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

打开探索
Microsoft Excel

Move to last cell in worksheet

Move the active cell to the last cell on the worksheet, which is the intersection of the lowest used row and the rightmost used column.

Ctrl + End
Microsoft Excel

Extend selection to last used cell

Extends the current selection from the active cell to the last used cell (lower-right corner) of the worksheet.

Ctrl + Shift + End
Microsoft Excel

Move to the cell in the upper-left corner of the window when Scroll lock is turned on.

Home + Scroll lock
Microsoft Excel

Move to the beginning of a worksheet

Move the active cell to the top-left cell (A1) of the worksheet.

Ctrl + Home
Microsoft Excel

Move one screen down in a worksheet

Scroll the worksheet view down by one screenful.

PgDn
Microsoft Excel

Move to Next Sheet

Switch to the next worksheet in the current workbook.

Ctrl + PgDn
Microsoft Excel

Move one screen to the right in a worksheet.

Alt + PgDn
Microsoft Excel

Move one screen up in a worksheet

Scroll the worksheet view up by one screenful using the Page Up key.

PgUp
Microsoft Excel

Move one screen to the left in a worksheet.

Alt + PgUp
Microsoft Excel

Move to the previous sheet in a workbook.

Ctrl + PgUp
Microsoft Excel

Cycle through floating shapes, such as text boxes or images.

Ctrl + Alt + 5
Microsoft Excel

Exit the floating shape navigation and return to the normal navigation.

Esc
Microsoft Excel

Scroll horizontally.

Ctrl + Shift
Microsoft Excel

Zoom In

Zoom in on the worksheet to get a closer view of cell content.

Ctrl + Alt + =
Microsoft Excel

Zoom out

Zoom out of the current worksheet or document.

Ctrl + Alt + -
Microsoft Excel

Open Format Cells Dialog Box

Open the Format Cells dialog box to change cell formatting options like number, alignment, font, border, and fill.

Ctrl + 1
Microsoft Excel

Format fonts in the Format Cells dialog box

Open the Format Cells dialog box with the Font tab selected to change font settings.

Ctrl + Shift + F
Microsoft Excel

Format fonts in the Format Cells dialog box

Open the Format Cells dialog box and navigate to the Font tab to change font settings.

Ctrl + Shift + P
Microsoft Excel

Insert or Edit a Cell Note

Insert a new note or open and edit an existing cell note in Excel.

Shift + F2
Microsoft Excel

Insert or Reply to Threaded Comment

Insert a new threaded comment or open and reply to an existing one in supported apps like Microsoft Word or Outlook.

Ctrl + Shift + F2
Microsoft Excel

Open Insert Dialog Box for Blank Cells

Opens the Insert dialog box to add blank cells, rows, or columns in Excel.

Ctrl + Shift
Microsoft Excel

Open Delete Dialog Box

Open the Delete dialog box to remove selected cells.

Ctrl + -
Microsoft Excel

Insert Current Time

Inserts the current time into a document or text field.

Ctrl + Shift + :
Microsoft Excel

Enter current date

Insert the current date into a document, spreadsheet, or text field.

Ctrl + ;