Excel 快捷键大全(4)

发布时间:2021-06-08

excel shortcut..

ALT+O H R

Rename the current sheet (Format menu, Sheet submenu, Rename command).

ALT+E M

Move or copy the current sheet (Edit menu, Move or Copy Sheet command).

ALT+E L

Delete the current sheet (Edit menu, Delete Sheet command).

Navigating in a Worksheet

Arrow keys

Move one cell up, down, left, or right.

CTRL+arrow key

Move to the edge of the current data region.

HOME

Move to the beginning of the row.

CTRL+HOME

Move to the beginning of the worksheet.

CTRL+END

Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.

PAGE DOWN

Move down one screen.

PAGE UP

Move up one screen.

ALT+PAGE DOWN

Move one screen to the right.

ALT+PAGE UP

Move one screen to the left.

F6

Switch to the next pane in a worksheet that has been split (Window menu, Split command).

SHIFT+F6

Switch to the previous pane in a worksheet that has been split.

CTRL+BACKSPACE

Scroll to display the active cell.

F5

Display the Go To dialog box.

F5 Enter

Takes you to the last place you left from

SHIFT+F5

Display the Find dialog box.

SHIFT+F4

Repeat the last Find action (same as Find Next).

TAB

Move between unlocked cells on a protected worksheet.

Move within selected region(s)

ENTER

Move from top to bottom within the selected range.

SHIFT+ENTER

Move from bottom to top within the selected range.

TAB

Move from left to right within the selected range. If cells in a single column are selected, move down.

SHIFT+TAB

Excel 快捷键大全(4).doc 将本文的Word文档下载到电脑

精彩图片

热门精选

大家正在看

× 游客快捷下载通道(下载后可以自由复制和排版)

限时特价:7 元/份 原价:20元

支付方式:

开通VIP包月会员 特价:29元/月

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信:fanwen365 QQ:370150219