Advertisement
Table 14: Entering and Editing Data Shortcuts
To Select
Complete an entry
Cancel an entry
Complete a cell and move down
Move to the beginning of a line
Move to the end of a line
Delete the contents of the selected cell
Activate cell
Fill down
Fill to the right
Fill the selected range with the current
entry
Open the Replace With dialog box
Calculate all open sheets
Hide row
Unhide row
Hide column
Unhide column
Enter current date
Enter current time
Press
ENTER
ESC
ENTER
ALT + HOME
ALT + END
SHIFT + BACKSPACE
CTRL + E
CTRL + D
CTRL + R
CTRL + ENTER
CTRL + H
CTRL + =
CTRL + 9
CTRL + SHIFT + 9
CTRL + 0
CTRL + SHIFT + 0
CTRL + ;
CTRL + :
Windows CE
5 - 57
Advertisement
