Excel 快捷键大全(4)
发布时间:2021-06-08
发布时间: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
上一篇:12-5,6,end 位移电流 电磁场基本方程的积分形式
下一篇:外架施工技术交底