Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
59 Cards in this Set
- Front
- Back
SELECT FROM DROP-DOWN LIST |
ALT + down arrow (select from displayed list) |
|
FORMAT CELLS DIALOG BOX |
CTRL + 1 |
|
BOLD |
CTRL + 2 CTRL + B |
|
ITALICS |
CTRL + 3 CTRL + I |
|
UNDERLINE |
CTRL + 4 CTRL + U |
|
STRIKETHROUGH |
CTRL + 5 |
|
HIDE OR DISPLAY OBJECTS |
CTRL + 6 |
|
HIDE OR DISPLAY OUTLINE |
CTRL + 8 |
|
HIDE SELECTED ROW |
CTRL + 9 |
|
HIDE SELECTED COLUMN |
CTRL + 0 |
|
SELECT ENTIRE WORKSHEET |
CTRL + A |
|
COPY |
CTRL + C |
|
PASTE |
CTRL + V |
|
COPY AND FILL DOWN |
SELECT RANGE + CTRL + D HOME -> EDITING GROUP -> FILL |
|
OFFICE THEMES |
FILE -> OPTIONS WHITE LIGHT GREY DARK GREY |
|
OFFICE BACKGROUNDS |
FILE -> OPTIONS or ALT + F + T |
|
CTRL + HOME |
GO TO CELL A1 |
|
GO TO LAST CELL IN COLUMN |
CTRL + DOWN ARROW |
|
GO TO LAST CELL IN TABLE |
CTRL + END |
|
GO TO LAST CELL IN ROW |
CTRL + RIGHT ARROW |
|
SELECT ENTIRE COLUMN |
CTRL + SHIFT + DOWN ARROW |
|
SELECT ENTIRE ROW |
CTRL + SHIFT + RIGHT ARROW |
|
CLOSE DIALOG BOX OR EXIT CELL |
ESC |
|
DISPLAY FORMULAS |
F2 |
|
SAVE AS |
CTRL + S F12 |
|
HELP |
F1 |
|
SPELL CHECK |
F7 |
|
REPEAT LAST COMMAND (REDO) |
F4 |
|
PASTE SPECIAL |
SELECT CELLS COPY (CTRL + C) SET TARGET LOCATION CTRL + ALT + V or ALT + E + S PASTE: all, formats, values, formulas, comments, validation, formula and number formats, column widths, values and number format, all using source theme, all but borders OPERATIONS: add, multiply, divide, subtract, OTHER: Transpose, skip blanks take on format of destination if in same program |
|
FLASH FILL (add values to the active column from the surrounding data) |
CTRL + E |
|
SELECT ALL |
CTRL + A when cursor not in a range CTRL + A + A when cursor in range |
|
SELECT RANGE |
CTRL + A when cursor in range |
|
NEW WORKBOOK |
CTRL + N |
|
SELECT COLUMN IN RANGE |
CTRL + SHIFT + DOWN ARROW |
|
INSERT CUT CELLS |
CTRL + SHIFT + "+" RIGHT CLICK + INSERT CUT CELLS |
|
INSERT COLUMN TO LEFT |
ALT + I + C |
|
INSERT ROW ABOVE |
ALT + I + R |
|
INSERT WORKSHEET |
ALT + I + W |
|
INSERT TODAY'S DATE |
CTRL + ; |
|
COMPLETE SERIES PATTERN |
GRAB AUTOFILL HANDLE AND DRAG |
|
COPY AND FILL RIGHT |
SELECT RANGE + CTRL + R HOME -> EDITING GROUP -> FILL |
|
CREATE CUSTOM LIST |
FILE -> OPTIONS -> ADVANCED -> EDIT CUSTOM LISTS 3 letter abbreviations or spelled out ONLY separate by comma or hard return access via any item in list text only import from Excel ONLY |
|
OPEN FILE TAB -> OPTIONS |
ALT + F + T |
|
FILL CELL RANGE WITH SAME TEXT |
HIGHLIGHT RANGE + TYPE ENTRY + CTRL + ENTER |
|
FILL NON-ADJACENT CELLS WITH SAME TEXT |
CLICK + SELECT CELLS -> TYPE TEXT -> CTRL + ENTER |
|
SELECT CELL RANGE |
SHIFT + CLICK LAST CELL IN RANGE |
|
GROUP WORKSHEETS |
CTRL + SELECT SHEET TABS |
|
UNGROUP WORKSHEETS |
RT-CLICK SHEET TAB CLICK SHEET TAB NOT IN GROUP |
|
DELETE COLUMN, ROW, CELL |
ALT + E + D |
|
DUPLICATE (COPY AND PASTE CELL RANGE ELSEWHERE, COPY SHAPE, WORKSHEET) |
SELECT RANGE -> CURSOR ON BORDER WITH 4-POINT CROSS -> CTRL + DRAG SELECT SHAPE + CTRL + DRAG SELECT SHEET TAB + CTRL + DRAG |
|
INSERT SHAPE |
ALT + N + S + H |
|
ARRANGE WINDOWS VERTICAL/HORIZONTAL/TILED/CASCADE |
VIEW TAB -> ARRANGE ALL |
|
HIDE/UNHIDE ROW or COLUMN |
RT-CLICK HEADER + HIDE/UNHIDE |
|
HIDE/UNHIDE ROWS OR COLUMNS |
HOME -> CELLS GROUP -> FORMAT -> HIDE & UNHIDE (row, column, sheet) |
|
FORMAT PAINTER |
HOME TAB -> CLIPBOARD GROUP |
|
REMOVE DUPLICATES |
SELECT RANGE (CTRL + A) -> DATA TAB -> REMOVE DUPS |
|
WORKBOOK VIEWS |
NORMAL PAGE BREAK PAGE LAYOUT CUSTOM |
|
ZOOM |
VIEW TAB -> ZOOM GROUP -> ZOOM, CHOOSE PERCENTAGE, ZOOM TO SELECTION OR ZOOM SLIDER ALT + V + Z |
|
SPLIT WINDOW |
VIEW TAB -> SPLIT REMOVE ONE BY CLICK AND DRAG OFF WORKSHEET |