Uploaded by User94665

excel tutorial

advertisement
Press
To
F2
Edit current cell entry and position insertion point at the end of cell contents
Shift+F2
Edit comment attached to current cell and position insertion point in comment
box
Backspace
Delete character to left of insertion point when editing cell entry
Delete
Delete character to right of insertion point when editing cell entry: otherwise,
clear cell entries in current range
Esc
Cancel editing in current cell entry
Enter
Complete editing in current cell entry
Ctrl+C
Copy cell selection to the Windows Clipboard
Ctrl+X
Cut cell selection to the Windows Clipboard
Ctrl+V
Paste last copied or cut cells from the Windows Clipboard
Ctrl+hyphen (-)
Open Delete dialog box to delete cell selection and shift
remaining cells left or up
Ctrl+Shift+plus (+)
Open Insert dialog box to insert new cells and shift existing
cells right or down
Ctrl+Z
Undo last action
Ctrl+Y
Redo last undone action
Arrow keys
Complete cell entry and move cell cursor one cell in direction of the arrow
Enter
Complete cell entry and move cell cursor down one row
Shift+Enter
Complete cell entry and move cell cursor up one row
Ctrl+Enter
Complete cell entry in all cells in selected range
Alt+Enter
Begin a new line in a cell entry
Tab
Complete cell entry and move cell cursor right one column
Shift+Tab
Complete cell entry and move cell cursor left one column
Esc
Cancel current cell entry
Ctrl+’ (apostrophe)
Copy formula in cell above into current cell entry
Ctrl+Shift+” (quotation)
Copy value from cell above into current cell entry
Ctrl+`(accent)
Toggle between displaying cell values and cell formulas in worksheet
Ctrl+;
Insert current date into current cell entry
Ctrl+Shift+;
Insert current time into current cell entry
Download