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;
23 Cards in this Set
- Front
- Back
|
Alt + H + E + A |
Clear All Contents of a cell. (If you just hit delete, you, will not clear format. |
|
|
Shift + F2 |
Add Comments |
|
|
Control + R |
Right fill, saves the step of copying and pasting |
|
|
Alt + I + R |
Insert Row |
|
|
Alt + E + S + T |
Special Paste Just format |
|
|
Alt + I + C |
Inset A Column |
|
|
Alt + H + S + Transpose |
Turns vertical data horizontal or vice versa, be careful using formulas. |
|
|
Ctrl + Shift + ! |
Number format: 2 decimals, 000 seperator |
|
|
Ctrl + Shift + $ |
Currency format, 2 decimals |
|
|
Ctrl + Shift + % |
Percentage Format with no decimal placves |
|
|
Ctrl + Shift + # |
Date Format with the day, month, and year |
|
|
Ctrl + Shift + _ |
Remove all borders |
|
|
Ctrl + Y |
Redo |
|
|
Ctrl + F3 |
Houses names in a cell |
|
|
F4 |
Anchor a cell, make it so if you copy it, it stays. Keep hiting through F4 to switch through anchoring options. |
|
|
Alt + H + O + R |
Edit Name |
|
|
Hide |
Alt + A + H |
|
|
Unhide |
Alt + A + J |
|
|
Find Precendent Cells Of A Formula |
Crtl + [ |
|
|
Finding the Decendent Cells of a Formula |
Crtl + ] |
|
|
Trace Precendent Cells of a Formula |
Alt + M + P. Will show previous go cells in the formula |
|
|
Trace Decendent Cells of a Formula |
Alt + M + D will show formulas affected by cell. |
|
|
Identify Constants Vs. Formulas For Formatting |
F5, then Alt + S to go for specials |
