Excel Shortcuts (with modded excel) Flashcards
COPY
CRTL + C
PASTE
CRTL + V
UNDO
CRTL + Z
REDO
CRTL + Y
OPEN FILE
CRTL + O
NEW FILE
CRTL + N
CRTL + P
SAVE
CRTL + S
SAVE AS
F12
GO TO NEW WORKBOOK (DIF TAB)
CRTL + TAB
CLOSE FILE
CRTL + F4
OPEN FORMAT CELLS DIALOG
CRTL + 1
BOLD
CRTL + B
ITALIC
CRTL + I
UNDERLINE
CRTL + U
NUMBER FORMAT
CRTL + SHIFT + 1
PERCENT FORMAT
CRTL + SHIFT + 5
DATE FORMAT
CRTL + SHIFT + 3
INCREASE FONT SIZE
ALT H FG
DECREASE FONT SIZE
ALT H FK
INSERT/EDIT COMMENT
SHIFT + F2
INCREASE DECIMAL
ALT H 0
DECREASE DECIMAL
ALT H 9
INCREASE INDENT
ALT H 6
DECREASE INDENT
ALT H 5
CLEAR CELL DATA
DELETE
CLEAR CELL FORMATS
ALT H E F
CLEAR ALL
ALT H E A
OUTLINE BORDER
CRTL + SHIFT + 7
REMOVE BORDER
CRTL +SHIFT + -
LEFT BORDER
ALT H B L
RIGHT BORDER
ALT H B R
TOP BORDER
ALT H B P
BOTTOM BORDER
ALT H B O
PASTE SPECIAL FORMATS
CRTL + ALT + V T
PASTE SPECIAL VALUES
CRTL + ALT + V V
PASTE SPECIAL FORMULAS
CRTL + ALT + V F
PASTE SPECIAL COMMENTS
CRTL + ALT + V C
SHOW RIBBON ACCELERATOR KEYS
ALT
SHOW/HIDE RIBBON
CRTL+F1
MOVE ONE SCREEN LEFT
ALT + PGUP
MOVE ONE SCREEN RIGHT
ALT+ PGDOWN
GOT TO CELL A1
CRTL + HOME
GO TO BEGINNING OF ROW
HOME
OPEN THE GO TO DIALOG BOX
F5
FIND AND REPLACE
CRTL + F
HIGHLIGHT CELLS WITH COMMENTS
F5 ALT S C
EDIT THE ACTIVE CELL
F2
WHILE EDITING CELL, ALLOW USE OF ARROW KEYS TO CREATE REFERENCE
F2
CONFIRM CHANGE AND LEAVE CELL
ENTER
CANCEL CELL ENTRY AND LEAVE CELL
ESC
INSERT LINE BREAK WITHIN CELL
ALT + ENTER
JUMP TO BEGINNING OF CELL
HOME
JUMP TO END OF CELL
END
REFERENCE A CELL FROM ANOTHER WORK SHEET
CRTL + PG(UP/DN) ARROWS
RECALCULATE ALL WORKSHEETS
F9
ANCHOR CELLS
F4
OPEN INSERT FORMULA DIALOG
SHIFT + F3
ENTER ARRAY FORMULA (IN EDIT MODE)
SHIFT+CRTL+ENTER
INSPECT CELL VALUES
F9
SWITCH TO FORMULA VIEW
CRTL + ~
GO TO LAST CELL
F5 + ENTER
SELECT COLUMN
CRTL + SPACE
SELECT ROW
SHIFT + SPACE
DELETE ROW(S)/COLUMN(S)
CRTL + -
ADD ROW(S)/COLUMN(S)
CRTL + SHIFT + +
SET COLUMN WIDTH
ALT H O W
AUTOFIT COLUMN WIDTH
ALT H O I
FIT TO SPECIFIC ROW HEIGHT
ALT H O H
GROUP ROWS/COLUMNS
ALT+SHIFT+ ->
UNGROUP ROWS/COLUMNS
ALT+SHIFT+
JUMP TO NEXT WORKSHEET
CRTL+PGDN
JUMP TO PREVIOUS WORKSHEET
CRTL+PGUP
CHANGE WORKSHEET NAME
ALT H O R
REARRANGE TAB ORDER
ALT H O M
FREEZE PANE
ALT W F F
SPLIT SCREEN
ALT W S
CLOSE HELP (AND OTHER PANES)
CRTL + SPACE
Add new worksheet
SHIFT + F11